Posts

Showing posts with the label office 365

Microsoft Flow PowerApps Projects Time Management Apps - Part 1

Image
Goal is to be able to manage how much time (in hours and minutes) the company spent each month.  Each Employee should write down when he started and when he finished, and calculate the time.  At each period of time we should be able to get a report of total time spend per client.  Design:  Data will be 2 SharePoint lists, one for clients names, other for the time spent.  List 1 is Title only for client name.  List 2: Title - client name Created - start time Created By - employee EndTime - end time ☺ TotalTime - calculated field for time ( =TEXT(EndTime-Created, "hh:mm") ) App1 - Employee chooses client, has 2 buttons, start and end App2 - Manager can choose month and gets a list of clients with their total time Lets start, SP as states App1 Drop "Items" Connected to SPList and "Value" to Title. Button Start to Flow is very simple, create a sharepoint list item with title of selected client. Since i wanted some message in the app i had the flow to return so...

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...

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 tw...