{"id":110911,"date":"2017-12-07T08:46:27","date_gmt":"2017-12-07T16:46:27","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/automate-sending-weekly-reports\/"},"modified":"2017-12-07T08:46:27","modified_gmt":"2017-12-07T16:46:27","slug":"automate-sending-weekly-reports","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/automate-sending-weekly-reports\/","title":{"rendered":"Intermediate | Flow of the Week: Automate emailing a weekly .xls file from a SharePoint List."},"content":{"rendered":"
Greetings Flow Fans!<\/p>\n
Ever feel like there aren’t enough hours in the day to complete those mundane tasks on top of meetings, projects and high-pressure deadlines? I certainly do. If you’re like me, you know that time is precious in the working world. But what if I showed you how to give yourself back time and never worry about that busy work again? With Microsoft Flow, you can!<\/p>\n
I am a social content writer and Community Manager of the PowerApps Community (previously Microsoft Flow Community Manager.) I spend most of my work day writing, designing, editing, and reading when I’m not in meetings or events. Flow came to my rescue\u00a0 when I was writing content for the Microsoft Flow Twitter Account. Every week, I was responsible for providing the social media team with a list of tweets, graphics, and media for the following week. to be sent out each week.<\/p>\n
My Flow automates submitting Twitter content each week. At first, my process consisted of back and forth emails between teams, random technical issues when sending content, and zero formatting. With Flow, I am able to write organized content, send it to the proper stakeholders, and deliver content consistently on time. This Flow can work for various scenarios in a variety of industries. It’s a huge timesaver and easy to create!<\/p>\n
To create this Flow, you will need the following:<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SharePoint Site & List<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Office 365 Outlook Account<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OneDrive for Business Account<\/p>\n
Now, let’s start building the Flow<\/p>\n
1. Sign in to\u00a0Microsoft Flow<\/u><\/a>\u00a0if you haven’t already.<\/p>\n 2. Click on\u00a0My Flows\u00a0<\/b>at the top of the page.<\/p>\n 3. Select\u00a0Create From Blank +<\/b>.<\/p>\n 4. Type\u00a0Schedule Recurrence <\/b>in the search box. Enter the day of the week, time of day, and interval frequency values in the fields below.\u00a0<\/p>\n <\/p>\n Next, let’s add an action.<\/p>\n Type Compose <\/b>into the box, and select the expression utcNow(). <\/b>Selecting this action will return each flow run’s \u00a0timestamp as a string, for example:\u00a02017-03-15T13:27:36Z:<\/p>\n <\/p>\n 5. Type\u00a0SharePoint<\/b>\u00a0into the box, and select the action\u00a0Get items<\/b>. This will connect to a SharePoint list with the content scheduled for that week.\u00a0<\/p>\n <\/p>\n 6. Next, type Create HTML Table <\/b>in the box, and select value extracted from your previous SharePoint action. Select Custom <\/b>in the Columns box. Select the values that correspond with the column titles from your selected SharePoint list from Get Items. This Data Operations action will pull data from the SharePoint list and convert it into an HTML table.\u00a0<\/p>\n <\/p>\n Time for another action!<\/p>\n 7. Type OneDrive for Business<\/b> and select the action Create File<\/b>. Select the folder you wish to map to in Folder Path. Next, select Output<\/b> for both the File Name and File Content boxes. Be sure to include .xls<\/b> after the Output value in File Name. This will indicate that the HTML file will be saved as an Excel spreadsheet.\u00a0<\/p>\n <\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 And add an action!<\/p>\n 8. Type OneDrive for Business<\/b> and select the trigger When a File is created.\u00a0 <\/b>Select the folder path you entered in your previous action.\u00a0<\/p>\n <\/p>\n 9. Type OneDrive for Business<\/b> and select the action List Files in Folder<\/b>. Select the folder path you entered in your previous action.<\/p>\n 10. Now for the final OneDrive for Business action. Type OneDrive for Business<\/b> and select the action Create share link by path<\/b>. Select File Path<\/b> for the\u00a0 File Path Box. Choose to send a direct link<\/b> within your organization<\/b>. This allows the excel file created from our SharePoint list to be sent as a direct link ONLY to someone within your team or organization. \u00a0<\/p>\n <\/p>\n 11. Type Office 365 Outlook<\/b> and select the action Send an Email<\/b>. This will be sent to the social media team with a link that will download a copy of our Excel Sheet file. In Body, you MUST select Add Dynamic Content<\/b> and add the value WebURL<\/b>. If you do not include this in the email body, recipients will not have a way to download the Excel file.<\/p>\n <\/p>\n \u00a0<\/p>\n I hope you enjoyed this walkthrough of my content flow. If you liked what you saw today, let me know! Leave a message below, Message me on the Power Users Community (@mackenzie_lyng<\/u><\/a>), connect with me on Twitter<\/u><\/a>, or email me directly<\/a>!<\/p>\n \u00a0<\/p>\n Until next time! ?<\/p>\n \u00a0<\/p>\n","protected":false},"excerpt":{"rendered":" Community Manager for PowerApps, Mackenzie Lyng teaches us how she created a Flow to automate sending a weekly report to the Social Media and Marketing team to streamline her process and save herself time!<\/p>\n","protected":false},"author":359,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2590,2836],"power-automate-tag":[2485,2591,2599,2638,2753,2818],"coauthors":[2342],"class_list":["post-110911","power-automate","type-power-automate","status-publish","hentry","power-automate-category-flow-of-the-week","power-automate-category-walkthroughs","power-automate-tag-business-process","power-automate-tag-flow-of-the-week","power-automate-tag-fotw","power-automate-tag-intermediate","power-automate-tag-productivity","power-automate-tag-tutorial"],"yoast_head":"\n