cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brooke_
Regular Visitor

Date from Dynamics 1 day behind

Hello,

 

I'm struggling with the dates in Flow; I've got a routine that filters records between a dynamic start and end date pulled from Dynamics records using the CDS connector. The filter routine is correct and generates data but the dates it's using are both 1 day earlier than the dynamics record states. 

 

My user timezone is set to utc 00:00 London Lisbon Dublin.

The system is set to UK formats

 

I've tried to convert the date, in both directions UTC to London Lisbon and London Lisbon to UTC , but the base input initially being pulled through is a day earlier than the Dynamics field data

The outputted results are therefore just in a short date format per the requested formatting in the conversion action

 

e.g. Dynamics record states 01/08/2020, Flow states the following:

 

flow.PNG

 

 

 

 

 

 

 

 

 

 

 

 

Does anyone have any suggestions as to how to pull the correct base time?

 

Thanks in advance

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JohnAageAnderse
Memorable Member
Memorable Member

Hello @Brooke_ 

Could you show us what is the datetime value including the time? Converting between timezones does require the time value to be there, else it is considered to be midnight, time = 00:00:00!

Kind regards, John

View solution in original post

3 REPLIES 3
JohnAageAnderse
Memorable Member
Memorable Member

Hello @Brooke_ 

Could you show us what is the datetime value including the time? Converting between timezones does require the time value to be there, else it is considered to be midnight, time = 00:00:00!

Kind regards, John

v-alzhan-msft
Community Support
Community Support

Hi @Brooke_ ,

 

Do you want to get the date one day after the dynamic date?

I suggest that you should explain more details about the requirement, or just share an example for the requirement so we could better understand you and provide the proper workaround.

 

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.

Ah @JohnAageAnderse! That's it, I had thought it being set as date only and therefore midnight would be sufficient.

Having changed the field from Date only to Date Time, whilst leaving the field data at 00:00:00 it's correctly converting the date from 30/06/2020 to 1/7/2020.

 

Thanks for your help 🙂

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.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (5,055)