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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Dates from Excel

(0) ShareShare
ReportReport
Posted on by 16

Anyone seen an issue where get-rows from an excel table using the iso8601 date time format suddenly stopped working?

 

I was using this successfully for months and suddenly this has now stopped returning the standard date from and reverted back to using the serial date.  This has completely broken my flow made it completely unusable.  At this point it will require an entire rebuild of the work flow to use a date conversion function as there are several actions built in after this initial early step, any help would be very appreciated.

 

P.S I have tried reacreating a trigger and regreating the list rows action to no avail.

 

 

Categories:
I have the same question (1)
  • CFernandes Profile Picture
    8,482 Most Valuable Professional on at

    Hello @Roisinc21 

     

    To add some more context - You are using the List rows present in the table and setting the Date time format to ISO8061?

     

    CFernandes_0-1647965018858.png

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

     

     

  • Roisinc21 Profile Picture
    16 on at

    Yes this is exactly how the flow is configured but its now suddenly returning serial dates.  I have also created some brand new flows and tested against multiple tables and facing the issue across them all, serial date every time

  • marc756 Profile Picture
    25 on at
    I face exactly the same issue. The connector stopped converting serial dates from excel to ISO8601 from one day to the other. It used to work just until this week. I openend another post for this issue:  https://community.powerplatform.com/forums/thread/details/?threadid=bdb04023-e5af-f011-bbd3-000d3a184f11

    This is a serious bug which needs to be fixed asap. I just don't know how to report this to Microsoft directly...
     

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 273 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 135 Most Valuable Professional

Last 30 days Overall leaderboard