cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Incorrect time is getting displayed in PowerApp

Hello, I am loading data from Sharepoint and displaying powerApp.

In sharepoint data source we have Event Start and EWnd Time values (mm/dd/yyyy HH:mm).

The time i sgetting wrongly displayed in powerapp.

 

Lets say, My EventStartTime values in share point is 01/12/2017 09:00 AM. In powerApp it is getting displayed as 01/12/2017 12:00 AM.

 

NOt sure how to fix this? Any input? Is there any way I can conver the time to Local Time zone?

 

Here is link to image where powerApp collecting is having different time for the same date from share point https://1drv.ms/i/s!AuLElRm7ChiimDMl1RYGN0GSSXt-

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Incorrect time is getting displayed in PowerApp

6 REPLIES 6
Highlighted
Community Support
Community Support

Re: Incorrect time is getting displayed in PowerApp

Hi @balachandra,

 

This should be related with the date time zone.

By default PowerApps would change the date time into UTC time zone. Currently this is not available for PowerApps to auto-detect the local time zones for the date time value. The Product team is aware of this and are working on a solution for this scenario.

For a workaround, you may consider to use the text function to convert the time zones.

For the details, please check the thread below:

Date displayed is one day off

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Incorrect time is getting displayed in PowerApp

Okay. Thanks for your reply.

 

Actually I am doing the same as you suggested. I am using Text funtion.

 

I bind dataSource directly to TextControl. Datasource field is already of type DateTime.

I did like below. But it is not working.

Text = Text(EventStartTime,"[$-en-us]HH:mm")
Highlighted
Regular Visitor

Re: Incorrect time is getting displayed in PowerApp

Okay. Thanks for your reply.

 

Actually I am doing the same as you suggested. I am using Text funtion.

 

I bind dataSource directly to TextControl. Datasource field is already of type DateTime.

I did like below. But it is not working.

Text = Text(EventStartTime,"[$-en-us]HH:mm")
Highlighted
Helper II
Helper II

Re: Incorrect time is getting displayed in PowerApp

@v-micsh-msft

The link in your post in inaccessible. I am facing the same issue, the date stored in the DB is not showing up as is, PowerApps is converting it and so the date and time are off. Can you please repost the URL? Thanks.

Highlighted
Anonymous
Not applicable

Re: Incorrect time is getting displayed in PowerApp

Highlighted
Microsoft
Microsoft

Re: Incorrect time is getting displayed in PowerApp

This link isn't working either, i'm in the middle of trying to understand this as well as i'm currently trying to resolve this issue.

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

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

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,336)