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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ISO 8601 conversion of...
Power Automate
Unanswered

ISO 8601 conversion of Time or DateTime Excel dates does not work

(0) ShareShare
ReportReport
Posted on by D_DAL 2

Hi,

We have a regression with one of our flows. After searching, we have found that the ISO 8601 conversion of time or datetime Excel work no more.


To be sure, I have created today a sample :

D_DAL_0-1698328521526.pngD_DAL_1-1698328564125.png

D_DAL_2-1698328611505.png

The flow reads the table.
Here the output:

D_DAL_3-1698328754017.png

Only the date without a time value is converted toward ISO 8601 format.
The time and datetime are no more converted.

 

It was working before, for example:

D_DAL_4-1698329238599.png

 


Any hints to solve this failure?

Thank you.

Categories:
General topics
I have the same question (0)
  • AWorley Profile Picture
    AWorley 414 Super User 2024 Season 1 on at

    Hello, The best way to handle date time in power automate is to convert the date time into "ticks". This will allow you to convert the date time into an integer to run conditional statements off of. 

    For example here is the expression I use to validate if the current time of running is within 6:00 AM and 12:00 PM Eastern Time.

    if(and(greater(ticks(addHours(utcNow(), -4)), ticks(concat(formatDateTime(addHours(utcNow(), -4), 'yyyy-MM-dd'), 'T05:50:00Z'))), less(ticks(addHours(utcNow(), -5)), ticks(concat(formatDateTime(addHours(utcNow(), -5), 'yyyy-MM-dd'), 'T12:01:00Z')))), true, false)

     

      For excel the excel specifics

    How excel reads dates and times is by an numerical integer. If you were to have a date time value then convert it to a number data type in excel you would get a number. For example here's the numerical value for 12/1/2023 at 1:00 AM in excel. 

     

    AWorley_1-1698329735678.png

     For your Time field excel would render that value as shown below: 

    AWorley_0-1698330476403.png

     

     

    The best way to handle date times in Power Automate is to ingest the excel value as a string, assign it to a variable or a Convert Date Time Action, then work with the value exclusively in PA rather than Excel. 

  • D_DAL Profile Picture
    D_DAL 2 on at

    Hi AWorley,

    Thank you for your help.

     

    First, we had to implement a formula to publish in Excel dates Excel can handle properly (thanks to https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Excel-Date-changes-in-Power-Automate/ba-p/799959). 

     

    Now, we are facing a regression because the ISO 8601 conversion by Power Automate is no more able to handle properly datetimes. So, we have to implement a workaround in our Excel tables to duplicate each date, time, datetime column as a string column with a formula to produce directly the correct ISO 8601 value.

    D_DAL_0-1698397948347.png

    And adapt all our flows to use these duplicate columns to work with.


    Forgive my French, the qualifier “Power” is totally usurped when it comes to Excel.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans