We have noticed a problem today where date/time fields submitted by a Power App to a Sharepoint list are submitted as an hour behind what was selected. We are on Eastern Standard time and daylight savings time was this morning. This problem just started today. This is happening on multiple apps.
Solved! Go to Solution.
Hi @hayden ,
The same has just happened to us. The time zone on the PC is one hour out from the time zone on the SharePoint site.
For instance (I am in Australia) the SharePoint site is on Brisbane time (no daylight saving) and our SOE is on Sydney (with DS).
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.
It happened to me as well.
The controls on my canvas app included 1 date picker with TimeZone set to Local, 1 dropdown for Hours (from 00 to 23), and 1 dropdown for Minutes (from 00 to 59). The default Update property is
DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)
so I use the same for Patch function. But it saved to SharePoint 1 hour off for Daylight saving start and end dates.
I changed it to
DateTimeValue(DateValue1.SelectedDate & " " & HourValue1.Selected.Value & ":" & MinuteValue1.Selected.Value,"en-US")
This seems to work for me.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!