You’re offline. This is a read only version of the page.
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
PowerApp
Can you please give me some advise? Thank you.
Share
Report
All responses (
Answers (
477
