Hello everyone,
I have a table in dataverse that has a Date field with the behavior type (Time zone independent) as below:
I connected this table to a form in canvas and I assigned the "update" property of the date field to take the UTC date format.
What I am trying to achieve is the below:
Regardless of the user timeZone or the device timezone that is being used, I want the date/time to be stored and appear as it is from canvas to the model-driven date & time field in the table.
Example: If I chose in canvas the Date 4/18/2022 21:30 PM, the expected outcome for this field in model-driven should be 4/18/2022 21:30 PM and not a different time. (That means the date should not appear based on the user local).
The below blog post has the same scenario that I have:
https://powerapps.microsoft.com/en-us/blog/time-zone-independent-fields-for-canvas-apps/
I did several testing on this field and it is still showing the wrong date/time that I am saving it from the canvas as it seems it is taking my user local time:
Could you please advise what should be changed to achieve the above requirements?
Would highly appreciate it if you can provide an example.
Best regards,
Julien

Report
All responses (
Answers (