Excel List Rows present in a Table, date Issue, some converted to iso some not

(0) Share

Report

Posted on by HansenvomDeich

184

Hi,

i try to get Data from Excel.

I got some Dates in Different Columns, after i get failures i set that Testwise all on 17.10.2019 all Cells are Formated as Date.

I use the Action List Rows present in a Table with Option DateTimeFormat ISO8601.

So i know, how to convert the Dates from Excel when its string to Dataformat in Power Automat.

To work with Auto Convert Dates in Iso Format is better to handle, the Problem:
The Feedback from Action gives me 2 Values in ISO 8601 and the rest in String.

Any Ideas, that the Action is working correct and format all Dates to iso format?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Hi , @HansenvomDeich

You need to check if your Date type is the same in your Date column in your Excel file.

And check if you select the ISO 8601 in your action.

And for the number we can also convert it to the Date, you can refer to:
Solved: Excel file to list flow: date issue - Power Platform Community (microsoft.com)

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Verified answer

HansenvomDeich 184 on at

Like (0)

Report

Thanks for your thoughts at first.

I´ve got the failure pointet.

The Cells all have the same Format (Date) and also the Date (values) are the same and valid.

What i´ve found out after hours to ask me why that happend , i remember i had that Problem before.

The Date is entered from VBA Script when i create an Folder and File to that ID in the Row VBA also set the actual Date in that Cell and build a hyperlink on that. Later i throw out the Hyperlinks.

I Remember, i had the same issue before with the Dateformats... and the only fix was, mark that cell, go in the Edit Form where i can Edit the Text in the Cell, tap in there as i wanna edit the date and press enter.
Thats the Fix ^^ after that the Date is identified in the right Format, like all the other dates.

So my Workaround was, get 1200 Rows and get an Report of all the Date Values in the Rows in Power Automate (simple Compose with all the items which i have to check), find out in Notepad++ which Rows the wrong Date Formats has in it, and manually go in the rows in the excel and do the workaround which i have describes before.

Now all the Date Values are working correct.

Was this reply helpful? Yes No