Difference in Datetime when saving to SharePoint list

(0) Share

Report

Posted on by ervinw

I collect Date and Time by DatePicker and Dropdowns:

When I save this to a SharePoint list:

Set(var_occurence;DateTimeValue(DatePicker2.SelectedDate +
Time(Value(drpHour.Selected.Value);Value(drpMinute.Selected.Value);0)));;

Patch(Oktatas_alkalom;Defaults(Oktatas_alkalom);{Title:"Teszt";Oktatas_azonosito:cbbEducation_3.Selected.'Azonosító ({Identifier})';Időpont:var_occurence});;

I have a total different result:

Do you have any idea, what can cause this issue; how to solve this?
Thank you, Ervin

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

WarrenBelz 155,240 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @ervinw ,

You can save yourself a Variable as below, but that is not your issue. Have you done a number of different date/times to see if there is a consistent difference (in time) between your selection and the result ? One item I noticed was that you are using European syntax, yet your SharePoint data format is mm/dd/yyyy which is only USA, so what are the Regional Settings on your SharePoint server ?

With( { _occurence; DateTimeValue( DatePicker2.SelectedDate + Time( Value(drpHour.Selected.Value); Value(drpMinute.Selected.Value); 0 ) ) }, Patch( Oktatas_alkalom; Defaults(Oktatas_alkalom); { Title: "Teszt"; Oktatas_azonosito: cbbEducation_3.Selected.'Azonosító ({Identifier})'; Időpont: _occurence } ) );;

Was this reply helpful? Yes No
ervinw 83 on at

Like (0)

Report
Copy link

Link copied!

I don't know, I have only found my settings here:
https://myaccount.microsoft.com/settingsandprivacy/language
Which is Hungarian, similarly like DatePicker's local setting.

(If I store the date as Text, then it's fine.)

Was this reply helpful? Yes No
Verified answer

Hasrie 202 on at

Like (1)

Report
Copy link

Link copied!

Hi @ervinw the regional setting is in the sharepoint, not under your user account. Check under the "Oktatas_alkalom" Sharepoint > Gear icon > Site Information > Site Settings > View All Site Setting > Regional Setting > Check under TimeZone and Region / Locale

Was this reply helpful? Yes No
ervinw 83 on at

Like (0)

Report
Copy link

Link copied!

Just found it, it was Pacific... :), not Hungarian

Was this reply helpful? Yes No
WarrenBelz 155,240 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@ervinw ,

Exactly what I suspected - and Pacific is the most extreme as far as behind UTC. What you are seeing is actually correct as far as the SharePoint Server is concerned.

Was this reply helpful? Yes No