I have two different flows that collects data. Each flow collects data from a different Excel Online (Business) file the data is transferred to the same SharePoint List. The First Excel file gathers data of errors entered from MS Forms. The second Excel file are simple data entries. Where the weirdness comes in is the Date and Time conversion. Both Excel files utilize Date and Time but when that gets transferred to the SharePoint List there is an hour difference. At first I though it was due to something between a manual entry of Date and Time vs an Auto populated Date and Time from MS Forms, but the actual serial number is the same.
Does anyone have a good reason for the difference between these?
Here is the expression I am using to convert from the serial number to data and time:
addSeconds('1899-12-30',int(formatNumber(mul(float(item()?['Submitted Date']),86400),'0','en-us')),'MM-dd-yyyy HH:mm')
Screen Shots of the first flow to show that Date and Time Outputs. the Compose 2 is just showing the serial number pulled from the Excel file.
Here is the second flow. Again, the Compose 2 is just to show the serial number of Date and Time from the Excel file.
Not sure exactly why I have to subtract one hour from one of the flows when they are saved in the same Document folder, created from the same location and the end result goes to the same SharePoint List.
