Automate your weekly summary report from SharePoint List (Image Edition)

Photo by Elizeu Dias on Unsplash

Introduction

From time to time, you might be asked to create a summary report. A summary report can be time consuming and repetitive. In this article, we are going to automate the process of creating and sending a summary report via email

Weekly Summary Report via Email

Pre-Requisites

Before we get started, I would like to highlight that this article only focuses on using data from SharePoint List to create a weekly summary report and our data structure for this article looks like this:

Data from SharePoint List

Free Resource Download

I have also uploaded a copy of the flow here for you to download if you get stuck.

Outline

1. Set a schedule in Power Automate
2. Get Items from Data Source (SharePoint List)
3. Create a table header using HTML
4. Check if a row has attachments
5. If yes, create table rows in…