When I submit the form to SP Online list the date is minus 1 day.
If I select 30th of April from the datepicker in powerapps and submit the List will display 29th of April.
Any solution or ideas on how to fix this?
This issue should be related with SharePoint date sotring.
Could you please share information about the date type? is it date only, or the date and time format?
If you are using the Date and time, please take a try to create a date only field, see if issue insists.
Further, In addition to the format, make sure you have the datetimezone property of the Date Picker specified with UTC.
The data type is date only. And I have tried changing the date picker control to UTC but still getting 1 day off. I have tried a test environment and set the region to Australia but still did not work.
I have started to see this issue since last week. My PM system was writing data with selected date on the date control to a SharePoint list. Now suddenly it is writing +1 day to what is selected to the same SP list. However, when the same data is retrieved in PA, it is giving me the correct date (-1 day).
Can someone help me understand what might be going on? I did not change my system at all when this shift of date happened.
What has changed?
I had a similar issue and found the reason (at least for my case):
My SharePoint online site had regional settings set to a wrong timezone. So if you go to SP site contents - regional settings - ensure you selected the correct timezone there. Adjusting that worked for me. 🙂
I've got exactly the same issue with DatePicker.
In this case, my canvas App connects to CDS. If Dynamics Timezone is different (even if the UTC time difference is correct) the displayed date differs from the saved date (at CDS) in one day. This bug is independent from the saving method (Submitting a form, Patching) and also independent from the device (PC browser/Android PowerApps App)
It appears to be an 12h AM/PM issue.
Please correct the bug to let PowerApps work in multi-country scenarios.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021