Skip to main content

Notifications

Community site session details

Community site session details

Session Id : eAaf4OyH+/Pp51uLm3K0c0
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 9 Jan 2025 19:18:28 by 24
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:
  • Verified answer
    Pstork1 Profile Picture
    66,545 Most Valuable Professional on 09 Jan 2025 at 19:46:12
    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
     

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 349 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 271 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 263

Overall leaderboard
Loading started
Loading complete