Format Date in "Creare SVC table"

[Yudistara]

I am trying to capture the "Created" date from my SharePoint list in the csv file. And this csv will be emailed out as an attachment. But date outputs as 2019-03-27T19:00:52Z, where I only need 2019-03-27. I tried formatdatetime but couldn't get it to work.  

Can i format the date in "Create csv table" action? or should I create a "compose" and then insert in create  csv table ? Please advice.  

[AlanPs1]

Hi @Yudistara , thank you for your post.

Based on the information provided

You want 2019-03-27T19:00:52Z to become 2019-03-27.

The below should do that for you.

formatDateTime(body('Get_items')?['Created'], 'yyyy-MM-dd')

Note: Please be certain that your "Created" is exactly body('Get_items')?['Created'] and this should work.

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[Yudistara]

Thank you @AlanPs1  for the help. When you meant that my "Created" is exactly body('Get_items')?['Created'], I dont see the "Created" appearing in the Dynamic content. And when i manually type the formula i get the below error.

Please let me know if I can provide additional information with my FLOW.