Condition to calculate if date field not blank and date is greater than today

(0) Share

Report

Posted on by lc6

Help! I am struggling on something that I thought would be easy. Essentially I need a flow to populate the Complete date on the SP list as today's date and update the status to Complete based on these conditions:

1. The column called Meeting date is not blank (contains a date)

2. The date in the Meeting date column is greater than today

3. The status is not Complete.

My plan is to run a scheduled flow that runs once daily. I know how to set up the trigger and make the action to update the item, the part I'm struggling with is making a condition that works. Thanks in advance.

All responses (2)

Answers (0)

lc6 5 on at

Like (0)

Report

Re: Condition to calculate if date field not blank and date is greater than today

OK I figured it out. It was a lot more painful and complicated than expected.
lc6 5 on at

Like (0)

Report

Re: Condition to calculate if date field not blank and today is greater than date

Sorry should read if today is greater than the Meeting date not the other way around.