Notifications
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 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
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 try this
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 245 Super User 2025 Season 2
Expiscornovus 207 Most Valuable Professional
trice602 185 Super User 2025 Season 2