Power Platform CommunityForums Power Automate - AI Builder Automate SharePoint List

Automate SharePoint List

Like (0) Share

Report

Posted on 30 Jul 2024 20:54:08 by TS-30072053-0

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?

Categories:

Business Processes

All responses (1)

Answers (0)

Suggested answer

NsL Coder 469 Super User 2025 Season 1 on 30 Jul 2024 at 21:00:05

Like (0)

Report

Automate SharePoint List

Sure you can do a power automate flow that trigger on a schedule daily, actions that Get Items from a Sharepoint list, and use Filter Query to filter out those that has blank in a column (or if you can't figure out ODATA filter query, then get all items, and use the Filter Array action). If there are results returned, then create a HTML table out of the results and send an email with it.

Bold are all actions name to use in flow, and red is field in the action.