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

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

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!

Users online (106,501)