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

How to format a Date and Time value to use it in a 'Create CSV table' with custom columns?

How is formatting a Date and Time value in a 'Create CSV table' data operation done? 

 

I need to format date time field from the 'Get items' in order to use it in the 'Create CSV table' with custom columns. 

 

When I try to do a Compose - data operations  action or Convert time zone action to format the date time field it puts it in an 'apply to each' but the output from the Compose or Convert time zone doesn't become available to use in the 'Create CSV table' with custom columns.

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-yamao-msft
Community Support
Community Support

Hi @Anonymous,

 

Please just try to enter the function in the formula bar under Expression tab.

Please check the following flow configuration for a reference.

The code used to format the date column is:

formatDateTime(item()?['Date'],'yyyy-MM-dd')

1.PNG

Please feel free post back if you need more help.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

 

Thanks for the clue, this is the format I ended up needing to use:

 

convertTimeZone(item()?['DateTime'], 'UTC','Pacific Standard Time','MM/dd/yyyy HH:mm')

 

View solution in original post

2 REPLIES 2
v-yamao-msft
Community Support
Community Support

Hi @Anonymous,

 

Please just try to enter the function in the formula bar under Expression tab.

Please check the following flow configuration for a reference.

The code used to format the date column is:

formatDateTime(item()?['Date'],'yyyy-MM-dd')

1.PNG

Please feel free post back if you need more help.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

 

Thanks for the clue, this is the format I ended up needing to use:

 

convertTimeZone(item()?['DateTime'], 'UTC','Pacific Standard Time','MM/dd/yyyy HH:mm')

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (1,903)