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)
20
Share
Report
All responses (
Answers (
