Unanswered

How do i format int Date to yyyy-MM-dd?

(0) Share

Report

Posted on by jeo

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.
Screenshot 2024-05-20 095334.png Screenshot 2024-05-20 095316.png

Thank you,
Jeo

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-mengmli-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
jeo 46 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (0)

Report
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.

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

Was this reply helpful? Yes No
jeo 46 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No