Power Platform Community Forum Thread Details

I currently have a sharepoint list that gets added to each day via a Power App.

Is it possible to create a flow that checks this list once a day, and can then either send an email or teams message summarising the new rows, like 'XX new rows have been created today'' etc.

I get too many additions to have individual notifications each day hence wanting a summarised version.

Categories:

General topics

Hi @Analyst85 ,

You can create a scheduled flow and use the get items action , in the filter query use the below expression. , this will fetch you the items that are created today.

Created ge 'formatDateTime(utcNow(),'yyyy/MM/dd')'

You can get the count of the items from get Items value array using the below expression. Here the action name is Get items (Change the naming convention as per your action - Use the length function on the value array from the Get Items action).

This will give you the count of rows that were added today.

length(outputs('Get_items')?['body/value'])

If you want to get the count of items that were created yesterday (Assuming you want to send the count on the next day), you can use the filter array action (after get items), use the value array as input for the get items action and use the below expression by clicking on edit in advanced Mode and filter the items that were created yesterday.

@equals(formatDateTime(item()?['Created'], 'dd-MM-yyyy'), formatDateTime(addDays(utcNow(), -1), 'dd-MM-yyyy'))

If you are using filter array action you can use the expression

length(body('Filter_array'))

to get the count of items.

Now you can use the teams action post a message in a chat or channel or use the send an email action.

Please give this a thumbs up and mark this as solution if this answers your question!

Thanks,

Community site session details

Summarise new sharepoint rows daily

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates