Inconsistent ISO 8601 formatting on Excel connector

(0) Share

Report

Posted on by A-Stubbs

I have an excel sheet with a table containing two Date formatted columns.

In my flow, I am using the List Rows from Excel connector, with the ISO 8601 date format configured:

This is a twice daily scheduled flow and was previously working as expected, until the behaviour changed early on November 30th. without the flow being modified:

Since this run, my first column is coming back as a correctly formatted ISO 8601 date, but the second column is coming back as the Excel serial date format:

In Excel, neither column has been updated and are both still Date formatted, and in Flow the connector is still configured to use the ISO 8601 formatting.

I would wonder if it was a limitation of the connector for only the first Date column to obey the formatting configuration, but it was working for weeks after I initially created the flow.

Categories:

Business Process Flows

All responses (3)

Answers (0)

Pstork1 65,906 Most Valuable Professional on at

Like (0)

Report

Re: Inconsistent ISO 8601 formatting on Excel connector

Not sure why its happening then, unless its a bug in the connector if you have more than one date column.
A-Stubbs 3 on at

Like (0)

Report

Re: Inconsistent ISO 8601 formatting on Excel connector

Hi, both columns are the same Short Date excel built-in:
Pstork1 65,906 Most Valuable Professional on at

Like (0)

Report

Re: Inconsistent ISO 8601 formatting on Excel connector

What specific date formats are you using in Excel for the two columns? Is it one of the built-in formats like ShortDate or is it a custom date format?