I have a simple sharepoint list that has 3 columns thats supposed to track the completion status of a scorecard. Column 1 is the supplier name. Column 2 is the email address of the owner. Column 3 is the status. It's either "Open" or "Completed". This is choice field in Sharepoint List. Default status is "Open".
I am trying to setup a flow that will check once per day day for any enteries that still have an "Open" status. If they do then I want the flow to send and email to the owner to remind them to close the scorecard.
I have been trying to do this using a Condition on a recurring flow. But even though their is a status of "Open" it still returns false and doesn't send an email.
I am wondering if I need to use a different strategy.
TIA
Solved! Go to Solution.
When you're pulling items from SharePoint to check if they're open or not, try adding a filter to your "get items" so you can use only relevant data to complete the objective.
To add a filter, toggle advanced options within Get Items --> Place the following under "Filter Query":
replaceWithYourColumnName eq 'Open'
When you're pulling items from SharePoint to check if they're open or not, try adding a filter to your "get items" so you can use only relevant data to complete the objective.
To add a filter, toggle advanced options within Get Items --> Place the following under "Filter Query":
replaceWithYourColumnName eq 'Open'
I tried that but I don't get the choice of my column name. I only get limit list of column name names.
Never mind my previous message. I figured out how to make your method work. I didn't realize at first that I could type in the field name. Thank you very much. Solved my issue.
User | Count |
---|---|
95 | |
48 | |
21 | |
19 | |
18 |
User | Count |
---|---|
137 | |
54 | |
42 | |
41 | |
30 |