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
Responsive Resident
Responsive Resident

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
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published 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 (7,582)