Answered

date format problem save date powerapps to excel

(0) Share

Report

Posted on by jvenegash

Hi everyone, I trie to save a single date with time in my excel, but the result is totally diferent.

I have a datacard, inside it have a datavalue setting with this formula Text(now(),"dd/mm/yyyy hh:mm:ss"),because I need to save like a timestamp record.

But when i saved in to excel online, the date appear like this 08/03/2020 16:19:54

But the real and you can see in PowerApps datavalue is 03/08/2020 10:20:27

Some idea?? I think maybe is related with the UTC o local But in PowerApps I put Local.

I don't know if in excel online o OneDrive I can change it??

Thanks !!!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

cds 1,001 on at

Like (0)

Report
Copy link

Link copied!

Did you read this article?

Was this reply helpful? Yes No
SaiKrishnaGudluru 499 on at

Like (0)

Report
Copy link

Link copied!

@jvenegash I am unable to repro this issue. I am able to save and retrieve the data as it is.

Otherwise you can try directly this way - Text(Now(),"[$-en-US]mm/dd/yyyy hh:mm:ss")

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!
Hi @jvenegash:
Do you mean that the time in Excel is different from time loading in PowerApps?
The reason why you met this problem is that:
Excel save time as UTC time by default.
PowerApps load time as local time by default.
So when PowerApps load time, it will transfer to local time zone automatically.
In order to solve the problems mentioned above, I suggest you save local time to Excel and load time in PowerApps as local time too. //make time zone the same.
When you are changing the data source, you need to use the following formula:

DateAdd(Now(),-TimeZoneOffset(),Minutes)

instead of

Text(now(),"dd/mm/yyyy hh:mm:ss")

When you load the date in excel, you need to use the following formula：

DateAdd(Thedate,TimeZoneOffset(),Minutes)

I think this link will help you a lot:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Date-Picker-Sends-Wrong-Date/td-p/488289
Best Regards,
Bof

Was this reply helpful? Yes No
ErwanF 94 on at

Like (0)

Report
Copy link

Link copied!
Mate, you are the best. Kudos!!

I had this everywhere on my apps.
Text(now(),"dd/mm/yyyy hh:mm:ss")

You just saved me hours of troubleshooting. Many thanks and would buy u a beer!

Was this reply helpful? Yes No