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

Powerapps timezone with Excel



My powerapps is connected to an excel file in sharepoint. For each time entered there is a decay of 2 hours. I searched everywhere for this problem, set timezone of sharepoint and powerapps to europe (PARIS) , but nothing change.

Capture d’écran (13).png


Any idea to solve this problem ?






Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Powerapps timezone with Excel

What you are seeing is a mismatch in how Excel "thinks" of date/time values, and how PowerApps does. In Excel, date/time values represent an absolute value of time: October 4th 2018, 8:00AM will be 8 AM on 2018-10-04 regardless of whether the time is seen in France, Canada or Australia. In PowerApps, date/time values represent a point in time: if you're in France (currently UTC+0200) and say 2018-10-04 08:00:00, I'm in Seattle (UTC-0700) and see the value as 2018-10-03 23:00:00. So you have this mismatch when trying to use date/times from Excel in PowerApps.


The blog post at has more details about this issue, and a way to convert between the Excel time and PowerApps time. It was written about datetime columns in SQL, but this is the same issue that is affecting Excel.

Level: Powered On

Re: Powerapps timezone with Excel

OK. I have 4 hours to complete with a date set with a time picker and 8 dropdowns (4 for the hours: hour1, hour2,.... and 4 for minutes: minute1, minute2,...). I build the 4 hours with Date+Hour1+minute1, Date+Hour2+minute2,...

Do I need to patch Datetime value for each datacardvalue or when submitted ?

              DatePicker1.SelectedDate +
              "yyyy-mm-dd hh:mm:ss")

In this example, there is only one datetime to patch. What will be the code for the 4 datetimes ?

Thank you a lot for help because there are few help for this.

Level 10

Re: Powerapps timezone with Excel

hi @JimNoredlac have you reviewed the blog post supplied by @CarlosFigueira? If that post does not provide the help you need, please reply back so we can assist. 


Thank you.



Helpful resources

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.


Power Apps Community User Group Member Badge

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


Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.


Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

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