Unanswered

Dates from Excel

(0) Share

Report

Posted on by Roisinc21

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:

General topics

I have the same question (1)

All responses (3)

Answers (0)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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?

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.

Was this reply helpful? Yes No
Roisinc21 16 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
marc756 25 on at

Like (0)

Report
Copy link

Link copied!

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...

Was this reply helpful? Yes No