Unanswered

Getting wrong date value from Microsoft Dynamics 365 CRM

(0) Share

Report

Posted on by waleedbinafzal

Hi,

I have a flow that runs everyday to check if there are any task with due date today to send a reminder email to the user. The flow works fine. The only issue which I am facing and have no idea why it happening. The issue is if the due date of the task in Dynamics 365 CRM is April 24, 2020, when I get the data in Microsoft Flow, this date value will turn into April 23, 2020 which is quite strange. I have no idea why it is subtracting one day automatically from the date field while getting the data from Dynamics 365 CRM.

Please help.

Thanks,

Waleed.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@WaleedBinAfzal

The date you are seeing through your D365 front-end is corrected for your local timezone based on your personal settings. It is stored, however, in UTC. If you add a step after it fetches the date called "Conver time zone" to change from UTC to your local, the dates should match.

Please keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @WaleedBinAfzal ,

Additionally you have to make sure that the timezone which you are running your recurring job matches with your user when you query data in CRM

Thanks

Was this reply helpful? Yes No
JeganathanG 50 on at

Like (0)

Report
Copy link

Link copied!

Hi @WaleedBinAfzal ,
I also have the problem that the date I work on will be one day off from the actual date,I'm using a document update remainder flow that sends an email once a week.

The main reason is that the system local time and the login email time zone are different.

1. This is my System Time01

2. This is my Login Email Time Zone

02

3. Changed Login email time zone

After changing the time zone on both the system and the login email, the problem was resolved, and the date now updates correctly.

Thanks,
Jegan

Was this reply helpful? Yes No