Question

Explain how to configure Power Automate to automatically generate a digest email summarizing new SharePoint list items added during the previous week.

Accepted Answer

To configure Power Automate to automatically generate a digest email summarizing new SharePoint list items added during the previous week, you need to create a scheduled flow that retrieves the list items, formats them, and sends them in an email. Start by creating a new 'Scheduled cloud flow' in Power Automate and set it to run weekly (e.g., every Monday morning). The first action should be 'Get items' from the SharePoint connector. Configure this action to connect to your SharePoint site and the specific list you want to summarize. Use a filter query to retrieve only the items added during the previous week. This can be achieved using the 'Created' column and the 'OData filter query' feature. The filter should compare the 'Created' date to the start and end dates of the previous week, using expressions like 'Created ge addDays(utcNow(),-7)' and 'Created le utcNow()'. Next, add a 'Compose' action to format the list items into a readable HTML table or list. This action will use the output from the 'Get items' action. Use HTML tags within the 'Compose' action to structure the email content (e.g., , ,

tags). You can use expressions to extract specific fields from each list item (e.g., Title, Description, Created date) and include them in the HTML. After formatting the list items, add a 'Send an email (V2)' action. Configure this action to specify the recipient's email address, the subject line (e.g., 'Weekly SharePoint List Digest'), and the body of the email. In the body, include the output from the 'Compose' action (the formatted HTML content). Ensure the 'Is HTML' option is set to 'Yes' to correctly render the HTML content in the email. Finally, test the flow to ensure it retrieves the correct list items, formats them properly, and sends the email to the intended recipient. If needed, add error handling (e.g., using a 'Terminate' action) to handle cases where no new list items were added during the previous week, preventing an empty email from being sent.

Home → All Courses → Engineering and Technology Courses → Office.com: Microsoft 365 Business Visibility and Communication Tools Certification → Flashcard

Explain how to configure Power Automate to automatically generate a digest email summarizing new SharePoint list items added during the previous week.