I've got a standard flow that notifies me and my client when files are added or modified in a SharePoint file and also refreshes a PBI dataset.
Every month there will typically be 5 new files added and ideally I'd like there to be a single email with a summary rather than 5 individual emails I'm currently getting.
Anyone got any idea of how best to accomplish this?
Many thanks,
To do this as one email you'll have to switch the trigger to a recurrence trigger that fires once a month rather than a trigger that fires everytime a file is created or modified. Then do a get Files (properties Only) after the trigger and use a filter array to filter out any file that wasn't modified in the last 30 days. Use a loop to gather the information on the files into a variable and then send the email.
User | Count |
---|---|
88 | |
43 | |
21 | |
18 | |
16 |
User | Count |
---|---|
132 | |
47 | |
42 | |
36 | |
28 |