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

Like (0) Share

Report

Posted on 3 Apr 2024 07:05:02 by HansenvomDeich

182

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?

All responses (2)

Answers (1)

Verified answer

HansenvomDeich 182 on 05 Apr 2024 at 16:16:04

Like (0)

Report

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

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.
v-yueyun-msft on 03 Apr 2024 at 09:42:23

Like (0)

Report

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

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

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates