Customer experience | Sales, Customer Insights,...

How can I convert a date format within Power Automate?

(0) Share

Report

Posted on by Nima31

Hello,

I have a flow that generate a document from dynamics 365 with a date in this format "26/09/2019 9:58 AM" (this is the format in CRM), I want to convert the date to "26 Septembre 2019" without using code to include it to an email. How can I do that please?

I tried this formula but it doesn't work:

4452.pastedimage1577989498233v1.png

I also tried this connector:

Thank you so much for your help!

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

necsa 3,455 on at

Like (0)

Report

Hi Hammal,

Please take as reference following link:

www.flowjoe.io/.../

Was this reply helpful? Yes No
Suggested answer

cloflyMao 25,210 on at

Like (0)

Report
Hi Hammal,

Just apply formatDateTime function to your date fields.

I created an HTML table for an appointment for test:

dynamic expression with formatDateTime function:

formatDateTime(item()?['scheduledstart'],'yyyy-MM-dd') formatDateTime(item()?['scheduledend'],'yyyy-MM-dd')

Result:

Regards,

Clofly

Was this reply helpful? Yes No
Nima31 75 on at

Like (0)

Report

Hi Clofy,

It works perfectly.

Thank you!

Was this reply helpful? Yes No