cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Teresa24486
Post Prodigy
Post Prodigy

Date mismatch- CRM and Flow email body.

Hi,

I have a date column in the CRM which shows:

Teresa24486_0-1634722284060.png

But in the email that comes from the Power Automate flow, the date shows 1/11/2021 and strangely this has only happened for one record whilst the other records that came on the email has correct dates.

I have formatted the date field to be: 

formatDateTime(addDays(item()?['expirydate'], 1), 'dd/MM/yyyy')
The formula has 1 day added for a reason. My dates when displaying on the email used to be one day lesser to the CRM date.
 
Not sure why this one record shows wrong date. Kindly advise.
 
0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,634)