Announcements
excel date does not match in powerapp table It's 3 hours late please help
Hello @claudiourra
This is a common issue if you search its very very very common.
The issue is with the Server settings, localization settings, or the users settings who created the file.
One of those has a different TimeZone then Power Apps. So you need to figure out what time zone it was created in and convert it to Match.
This is an Excel issue not a Power Apps Issue but can be "resolved" with either a Script in Excel or Writing the Convert functionality once you have the Timezone which is easy enough
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help othersCheersThank YouMichael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsofthttps://gernaeysoftware.comLinkedIn: https://www.linkedin.com/in/michaelgernaey
Hi @claudiourra,
Here is the thing:
Try to update the datetime as below:
DateAdd( DateValue2.SelectedDate+ Time( Value(HourValue2.Selecter.Value); Value(MinuteValue2.Selecter.Value); Value(SecondValue2.Selecter.Value) ); -TimeZoneOffset(); Minutes )
Note that using the -TimeZoneOffset() if excel display time 3 hours later than PowerApps time, like you save time like 9/30/2023 0:00 in Power Apps, but your excel display like 9/29/2023 21:00.
If excel display time 3 hours earlier than PowerApps time, using TimeZoneOffset().
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 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
