Data for column date in excel sharepoint document from list rows action in an unknown format

Like (0) Share

Report

Posted on 9 Jan 2025 19:18:28 by knparksnyc

Data for column date in excel sharepoint document from list rows action in an unknown format:

it's being interpreted like this from the list row excel action in cloud flow and I can't formatdatetime to this value. any suggestions to get the correct date format?

A previous question about this fixed the issue had to set the format Datet time in the list rows action to ISO 8601, have an issue with another date column it still in the serial number format.

"Start time": "45461.5587268519"

This is the format it's in in excel:

Categories:

Flow Mobile App

All responses (1)

Answers (1)

Verified answer

Pstork1 66,154 Most Valuable Professional on 09 Jan 2025 at 19:46:12

Like (0)

Report

Data for column date in excel sharepoint document from list rows action in an unknown format

That ;format is called a Serial Date format. Its the way Excel Stores dates. If you check the additional properties of the List Rows action you are using to retrieve the data you'll see a dropdown at the bottom where you can pick between the serial date format and the ISO 8601 date.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog