cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

date format problem save date powerapps to excel

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 !!!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: date format problem save date powerapps to excel

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) 

 

 

2.JPG

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

 

View solution in original post

3 REPLIES 3
Highlighted
Impactful Individual
Impactful Individual

Re: date format problem save date powerapps to excel

Did you read this article

Highlighted
Resolver III
Resolver III

Re: date format problem save date powerapps to excel

@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")

Highlighted
Community Support
Community Support

Re: date format problem save date powerapps to excel

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) 

 

 

2.JPG

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

 

View solution in original post

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,449)