Calculated column format in automated email

(0) Share

Report

Posted on by AC6

Hi,
I have created a flow to send an automated email when a new item is created in SharePoint. In the body of the email, one of the function is a calculated date (done though created a calculated column on SharePoint as follow -

The email on Power Automate is created as such

However, once the email is received the date is shown with a time

How can I remove the time to be automatically created?

Additionally, any way to set up the date to be dd-MM-yyy?

Thank you for your assistance.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AC6 ，

Please nest a formatDateTime function on the outside.

formatDateTime(,'dd-MM-yyyy')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No