Hi,
I have a CDS entity with a field for expiry date and a field for notification days. I need a condition that checks if today is equal to the expiry date minus the notification days. Is there a way to build this kind of datediff calculation into a condition expression, or do I need to just make a calculated field in the background in CDS to store the difference?
Thanks
Solved! Go to Solution.
Hi @SeanHenderson ,
You should check two expression in the Condition:
formatDateTime(utcNow(),'yyyy-MM-dd')
formatDateTime(addDays(items('Apply_to_each')?['ExpireDate'],concat('-',items('Apply_to_each')?['NotificationDays'])),'yyyy-MM-dd')
You shouldn't rename the Apply to each in your flow and modify the ExpireDate and NotificationDays expression with your column expression.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
you need to just make a calculated field in the background. As I see is not posible to compare and rest dates in the same conditional.
Proud to be a Flownaut!
Hi @SeanHenderson ,
You should check two expression in the Condition:
formatDateTime(utcNow(),'yyyy-MM-dd')
formatDateTime(addDays(items('Apply_to_each')?['ExpireDate'],concat('-',items('Apply_to_each')?['NotificationDays'])),'yyyy-MM-dd')
You shouldn't rename the Apply to each in your flow and modify the ExpireDate and NotificationDays expression with your column expression.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.