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

Flow & Updating CRM d365 online datetime attribute field

Issue :

We'd like to use flow for updating datetime attribute of opportunity entity with current date & time.

For that we use utcNow() function available in flow but whenever same attribute  is displayed in crm view , time is incorrect & 6 hours ahead.

 

Expected outcome:

Ideally it should display 12/08/2020 11:34 AM (-6 hours CST). (See last screenshot)

 

Flow:

flow.png

Attribute settings on CRM : 

attribute.png

 

CRM View:

CRMView.png

 

 

 

 

 

3 REPLIES 3
Community Support
Community Support

Hi @MSFlowUser ,

 

Could you please share the details of your flow steps and flow running result?

From this blog, we can know that expect the Entity Field settings(User Local), the first priority setting to control the time zone of date is User Setting  – Each user account has a time zone value in their personalization settings, this defines what the “local time” is for the user account. This is set in the user’s profile.

Please go to Dynamics 365 Setting - Personal Options, and set Time Zone to your local time zone.

Snipaste_2020-12-09_10-21-45.png

Hope this helps.

Sik

Regular Visitor

Hi  ,
 
Thanks for looking into this. 
I am attaching some snapshots to provide information that you are looking for.

1 - Flow steps: 

MSFlowUser_0-1607548385177.png

MSFlowUser_1-1607548423693.png

 

 

2- Result from running the flow:

MSFlowUser_2-1607548436656.png

 

3- CRM View :

MSFlowUser_3-1607548459543.png

 

4- Time zone settings in d365online:

MSFlowUser_4-1607548474305.png

 

Flow ran on 12/9/2020 on 11:01 AM (CST)
Based on screenshot 2, when flow  ran  UTC datetime was 2020-12-09 5:01:14 PM which is +6 from CST.
Based on screenshot 3, if correct UTC time was inserted into CRM , should it  display 12/9/2020 11:01 AM instead of 12/9/2020 5:01 PM ?

Community Support
Community Support

Hi @MSFlowUser ,

 

So weird!

Result in Flow Run shows '2020-12-09T17:01:14Z' (UTC) for that DataTime field, which is reasonable since actually all date time values saved in CDS and processed in Flow are in UTC format and then display per the User Setting or Time Zone behavior, so the flow run result shows that the Update process is good, and it's more like a TimeZone Display issue, but I can't reproduce your issue even 100% repeating your steps and configuration.

Perhaps, you need more test in different environment, e.g. Account, Environment, Browser, Computer, etc.

Sik

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (60,868)