46
Hello everyone,
How do i format the date output from filter array to yyyy-MM-dd? I cannot change the format of the date to ISO 8601 in List rows present in a table as it will cause an error.
Thank you,
Jeo
Hi @jeo ,
Please check if the dynamic content in body of email comes from another "Apply to each", if so, you should move the Send email action into "Apply to each" which is about current item dynamic content.
———————————————————————————————————————————————————
If my previous answer helps you solve the problem, please accept it as solution.😀
If you have another problem, please post it in new post.
Best regards,
Rimmon
Hello @v-mengmli-msft ,
It worked! However, do you know how to get the output into the email? because when i put the output of the "apply to each" for the body for the "send an email" knode. It shows the error message.
Hi @jeo ,
If ISO8601 will influence other steps in your flow, I recommend you don't turn on it, you can also try expression to convert number in outputs of filter array to date.
Share
Report
All responses (
Answers (
addDays('12/30/1899',int(items('Apply_to_each')?['ColumnTest']),'yyyy-MM-dd')Here is a link about getting ISO8601 date from excel.
How to get date from Excel as a date in Power Automate flow (tomriha.com)
Best regards,
Rimmon
Hello @v-mengmli-msft
When i turn on ISO8601, i get an invalid template error. The select knode is used to convert the date into integer.
Thank you,
Jeo
Hi @jeo ,
I think this is because the format of date of outputs of List rows in a table is number, I recommend you try turn on ISO8601 setting of List rows in a table.
You can also try below expression to convert number to date.
addDays('12/30/1899',int(items('Apply_to_each')?['ColumnTest']),'yyyy-MM-dd')
Best regards,
Rimmon
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
