Share
Report
4Hi All,
I'm rather new at Power Automate and have been looking everywhere for a solution for this request but can't find what I need anywhere (think I'm just searching wrong tbh)
I need to create a Summary Report from SharePoint list on the last 5 days worth of data and then group this by area and by site. This will be need to include the count of each status for the site - this is where I'm struggling.
The Data would be:
| DateCreated | Area | Site | Status |
| 02/01/22 | 01 | 00001 | In Progress |
| 02/01/22 | 01 | 00001 | Completed |
| 03/01/22 | 02 | 00002 | Completed |
| 03/01/22 | 03 | 00003 | Rejected |
| 05/01/22 | 04 | 00004 | Assigned |
| 05/01/22 | 04 | 00005 | Completed |
What would like to happen into the emails is:
E-Mail to Area Manager 01
| Site | Assigned | In Progress | Completed | Rejected | Total |
| 00001 | 0 | 1 | 1 | 0 | 2 |
E-Mail to Area Manager 02
| Site | Assigned | In Progress | Completed | Rejected | Total |
| 00002 | 0 | 0 | 1 | 0 | 1 |
E-Mail to Area Manager 03
| Site | Assigned | In Progress | Completed | Rejected | Total |
| 00003 | 0 | 0 | 0 | 1 | 1 |
E-Mail to Area Manager 04
| Site | Assigned | In Progress | Completed | Rejected | Total |
| 00004 | 1 | 0 | 0 | 0 | 1 |
| 00005 | 0 | 0 | 1 | 0 | 1 |
Does anyone have any guides available online which can easily break this down to how I want to or best Ideas?
Not asking someone to write this for me, would rather learn how best to approach this?
All responses (
Answers (
