Unanswered

Expression to run the flow if todays date is Less Than or Equal To 12 days from the StartDate column

(0) Share

Report

Posted on by wmiller-stratfs

Good morning Everyone,

I am trying to set a condition to check and run a flow only if todays date is less than or equal to 12 days from the StartDate column. Any assistance would be appreciated, thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

wmiller-stratfs 4 on at

Like (0)

Report

just to clarify with an example.

StartDate is 5/26/2022, trigger is fired from a change to a Teams List. I have the flow set to "When and item or file is modified" to check if today's date is within 12 days of the start date. Not sure how to write the expression for that check. Check should return "True" for any day within the 12 days from today and the StartDate column. If Outside the 12 days, it would return "False".

Thank you,

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (0)

Report

Hi @wmiller-stratfs ,

1. You can use utcNow to get today's date.
2. You can use addDays to add 12 days to today's date to judge whether it is greater than or equal to StartDate. If the result is true, it proves that today's date is within 12 days of StartDate.
I have made a test for your reference:

Beat Regards,
Levi

Was this reply helpful? Yes No
BruG1973 4 on at

Like (0)

Report

Hi, I wonder if if you can help me , its similar question , how would I do it if the date was equal or less than todays date ? I am wanting to delete meetings ( running on schedule - which I am fine with) that have happened on that day so its just the expression I require help with please.

Was this reply helpful? Yes No
BruG1973 4 on at

Like (0)

Report

test

Was this reply helpful? Yes No