Forum Discussion
Get Sharepoint list with pending status and include in an email
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
Hi Rob,
Apologies if i'm troubling you...was hoping if you can help out, if not it's ok i can post it as a new topic.
I've encountered with some issues (flow successful but did not receive any notification email).
Nevertheless, here's my flow:
1. An overview
2. Filter query
3. HTML table (i've sent to automatic) and email