Answered

Sharpoint Time Zone & App

(0) Share

Report

Posted on by GET123

In my app, user can select time slots (9 AM, 10 AM, 11 AM, 7 PM, 8 PM) with a date picker provided to them and they can select that at their choice, i am using this code to patch the date to SharePoint.

Patch(SharepointList, Defaults(SharepointList),{ Date: DateTimeValue(DatePicker1.SelectedDate & " " & drpHour.Selected.Value}),

When I patch a date time (my local time zone) value into a SP list, the date time value converted into Eastern Time .

How can I fix this so it patches it over the selected date and Hours?

Users - anywhere in US

My SharePoint regional settings are EST

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

DateAdd, DateDiff, and TimeZoneOffset functions in Power Apps - Power Apps | Microsoft Docs

Look into the TimeZoneOffset function. You can use this to dateadd to the current utc time to get the modified time in relation to everything. Examples in the article.

Was this reply helpful? Yes No
GET123 30 on at

Like (0)

Report
Copy link

Link copied!

@cwebb365 Thank you for sending me the link . The problem is that I wanted to patch the selected value to SharePoint list ( just like , 12/19/2021 1:30 AM) but when I patch it the date time value converted into Eastern Time ( 12/19/2021 2:30 AM). setting to use Local vs. UTC is not solving my issue.

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I edited my original post, if you used e-mail to read and link, please go to post and check updated posting utilizing the timezone function instead.

Was this reply helpful? Yes No
GET123 30 on at

Like (0)

Report
Copy link

Link copied!

@cwebb365 , I have tried to use TimeZoneOffset functions but I am not lucky to patch the selected value to SharePoint list (the same DateTimevalue) .

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @GET123 :

The point is that your device and SharePoint Site are not in the same time zone.

You can first use the TimeZoneOffset function to calculate the date offset between the user's current time and UTC time, and then add a 5-hour date offset to get the accurate date and time when uploading.Something like:

Patch( SharepointList, Defaults(SharepointList), { Date: DateAdd( DateAdd( DateTimeValue(DatePicker1.SelectedDate & " " & drpHour.Selected.Value), -TimeZoneOffset(), Minutes ), 5, Hours ) } )

My tests——

Site setting:

Patch:

Result:

Best Regards,

Bof

Was this reply helpful? Yes No