PowerApps Date to sharepoint list - mismatch

(0) Share

Report

Posted on by Sriram6000

Hello Champs

I have a little problem and trying to figure out a solution for it.

My PowerApp app uses sharepoint list as a backend to store data. The PowerApps gets data from user in a form and saves it to the sharepoint list.

One column named "DueDate" is set up as Date and Time data type in Sharepoint list. When users enters a date in the PowerApps, it always saves the earlier date in the sharepoint list. For example, if the user enters 15-04-2021 in powerapps, it gets saved as 13-04-2021. I'm not sure if this is related to timezone, but one day earlier should not be of timezone difference.

Can you suggest how i can resolve this issue? I would like to save the same date and time as user entered in powerapps to the sharepoint list.

Please note, i use form to get user input and uses submitform() to submit data to sharepoint list.

Regards
Sri

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show us the formatting you are using for the Date when you input it to SharePoint? You are correct that two days off shouldn't be a timezone issue. But if you provide a sample of what's coming from the form and how you are formatting it for SharePoint I'll try to help.

Was this reply helpful? Yes No
Sriram6000 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Pstork

In PowerApps, the Data Card's Property Update is set to:
DateAdd(DateValue1.SelectedDate, TimeZoneOffset(), Minutes)
and DateValue's Property DateTimeZone is set to:
DateTimeZone.Local
In Sharepoint list, i have no formatting set. I have attached screens shots for reference. Let me know in case i'm missing anything.

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
A couple of things to note

1) SharePoint always stores Date/Times in UTC and automatically translates it to the SharePoint regional setting or user regional setting

2) When saving from Power Apps to SharePoint it will assume you are saving as UTC

3) Since the DatePicker in Power apps is set to local the time in the date picker is based on the user's locale (Note this may be different from #1)

4) TimezoneOffset() will assume today's daylight savings time setting if you don't supply a date/time as a parameter.

- So the datacard should be set to

DateAdd(DateValue1.SelectedDate, TimeZoneOffset(DateValue1.SelectedDate), Minutes)

to make sure you get the correct offset for the date.

- When saving to the SharePoint list you need to run the opposite of the formula in the datacard to translate back to UTC. You also may need to take into account the difference between SharePoint and the user. For example, I'm in US Central time zone for Power Apps, but my SharePoint Online environment defaults to US Pacific.

I'm not sure if that will clear everything up, but I would apply those changes and see what the result looks like.

-

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I'm also facing same issue ,how can it will resolve

Was this reply helpful? Yes No