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.