cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
balachandra
Level: Powered On

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
TopShelf-MSFT
Level 10

Re: Incorrect time is getting displayed in PowerApp

6 REPLIES 6
Community Support Team
Community Support Team

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.
balachandra
Level: Powered On

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")
balachandra
Level: Powered On

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
Cybersurfer411
Level: Powered On

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.

TopShelf-MSFT
Level 10

Re: Incorrect time is getting displayed in PowerApp

russrimm
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,636)