Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

'List rows present in a table' format set to ISO, returns date as Serial Number for SOME users

(0) ShareShare
ReportReport
Posted on by 4
I have a power automate flow using Excel Online connector. The action 'List rows present in a table' has the DateTime format already set to convert to ISO 8601 but for some specific users, the action returns the dates in serial number format instead of the ISO. There are also some users that returns it with the correct ISO format.
 
 
For User 1 with correct returns: 
 
For User 2 with serial number dates as returns:
 
 
 
For context, the flow creates a file in a SharePoint Library first, then gets the table, then list the rows present in the created table.
 
 
I already checked on the files being created, and the dates there shows correct date format (ISO). Only the action for the specific users returns the serial number instead.
 
Is there any setting on the user end that I need to check or change? Or are there any other workarounds I can do without having to convert the dates manually? (This table has more than 1000 rows so we don't want to have keep looping to manually change the date format)
 
Categories:

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics