Sending reminders using Power Automated based on Content in a Sharepoint List

[Gchumway]

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

[Babybots · Accepted 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'

[Gchumway]

I tried that but I don't get the choice of my column name.  I only get limit list of column name names.  

[Gchumway]

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.  

[v-bofeng-msft]

Hi @Gchumway ,

Glad to hear that you have solve this problem. Please consider marking the solution( @Babybots 's solution ) as a solution to close this thread.

Best Regards,

Bof