web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel List Rows presen...
Power Automate
Answered

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

(0) ShareShare
ReportReport
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?

 

HansenvomDeich_0-1712128064870.png

 

 

Categories:
Building flows
I have the same question (0)
  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @HansenvomDeich 

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

    vyueyunmsft_2-1712137304670.png

     

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

    vyueyunmsft_1-1712137266227.png

     

     

    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

  • Verified answer
    HansenvomDeich Profile Picture
    HansenvomDeich 184 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 284 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 188 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 144 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans