Answered

Dataverse date fields not populating as expected

(0) Share

Report

Posted on by nvargas Microsoft Employee

I have start date/time and end date/time columns currently set to Time Zone Independent so that any user can select a time based on PST and it will show up as what the user put in. I have verified the data card is set to UTC and the columns are in Time Zone Independent, but the time still is not showing up correctly.

Example: A user enters 12:00PM in the form for their time on the west coast and it shows up as 5:00AM in the dataverse table, but a user enters 12:00PM in the form on the east coast it shows up as 8:00AM.

This makes sense for the time difference, but I need the date/time entered to be what shows up in the dataverse table, not something that converts based on where the user is located which is why I chose Time zone independent. What am I doing wrong?

End goal: Date and time entered into the form match the date/time on the dataverse table so that it can be used in a power automate flow to create an event.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

v-jefferni on at

Like (0)

Report
Hi @nvargas ,

To achieve your need, please follow the steps:

1. Change Date Time Zone property of the Date Picker to Local:

2. Edit Update property of the Data Card to:

Text(DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0),DateTimeFormat.UTC)

Best regards,

Was this reply helpful? Yes No
Verified answer

nvargas Microsoft Employee on at

Like (0)

Report

I was able to find the solution, when dealing with the date columns when it is first created and you need time zone independent, you must choose that when it is first created. It would not function properly if the setting was changed from local to time zone independent.

Was this reply helpful? Yes No