Announcements
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.
Hi @EnochMan ,
Please try this
Best Regards,
Wearsky
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.
Please take a look at this post.
https://powerusers.microsoft.com/t5/Building-Flows/Convert-serial-number-to-date-format/td-p/895975
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 103 Super User 2026 Season 1
Haque 87
trice602 63 Super User 2026 Season 1
