Starting flow when two SharePoint columns equal each other?

[Anonymous]

Hey all, I am building a Flow that needs to follow ISO standards.

We need to review all documents within a time period, we have two columns, a last reviewed column and an ISO review-by date.

The idea is, as utcNow() approaches the review-by date, less than three months apart for example. I want a flow to start for someone to review it per ISO standards. I am unsure how to start this flow, any idea on the direction would be great. Thank you!

[ScottShearer · Accepted solution]

@Anonymous :

You may want to start you Flow with a recurrence trigger and a Get Items action with an OData filter.

Please note the following:

• OData filters use a columns internal name
• The parameter inside of the OData filter has single quotes around it

[Anonymous]

Thanks a ton @ScottShearer  ! This was exactly what I was looking

---

@ScottShearer wrote:

@Anonymous:

You may want to start you Flow with a recurrence trigger and a Get Items action with an OData filter.

Please note the following:

• OData filters use a columns internal name
• The parameter inside of the OData filter has single quotes around it

---

for!