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
Copy link

Link copied!

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
Copy link

Link copied!
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
Copy link

Link copied!

Hi Clofy,

It works perfectly.

Thank you!

Was this reply helpful? Yes No