Powerapps is reading Excel data and displaying different data on it. In the example below, in the Excel chart the data is: "11/1/2018 0:00 (m/d/yyyy h:mm)". But at Powerapps this information appears as: "10/31/2018 9:00 (d/m/yyyy h:mm)". I mean, it is appearing with a variation of 3 hours less than the given in Excel.
------
O Powerapps está lendo os dados do Excel e apresentando dados diferentes. No exemplo abaixo, no excel está o dado: "11/1/2018 0:00 (m/d/yyyy h:mm)" . Powerapps esta informação aparece como: "31/10/2018 21:00 (d/m/yyyy h:m)". Ou seja, está aprerecendo com uma variação de 3 horas a menos do que o dado no Excel.
Solved! Go to Solution.
You might want to take a look at the TimeZoneOffset function.
You are most likely dealing with a TimeZone adjustment. This function will help you correct dates to the appropriate time zone.
I hope that is helpful for you.
You might want to take a look at the TimeZoneOffset function.
You are most likely dealing with a TimeZone adjustment. This function will help you correct dates to the appropriate time zone.
I hope that is helpful for you.
User | Count |
---|---|
184 | |
123 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
159 | |
132 | |
85 | |
78 |