Default date to Sharepoint list

(0) Share

Report

Posted on by StevenZhang

155

Hi,

I am building a app with using sharepoint list, there is a date/time field, I setup default date to Jan/1/2020 when creating sharepoint list. back to Powerapps, the app is used by users come from different time zone, I am in UTC+8 and working good, other users come from UTC-8, they could see the default date is Dec/12/2020, one day behind, anyone has same issue? could you please give some comments? thanks.

Regards

Steven

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @StevenZhang ,
I dealt with something similar a couple of days ago on this post, coincidentally also at UTC+8.
The part using the TimeZoneOffset function is what you need - please excuse my mathematics, but you need something like
DateAdd(Now(),8-(TimeZoneOffset(Now())/60),Hours)
to write back the correct local time to the SharePoint server. This is a double negative - the 8 is the time SharePoint is behind UTC and you are ahead of UTC is -8, so you get 16 hours added to the SharePoint time, which is your correct time.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
StevenZhang 155 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ,

Thanks for you reply, tried to use dateadd and looks working in Edit mode, however how to let the date show same one to the users in different timezone in New mode, for example, I setup default date in sharepoint list which is Apr/01/2020, in my apps in UTC+8 it working good, however other users in UTC-8, it is showing Mar/31/2020.
How can I let it show same date to the users in different timezone.

Regards
Steven

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @StevenZhang ,
I cannot test this for you as our site is in our timezone however what happens if you put this in the DefaultDate of the field
If( YourFormName.Mode = FromMode.New, DateAdd(Now(),8-(TimeZoneOffset(Now())/60),Hours), Parent.Default )
Hopefully this should show the current content in Edit and View modes and write the adjusted time in New Mode. So for someone at UTC minus 8, which TimeZoneOffset(Now())/60 produces (positive) 8 would be 8-8 (zero) and should show the current local time on SharePoint.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
StevenZhang 155 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ,

thank you for the replay, after tested many times, I just give it a hard date, like
If(EditObjectiveForm.Mode = New,Date(2020,6,30),ThisItem.'End Date') since I will need to udpate it quarter and setup first day and last day of current quarter. And looks it is working.

Regards
Steven

Was this reply helpful? Yes No