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?
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.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.