Data transfer from power apps to excel

[Colton_Hicks1]

I have an app where I select data in the app to update an excel table. All of the fields are working except for the time field, I cannot figure out why but in my excel sheet the time is always 5 hours more than what I select within the app. Any Ideas on what it could be?

  

[FLMike]

Hi,

Is the primary data only in Excel or are you pointing to SharePoint or Dataverse?

I am going to make an assumption that there is a difference between the TimeZone of the Power App Data(whether its SharePoint or Dataverse, based on settings) and the Machine(local or remote) TimeZone.

As if one is UTC and one isn't.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Colton_Hicks1]

The primary data is in excel and that data is being used to fill out the form that can then be edited to update the excel sheet. I will investigate the time zone thing thank you for the suggestion. 

[Colton_Hicks1]

The other issue is that it is not a time that I am picking it is just 2 droop down menus one for hour value the other for minute value so I do not see how time zones could be affecting this. 

[FLMike]

Hi,

Is this a Date value and ACTUAL date value or a string.

If you are putting data in the excel as a DATE value, then its getting converted based on time zone.

Please provide details/explain how you go from the drop downs to a Date / Time in excel.

You are clearing doing something with the drop downs + excel if its turning into a Date Time which you say is not the same between the two. if its just a string then you are doing something wrong. If its a date time, then its an issue being converted from "whatever you have string/date" to a date time in Excel.

Please provide details on how it works from UI to Excel and how it gets there and if the field in Excel is formatted as a date time.

[Colton_Hicks1]

In the UI I select the drop down number for the hour and for the minute. It is then put into this time function {Time(Value(HourValue.Selected.Value),Value(MinuteValue.Selected.Value),0}. Where the value of the dropdowns are selected for hour and minute. I have to include the value outside and the .value inside the parenthesis or it will not work. The data is then submitted through a submit form button that will update a table in an excel sheet. The Time is then put into a column formatted for time. I have tried to mess with the formatting within this column to not auto select the time zone, but the time in hours is always 5 hours ahead of every selected time. I have also tried to make the power apps code to be {(HourValue.Selected.Value-5) and that works but will then display an incorrect time in power apps.