Unanswered

Date Picker saving date as previous date in SharePoint.

(0) Share

Report

Posted on by DaynaBee

309

I have a PowerApp form that submits form to a SP list. The fields are a date & time field in SharePoint. The dates are being saved as the previous dates form what is selected. How do I fix this ?? tried changing the time zone to

DateTimeZone.UTC

but it is not working.

Please Help,

Thank in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Are you storing just the date value or date time value? Is it always a day behind? And do you want to save the date (or date/time) in UTC or user's local time?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
DaynaBee 309 on at

Like
a
(0)

Report
Copy link

Link copied!

@PowerAddict
HI Hardit Thank you for the quick response.

I am trying to store the date entered in the form , it is always a day behind ( so far) and i tried UTC to resolve the issue ( i dont have to use UTC ).
I just want it to reflect the date picked on the form .

Thanks,

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I tried UTC and it displayed previous day's date. When I changed to local, it worked fine for me.

Let me know if it does for you. If not, we may have to convert time zones explicitly. It boils down to whether you want the date to adapt based on user's time zone. 4/9 for me may not be 4/9 for you. So if I pick 4/9 what do you expect to see, 4/9 or 4/8?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
DaynaBee 309 on at

Like
a
(0)

Report
Copy link

Link copied!

It was local and tried UTC too. I even created another app from inside the list and it shows same behavior, once i change it to date and time . Making the field just date again doesn't help, once it starts saving dates as the day before it keeps doing it despite the fact that the field is set to date instead of date & time.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

May not be too relevant, but what happens when you set the default property of the date picker to Today()?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Yemata :
I guess the reason you encountered this problem may be:
The list save time as UTC time by default.
PowerApps load time as local time by default.
So when PowerApps load time, it will transfer to local time zone automatically.
In order to solve the problems mentioned above, I suggest you save local time to SPlist and load time in PowerApps as local time too. //make time zone the same.
I’v made a similar test for your reference:
Step1:Set the Default of the Date DATA CARD (not the Default on the Date picker) to

DateAdd(ThisItem.Date,TimeZoneOffset(),Minutes)

Step2:Make sure the Date time zone properties of the date picker control is “Local”

Step3(If you want to update the date):Set the Update of the Date DATA CARD (not the Default Date on the Date picker) to

DateAdd(DateValue10.SelectedDate,-TimeZoneOffset(),Minutes)

Best Regards,
Bof

Was this reply helpful? Yes No
DaynaBee 309 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft Bof thank you for looking in to this.

I will try it and get back to you

Was this reply helpful? Yes No
hgeorge 4 on at

Like
a
(0)

Report
Copy link

Link copied!

This solutions worked for me. I was having the issue that the date was saved 1 Day behind the selected date. Adding the +/-TimeZoneOffset() to the respective DataCard solved my issue. Thanks

Was this reply helpful? Yes No