Power Platform Community Forum Thread Details

I am fairly new to Flow, and am building a scheduled flow on a document library that runs every morning and checks the below criteria before updating a Status column in the library to red, amber or green but I am having difficulty getting the dates to work.

Red
Last Review Date is more than a year ago

Amber

Next Review Date is less than 90 days away

Green

Any other file where Last Review Date is within the last year and Next Review Date is not in the next 90 days

AND Publish column is equal to Yes

Any help would be appreciated.

Categories:

Building flows