Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

SharePoint Archive Flow Email Summary

I have built a Flow that runs every week which gets items from a SharePoint list and works its way through various conditions to determine if each item can be archived. If it can be archived, the Flow then copies the item into a separate "Archive" list and then deletes it from the original list. 

Is it possible to send an email once each weekly Flow run has completed, to summarise the total number of items that have been archived that week?

Super User
Super User

Hi @Sam12 

In your flow, for any archived element, you could save this information into an Excel file (add a row into an Excel file), for example, that would be the "log" file. 

Therefore, you could create another flow to send this "log" weekly.

Hope it helps!


Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,392)