Hi, I'm using PowerAutomate to send an email to a document owner when their document(s) in SharePoint are Due for Review. First email 2 months before and a reminder 1 month before. I then want an email to be sent to the Supervisor when a document becomes Overdue.
My issue is that I am just sending an HTML table with all files regardless of Review Status. How do I filter out the files that are Current, so I am only sending relevant information? I have a Review Status column that is either empty, "Current", "Due for Review" or "Overdue"