I'm working on a Power Automate flow based on a SharePoint list. I have a Date column (Due Date) and a Choice column (Status) that I need this flow to look at. Basically what i'm tryign to accomplish is: If the Due Date has passed (based on Today's current Date), AND the Status column = Open, then send an email to the Requestor (person field).
I was originally trying to write the condition to say if the Due Date is less than Today's date...but that doesn't work.
The reason I'm doing this is because this list is substantial (800+ entries), and most entries are both "Open" and passed their due date. So I need a flow to check all of the entries for these two conditions, and send an email if its Status = Open, AND its Due Date is passed.
Any help would be great...kind of stuck
Thanks!