Answered

Patch date and time with timezone difference

(0) Share

Report

Posted on by Maurizio1

Hello there, I hope you can help me out here, because i'm completely lost. I have an app in powerapps where i patch a datetime picker to a date time column in sharepoint. It patches ok but there is a 4 hours difference between the hour i submitted in the app and the hour that was patched in the sharepoint. Same thing happens with the submission:Now() part of the code. What am I doing wrong?
If you need it , the code for the OnSelect property of the submit button is this:

Patch(

'TestList2',

Gallery3.Selected,

{

Status: {Value: "Pending"},

'Timestamp':DateValue2_1.Value +

Time(Value(HourValue2_1.Selected.Value), Value(MinuteValue2_1.Selected.Value),0),

Submission:Now()

}

Thanks in advance!

Categories:

General Questions

All responses (2)

Answers (1)

Maurizio1 7 on at

Like (0)

Report

Re: Patch date and time with timezone difference

You rock!! Thanks so much, it worked perfectly!
Verified answer

v-bofeng-msft on at

Like (1)

Report
Re: Patch date and time with timezone difference

Hi @Maurizio1 ,

Firstly, let me explain why you encountered this problem.

The point is timezone. The time in your App is the local time. When the time is saved to SharePoint, it will be converted according to the time zone set by your SharePoint Site. So the time you get is different from the time in the App.

Secondly, I have two solutions :

Solution1:Modify the formula

Submission:DateAdd(Now(),X,Hours),

Solution2:Change the TimeZone of your SharePoint Site

Site contents>Site Settings>Site Administration>Regional settings

Best Regards,

Bof