Power Automate to convert date to dd mm yyyy

41 Views Asked by At

Can you please help?

I am trying to convert the date format using PowerAutomate.

I have a sharepoint list with multiple columns, every time it creates an entry it sends an email.

For example in my sharepoint list it stores date as 20/03/2024 What I'm trying to do is when it sending the email it needs to convert to 20 March 2024 and add it to the email.

I have tried this code

if(empty(triggerBody()?['From']), 
'No Date Available', 
formatDateTime(triggerBody()?['From'], 'dd MM  yyyy'))

But it when I receive the email it shows No Date Available,

I have tested placing above expression and also default Dynamic content value.

Dynamic content value shows the date as 2024-03-19 But he expression shows as No Date Available.

enter image description here

enter image description here

enter image description here

Thank You!

0

There are 0 best solutions below