Plaza 365
Plaza 365

No results found for your search

RegisterLog in

4

Date Time Fields (Date Only and User Local Behaviour) in Power Automate (Dataverse)

Visit article

#dateandtimefield

#flow

#timezone

Dynamics 365 CRM - General

Category

Sep 1, 2023

Published date

Text

Article Type

AI Summary

  • The article discusses an issue faced in a flow where the date shown was different from the date entered by the user for a date time field.
  • The scenario described involves a field called "Date and Time with Time Zone Adjustment" in CRM/Dataverse, where the user enters a value and saves the record, triggering the flow.
  • The user's time zone is set, and in the Power Automate flow, the UTC date is visible.
  • To convert the date to the user's New Zealand Time Zone, the convertTimeZone function is used.
  • The article highlights a problem when changing the format of the field to "Date Only" while keeping the time zone adjustment as "User Local." In this case, the convertTimeZone function does not work as there is no time part in the date.
  • One suggested fix is to change the time zone adjustment to "Date Only" or "Time zone independent" for the field, eliminating the need for time zone conversion.
  • The article provides a link to a thread discussing the issue and another link to Microsoft documentation on the behavior and format of date and time fields in the Power Apps Maker Data Platform.
  • By triggering the flow again after making the suggested fix, the article indicates that the values retrieved no longer undergo time zone conversion.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.