SharePoint List

Copper Contributor

Is there a way via Power Automate or another option that would email daily a list of items in a SharePoint List's field that is missing results...like an approval name?

1 Reply

Hi @Tim_Stanley_6959 , You can use the Recurrence trigger in Power Automate to run the flow every day.

michalkornet_0-1722494957907.png

 

Then, use the SharePoint Get Items action with the Approver eq null filter to get items without the Approver field filled in.

michalkornet_1-1722495064094.png

 

At the end, you can construct an HTML email to send information about all items. (Depends how you would like to send the information).