DATA DIVERGENCE BETWEEN EXCEL AND POWERAPPS / DIVERGÊNCIA DE DATA ENTRE EXCEL E POWERAPPS

[GabrielBonfim]

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.

[RandyHayes · Accepted solution]

@GabrielBonfim 

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.