Forum Discussion
Solved
Get Sharepoint list with pending status and include in an email
Hi All, I need some help with Flows. I'm trying to create a flow where the requirement is that, all Items with 'pending' status in on the list, gets picked up and sent to a reviewer or specific e...
Hi shebibn2020 yes this is quite straightforward to do. See the images below. The steps are:
- For your trigger you need a recurrence schedule set to run every 1 week on Monday at 9am.
- Then assuming your list is in SharePoint you add a SharePoint Get items action and set the Filter query to Status eq 'Pending' . In my example I have set it to 'In Progress' but that's just my list.
- Then add a Create HTML table action, set the columns to Custom and add your header and value items.
- Then add a Send an Email (v2) action to send the email with the output of the Create HTML table action.
Rob
Los GallardosMicrosoft Flow Community Super User
Hi shebibn2020 - you may want to try the powerusers forum. I was just at SharePoint Fest and met some MVPs who monitor this one every day: https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity.