I have a condition where I check if a date field is between (Today-30 days) and (Today).
Hello,
I have the below conditions:
Solved! Go to Solution.
Hi @Delpierita ,
What’s the column type of “Today_x0020__x002d__x0020_30_x00”? I assume that it is a calculated column in the list.
For your scenario, if you would like to check if a date field is between Today-30 days and Today, please try to use adddays function instead of using a calculated date from the list.
The functions in the Condition are:
formatDateTime(items('Apply_to_each')?['Date'],'yyyy-MM-dd') is greater than or equal to formatDateTime(addDays(utcNow(),-30),'yyyy-MM-dd') And formatDateTime(items('Apply_to_each')?['Date'],'dd/MM/yyyy') is less than or equal to formatDateTime(utcNow(),'yyyy-MM-dd')
A screen shot for the flow:
Best regards,
Mabel
Hi @Delpierita ,
What’s the column type of “Today_x0020__x002d__x0020_30_x00”? I assume that it is a calculated column in the list.
For your scenario, if you would like to check if a date field is between Today-30 days and Today, please try to use adddays function instead of using a calculated date from the list.
The functions in the Condition are:
formatDateTime(items('Apply_to_each')?['Date'],'yyyy-MM-dd') is greater than or equal to formatDateTime(addDays(utcNow(),-30),'yyyy-MM-dd') And formatDateTime(items('Apply_to_each')?['Date'],'dd/MM/yyyy') is less than or equal to formatDateTime(utcNow(),'yyyy-MM-dd')
A screen shot for the flow:
Best regards,
Mabel
Hi,
I think you're equation should be something like:
formatDateTime(triggerBody()?['Negotiaton_x0020_date'],'dd-MM-yyyy') is less or equal to formatDateTime(utcNow(),'dd-MM-yyyy')
utcnow() is the 'today' in Flow, and with addDays() you can add or substract days from you're chosen date.
Hope this helps
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
36 | |
28 | |
27 | |
27 |