cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Getting wrong date value from Microsoft Dynamics 365 CRM

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.

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: Getting wrong date value from Microsoft Dynamics 365 CRM

@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.

Highlighted
Solution Specialist
Solution Specialist

Re: Getting wrong date value from Microsoft Dynamics 365 CRM

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

 

Capture.JPG

 

Thanks

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (3,299)