web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - General Discussion / DateTime Format ISO 86...
Power Automate - General Discussion
Unanswered

DateTime Format ISO 8601 only converting one column from Excel

(1) ShareShare
ReportReport
Posted on by javierdavidh 9

Hi, I am getting some rows from excel based on the value, I need to work with two columns dateTime type:

I choose the Date format option : " Format ISO 8601 " 

But only one of them is well converted with the right format but the second one comes as a string: 

 

Excel file:

javierdavidh_6-1712164834996.png

 

***The format in Excel is the same for both columns.

 

Flow:

 

javierdavidh_4-1712164715948.png

 

 

 

javierdavidh_2-1712164634220.png

Result:

javierdavidh_3-1712164664856.png

 

Why the option "Format ISO 8601" only works for one value?

 

I just need the 2 values in 'yyyy-MM-ddTHH:mm:ssZ'  format.

 

Can I have some help please? thank you ! 

 

 

I have the same question (0)
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 18,029 Super User 2025 Season 2 on at
    Re: DateTime Format ISO 8601 only converting one column from Excel

    Hi @javierdavidh 

     

    This seems to be a issue with excel. that number shown for second date column in compose action represents number of days from 1st Jan 1900. 

     

    May be try to format the second date column as text and see whteher tthat works for you ?

    Else workaround would be like this as shown in post for adding the 1st jan 1900 to the integer to get the date.

    https://powerusers.microsoft.com/t5/Building-Flows/Excel-dates-turned-into-integers/td-p/130364

     

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 560 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 347 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans