You’re offline. This is a read only version of the page.
Announcements
172
Hi Everyone,
I am very new to integrating Power Automate with Dynamics and am struggling to work out where to start with this. What I need to do is have Power Automate send an email to a Contact held in D365 whenever that Contact was last contacted 5 years and 1 day ago. I know the name of the last contacted field but my immediate challenge is that all the Dynamics 365 connector appear to have been deprecated (so what do I use) and I can't for the life of me see how to do the date comparison. Any pointers for this would be very gratefully received.
Thanks!
Hi @Serviced2000,
Date comparison is made from the year, month and day in turn. For example, two dates are "2020-05-22" and "2020-07-21", year is same, the second month is greater than the first one, so the send date is greater. When you compare two dates, the format should be "yyyy-MM-dd".
Date comparison could do in the filter query by using ODATA filter query syntax, for example:
Get items that date is greater 100 days ago and less than 1 day ago:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Share
Report
All responses (
Answers (
