Power Platform Community Forum Thread Details

I currently have a SharePoint list that contains dynamic data, such as location details, addresses, lease information, states, and construction dates. As this data changes almost daily, automation is key to keeping everyone in the loop and ensuring accurate information is disseminated properly. I want to create a Power Automate flow that triggers whenever an element in the SharePoint list is updated. The goal is to automatically send a daily summary of these updates to a specific Teams channel. While I have some experience with Power Automate, I'm not sure how to set up the flow to monitor changes in the SharePoint list and send daily summaries to Teams.

Can anyone provide any direction?

Categories:

Building flows

I think you are trying to do two things at the same time.

There is a trigger which will start a flow "When an item is created or modified" so that would run anytime an item is changed.
There is another trigger which is Recurrence, where you would schedule a flow to start at a specific time and run on specific days of the week.

The only way I can think of for a daily update summary would be to have a Recurrence flow. In that recurrence flow you would have a Get Items action to get the SharePoint list items. You could filter the Get Items using the Modified column which says when an item was last changed/modified.

The filter would be something like, is the Modified column greater than yesterday's datetime. Which means it must have been modified sometime after yesterday when the flow ran.

This isn't a very specific method because someone could rename the item and name it back to the original and it would still change the Modified date time.