Power Platform Community Forum Thread Details

I have a flow that reads multiple excel files each day from a SharePoint library. The tables read include columns for users to record time stamps for activities. But for some reason the time stamps are not always read in the same format. Sometimes the time will read on a Date-Time format, and sometimes I get a decimal number. Please see an examples of the issue below.

Here are the settings for the list row step in my flow, datetime format is set correctly.

Here is the excel table where the users enter the times.

Format settings for the cell seem correct.

But when the flow reads this table, it reads the "Start Time" in the correct date and time format, but the "Stop Time" as a decimal.

This happens twice on this table, but more than a dozen copies of this same form are submitted daily. Sometimes the entire report reads correctly, and sometimes more than half of the time stamps (both start and stop) come in as decimals. Its very inconsistent.