Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Format Date in "Creare SVC table"

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.  




Resident Rockstar
Resident Rockstar

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

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!

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.




Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,668)