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
What if there are 2 values?
As in Sharepoint list column value is 'Pending' or 'N.A' then trigger to send recurrence email?
Does filter query supports 2 or more values?
Can_make_it yes you can have multiple conditions in a filter query: here's an example of one of mine with 3:
Rob
Los Gallardos
Microsoft Power Automate Community Super User