cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Format Sharepoint List item date after Apply to each step

Hi all,

 

I need to format my date item that I get from my SP list after an Apply to Each step.

 

I tried the format time funcion but its not working 

 

This is my Date value : @{items('Apply_to_each')?['Planned_x0020_date']}

 

I tried using Compose but no luck yet

 

formatdatetime(triggerBody()?['Planned_x0020_date'],'MM/dd/yyyy')"

 

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
gazzo1967
Impactful Individual
Impactful Individual

@Anonymous 
try using 

formatdatetime(body('Get_item')['Planned_x0020_date'], 'dd/MM/yyyy')

in your compose then you should be able use the output
HTH
Gary
if my answer helps solve your issue, then mark as solution so someone else can find the answer if needed 🙂
Consider a thumbs up too 🙂

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

I managed to do this:

 

testingpower127_0-1603472733005.png

 

But the output is still showing as 2020-10-28

gazzo1967
Impactful Individual
Impactful Individual

@Anonymous 
try using 

formatdatetime(body('Get_item')['Planned_x0020_date'], 'dd/MM/yyyy')

in your compose then you should be able use the output
HTH
Gary
if my answer helps solve your issue, then mark as solution so someone else can find the answer if needed 🙂
Consider a thumbs up too 🙂

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,852)