Power Platform Community Forum Thread Details

Hello,

I created an app that will Patch a Date and Time column in Sharepoint List using a Date Picker and a combo dropdown box for the time. It is working but the date it pushes to Sharepoint changes from PM to AM and vice versa. Just to let you know, my timezone is in UTC+08:00 and our Sharepoint's timezone is in UCT -05:00

This is the syntax I used:
'Maintenance Date/Time': (DateValue(datePicker.SelectedDate) + Time(Value(Hour.Selected.Value), Value(Min.Selected.Value), 0))

I saw some topics here that I should use the TimeZoneOffset but when I tried using it, it did not work. Here is the syntax with TimeZoneOffset:
'Maintenance Date/Time': DateAdd((DateValue(datePicker.SelectedDate) + Time(Value(Hour.Selected.Value), Value(Min.Selected.Value),0)), TimeZoneOffset(Now()), TimeUnit.Minutes

Sharepont List