On my current app, i have dates on an excel sheet, they are beign shown on a gallery, the problem is the date that shows up is always one day before the actual date( If i type 31/12 on excel, it will show up as 30/12 in the app)(pt-br date format)
Any ideas why this is happening?
I tried to create an app based on Excel. And the date show properly on the app, equal to the actual date.
Is the time zone of PowerApps the same with the local time zone of your PC? Please try to format them to the same to see if it works.
Hi, thanks for your reply!
So, the date on power apps is currently like this
So its on the same format as my pc right? I did not find how to set the exact timezone as my pc(Brazil has like 3 different time zones).
Even with this format on the code, it stills shows up one day before the day that I want.
For testing, first, please try to format the local time zone of your PC to one of them(Brazil has like 3 different time zones).
Second, please try to change the time zone setting in Microsoft Office 365 to the one you have set on your local PC, this document could be a reference for you:
Third, please create an app based on the Excel table to see if the date on the app is equal to the actual date on Excel.
If you are still getting the issue, please check this similar thread for a reference, it seems that there is an issue with Date (not DateTime) when serialized to/from some data sources:
Excel is, um, surprising, when it comes to date/times: they are saved without any timezone data at all.
Also a formula like Text(Data; "[$-pt-BR]dd/mm/yyyy") says "parse the date in Portuguese", but "display it in the local format". If you want Portugues output everywhere, try
Text(Data; "[$-pt-BR]dd/mm/yyyy"; "pt-BR")
Yes, there are two locales here: the input locale (used to parse the date string) and the output locale (used to display the result).
On read-reading the OP, is this Excel loaded via static import, or reading an Excel file via a Connector? Excel static import should always treat datetime as the local timezone, but the Connectors version MAY be treating it as the timezone of wherever the servers are located.
I know a bunch about Excel static import, but nothing about how the Connectors work, so the latter is just a guess.
Tried all of your suggestions guys, none of them worked =(
I need to have this because i'm not going to be the one updating the info on the app, so I cant rely on "Just add one date on the sheet"
As for what @AndyPennell asked, i guess its connector, as I'm using a table that's on my OneDrive Business acc, Mayba the timezone of the servers are another one, since its a multinational organization. But there's no possible way to change it only on my side?
Any other sugestions?
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications