I have a flow where an email is generated at the end of the flow. I am using dynamic content from excel. when using it in the email for a date. it is giving me the output of 45226 vs 10/27/2023 which is the date value in excel.
How can i fix this?
Hi @Nicktrom55 ,
Please try setting the DateTime format to ISO 8601 as shown:
Ellis____________________________________If I have answered your question, please mark the post as ☑️ Solved.If you like my response, please give it a Thumbs Up.My Blog Site
It gave me this 2023-10-27T00:00:00.000Z
is there a way to get it to be 10/27/2023
You can use an expression to format the date:
formatDateTime('2023-10-27T00:00:00.000Z', 'MM/dd/yyyy')
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.
Michael E. Gernaey 462 Super User 2025 Season 2
Tomac 456 Moderator
abm abm 243 Most Valuable Professional
