Announcements
when saving date from PowerApps to SharePoint List is saving it like (date -1)
Sharepoint
PowerApps
@aaronllanes
This is because of your regional settings of your SharePoint site. Check the settings of the site and make sure they are correct.
What is happening is that it is storing the date with a time and if there is no time then it is 00:00 however, if your timezone offsets the time with any negative number, then the time will be prior to 00:00 - which is the day prior.
I hope this is helpful for you.
Hi @aaronllanes ,
If you are still not getting a proper fix to your timezone.
Try this,
Patch your record with the Expiry Date + 1.
Example;
Here, I have showed the Value of Date control and corresponding change to it. You can use the value to update in your Sharepoint.
Formula : Text( DateAdd(Exp_Date.SelectedDate, 1), "[$-en-US]mm/dd/yyyy")
Here, Exp_Date is control name
Hope this quick fix solves your problem.
@Ethan_R
Although that is a "quick fix", it would be storing an incorrect Date in the list.
The correct fix would be to set the region properly on the list or work with the timezoneoffset function to store the date as UTC and then read it back using the timezoneoffset to correct to local time/date.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 401 Most Valuable Professional
11manish 201 Super User 2026 Season 2
MS.Ragavendar 128 Super User 2026 Season 2
