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

Power app not showing excel dates difference of 16 hours.

Hi

I built a power app that is connected to an excel sheet.  The odd thing is that a date time field value in excel is showing up in the date/time field in the powerapp with a difference of 16 hours.  Does anyone know why this is? It’s very odd. 
Mike

2 REPLIES 2
Super User
Super User

Re: Power app not showing excel dates difference of 16 hours.

@Mbruse
Usually any dates and times brought in from Excel are displayed in local time because they do not include any timezone information. But in your case offset is occurring. Perhaps the datetime is being converted to UTC for some strange reason.

Try this code to convert from UTC to local time. Replace MyDatetime with your own Excel column name.

DateAdd(ThisItem.MyDatetime, −TimeZoneOffset(ThisItem.MyDatetime), Minutes )

If that does not work you could also try to manually offset the time. Use either 16 or -16 hours depending on your requirements.

DateAdd(ThisItem.MyDatetime,16,Hours)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
Microsoft v-siky-msft
Microsoft

Re: Power app not showing excel dates difference of 16 hours.

Hi @Mbruse ,

 

Yes, it is because the Time Zone difference between two data source commonly.

The Time Zone of your PowerApps is based on your local time zone in default.

So, I guess Time Zone of your Office365 is not correct. The simplest way use '=Now()' in excel formula bar to see if the date time is your local time.

Snipaste_2019-11-26_11-44-57.png

The workaround to the problem once and for all:

Log out every PC you have everywhere (Excel Online, OneDrive, etc.)
Log in into your office365 account
Click on Your Info
Then Edit country/region

In there you can change your location and the time zone.


Snipaste_2019-11-26_11-49-49.png

Best regards,

Sik

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps 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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

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