Recurrence flow to run when calculated due date is reached

[Doddy83]

Hello,

I am trying to get a flow to run when an item in a SP list's 'NextReviewDate' is reached. See below

As you can see from the next screenshot, there is an item in the list (29) that brings back todays date (17/12/2020) but the flow still brings back a false result?

Here is a screenshot of the list showing the 'NextReviewDate' of 17/12/2020 (this is a calculated column and the formula is =LastReviewDate+ReviewFrequency)

The flow doesn't fail, it just doesn't pick up the NextReviewDate and run down the 'true' route. Any help would be much appreciated, I'm assuming its an issue with my expression in the condition, I have tried a few other ways with no joy.

Cheers

Chris

[ScottShearer]

@Doddy83 

The best way to approach this will be to use a filter query in your get items action - you should not need a condition as only the items that meet your criteria will be returned.  Set your recurrence trigger to run daily.

Click on Show advanced properties to see the filter query input area.

Your filter will likely look something like this:

NextReviewDate eq 'formatDateTime(utcNow(),'yyyy-MM-dd')'

The quotes in the example above are all single quotes.

[Doddy83]

@ScottShearer ,

Thanks for the quick reply, although I have tried something like this but it says you cant do this on a calculated column?

Is there a way I can use the 'LastReviewDate' and add 91 days to it so I can remove the need to use the calculated column in Flow?

[ScottShearer · Accepted solution]

@Doddy83 

Give this a try:

[Doddy83]

Thank you so much! worked a treat. So simple when you know how!

[Doddy83]

@ScottShearer  - I know this is an old post now but I'm finding that when there are two entries with the same review date, it seems to be picking them both up but they are not running parallel, the first one runs, then once that's all approved the 2nd one starts? However the second one fails due to there being no valid approvers? I'm assuming this is due to the way I've got the 'Apply to Each' setup. 

I have raised this separately on a new case here but I'm yet to get any answers?

Any advise you could provide would be much appreciated.