cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Yudistara
Level: Powered On

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.  

 

FLOW.jpg

 

2 REPLIES 2
Super User
Super User

Re: Format Date in "Creare SVC table"

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!


Yudistara
Level: Powered On

Re: Format Date in "Creare SVC table"

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.

 

Created_missing.jpgerror.jpg

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,107)