Posts

Showing posts from December, 2018

Microsoft Flow - Form, into excel, create word document from template, send email, addressing Copy/Create File errors

Image
Today a customer showed me a paper (invoice) recipe  he had to write into an excel, and then again into a word "thank you" for printing/emailing.

If you're here for the Copy/Create File errors, jump to the end.

So what we did is to prepare a Form for inputs, and then a Flow that takes that data, use "Insert Row" for excel.

Next was to create the word document. I've tried to create custom properties myself, but didn't manage so I followed Netwoven's tutorial, and the simple steps are:

1 - Create a Sharepoint Document Library and add your custom properties to the library as custom Fields.
2 - Go to Library Settings > Advanced Settings > click Edit Template
3 - The template will open an empty word document, edit it however you want
4 - Wherever you want one of the dynamic custom properties to fit in put your cursor there and click Insert > Quick Parts > Document Property > your custom Fields name
5 - Save the document as a normal .docx in…

Microsoft Flow - auto post in twitter and pinterest

The task at hand - a form, when filled, creates a post at [all] social networks, this blog is about twitter and pinterest.

Part 1 - prepare the image Twitter needs "file content" in its media field, while pinterest needs an image url open to the public. So [1st flow] was in OneDrive folder for those uploaded images, sending back the image ID to be used in the form. Can take a few minutes, sent to mail (better to send with the image).
The twitter account will create the public url for the image.
Part 2 - the form Most simple form, Title, Content and image id into [2nd flow] a Sharepoint list. If you're sure you're never going to use more than 255 characters you can just use the title (i dont like to extend title fields characters limit).
Part 3 - to the social media Next [3rd flow] when the SPItem is created, I use OneDrive "Get file content" for the file content and the "Title - Content" for the text, and post a new tweet. I then query tweets as &…