Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Parsed date from excel appears as a serial number

(0) ShareShare
ReportReport
Posted on by 21

When I parse a date from excel and try to use it as a dynamic content, it appears as a serial number.
I am looking for a way to make the date appear as a date format.

I am unable to apply formatdatetime to the dynamic content of the parsed date.

  • Re: Parsed date from excel appears as a serial number

    Hi @EnochMan ,

     

    Please take a look at this post.

    https://powerusers.microsoft.com/t5/Building-Flows/Convert-serial-number-to-date-format/td-p/895975

     

    Best Regards,

    Wearsky

  • EnochMan Profile Picture
    EnochMan 21 on at
    Re: Parsed date from excel appears as a serial number

    Thanks a lot. I believe that should work, unfortunately making that change will affect the rest of my flow.
    My flow sends an email reminder 2 weeks before a date in an excel file expires.
    To do that, I have had to convert today's date into a serial number and compare it with the date in the excel sheet.
    Then I use the list rows present, filter array (to compare the two integers, i.e todays date and the date of expiration) and parse Json to make the contents of the excel sheet available.
    If I change the date format in the excel connector to ISO 8601 my flow fails because the filter array cannot compare it as an integer with today's date (which I have converted to an integer).
    I want to find a way to maintain the flow and change the parsed date which is an integer into the ISO 8601 format.
    Thanks a lot.



  • Re: Parsed date from excel appears as a serial number

    Hi @EnochMan ,

     

    Please try this

    vxiaochenmsft_0-1713751637506.png

     

     

    Best Regards,

    Wearsky

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics