Forum Discussion

Tim_Stanley_6959's avatar
Tim_Stanley_6959
Copper Contributor
Jul 30, 2024

SharePoint List

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?

SharePoint Online
  • michalkornet's avatar
    michalkornet
    Iron Contributor
    Aug 01, 2024

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

     

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

     

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

     

Resources