
Announcements
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
Hi Julien, is the date difference in your situation equal to + or - your current UTC offset time?