Prepare weekly summary report for all changes of a list with Power Automate to substitute the alert

(0) Share

Report

Posted on by CU09011419-0

Hi community

I learned today that Microsoft will switch off the alters, which is a huge problem.

We have set up an alert for a Sharepoint list (Audit Action Plan): weekly summary of all changes done on this list in the last week.

I'm an absolute beginner in Power Automate. Can somebody help me setting up a workflow to substitute the weekly alert?

I would like to have still the functionality that the e-mail contains a list of all changes with a link pointing directly to the specific entry of the SharePoint list.

many thanks in advance

Christina

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

lbendlin 8,703 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Do you have a reference/link for that planned change?

Was this reply helpful? Yes No
CU09011419-0 9 on at

Like (0)

Report
Copy link

Link copied!

Hi @lbendlin

please have a look at the attached screenshot. It's a standard Sharepoint alert sending a weekly summary on Friday at 12:00

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 6,996 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU09011419-0,

Are you specifying about the SharePoint Alerts retirement ?

Can you please explain your challenge in the implementation so that we can propose some solution or able to assist but with the generic query we cannot provide solution.

I will also share basic step by step Power Automate blogs.

https://www.spguides.com/power-automate/ this will have some some use cases covered along with step by step implementation.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

Was this reply helpful? Yes No
lbendlin 8,703 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

believe Microsoft 365 customers will be better served by modern notification solutions

Sure, sure. Sounds like "To improve customer experience we are removing the following features". I don't think you will be able to generate anything even remotely similar to this with Power Automate, especially when your SharePoint is a bit on the heavier side. You will have to decide which specific events you want to track (with aggressive use of OData filters) and how to format the results in a meaningful way.

Was this reply helpful? Yes No
CU09011419-0 9 on at

Like (0)

Report
Copy link

Link copied!

Hello @lbendlin,

thank you for the information. Yes- it's about the SharePoint Alerts retirement.

I'm very disappointed that this functionality is no longer available.

It is super helpful and super easy to set up.

With Power Automate it's a mess.

If Microsoft would provide some Power Automate templates for such weekly or daily summaries, it would be more than helpful.

Was this reply helpful? Yes No
Suggested answer

David_MA 14,516 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
You would need to do the following:

Create a scheduled flow that runs on the day you want to get the report.

Add a Get items action and point it to the list.

Add a filter query to only get items where Modified ge the current date minus 7 days and the modified by email value is not equal to value needed to account for the item being modified by someone else.

You can then use the Select action on the items returned in the Get items action to get the values you want in your report.

Then use the Convert to HTML table action to convert the data in the Select action.

Finally, use a send e-mail action and put the output of the Convert to HTML table action in the body of the email.

This is not going to be a 1:1 replacement to the current alert, but it is about as close as you can get. If you don't know what query filters are in Power Automate, this is a good resource to learn about them: Power Automate OData Filter Query with Examples.

There are some limits with this. For example, about how many items are usually modified each week? If it is more than 100, you will need to enable paging on the get items action as it only returns a max of 100 items by default.

I have never really used the SharePoint alerts feature, so I do not recall whether it actually lists what has been changed, or if it just says the item has been modified. If it actually shows you what has been changed, the above is not going to do that. If you really need to know what was changed, I suggest training users on how to review the version history of items to see what has changed and by whom. Otherwise, this will get very complicated.

Was this reply helpful? Yes No
CU09011419-0 9 on at

Like (0)

Report
Copy link

Link copied!

Hi David MA

thank you very much for your answer. Sounds very interesting.

we need the alert because the admin of the list needs to get an overview about the changes. We have a list of several hundred entries and it is impossible to check the history of each single entry. I don’t think that there are more than 100 modified per week, I think between 10 and 50.

would it be possible to send me a screenshot or a better instruction? How to set up this Power Automate flow? I’m new to Power Automate so I would need a little bit more advice, please

Was this reply helpful? Yes No