web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Calculated column form...

Power Automate

Unanswered

Calculated column format in automated email

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

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

Join the conversation