
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.
Hi @AC6 ,
Please nest a formatDateTime function on the outside.
formatDateTime(,'dd-MM-yyyy')
Best Regards,
Sunshine Gu