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

Formatting Date and Timestamp to Excel

Trying to run a flow for logging my working hours (started using the formatting from the template) and am getting the date and time in weird formats. I'd love the date, when manually triggered, to appear in MM/DD/YYYY format and the time to just appear as HH:MM in a 12 hour format. At the moment the Key-button-timestamp button gives me the date as well as time down to the second and I can't figure out how to format the output. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Formatting Date and Timestamp to Excel

Hi @Celdere,

 

Do you want to formate the datetime from timestamp with type 'MM-dd-yyyyTHH:mm'?

 

If you would like to formate the datetime from timestamp with type 'MM-dd-yyyyTHH:mm',you could refer to screenshot below to create the flow:

Capture.PNG

 

The expression in the Compose 2 as below:

formatDateTime(outputs('Compose'),'MM-dd-yyyyTHH:mm')

The flow would run successfully as below:

Capture.PNG

 

 

Please let me know if your problem could be solved.

 

Best regards,

Alice

 

 

 

 

View solution in original post

Celdere
Level: Powered On

Re: Formatting Date and Timestamp to Excel

Made it work using the DateTime convert timezone function. Thanks!

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Formatting Date and Timestamp to Excel

Hi @Celdere,

 

Do you want to formate the datetime from timestamp with type 'MM-dd-yyyyTHH:mm'?

 

If you would like to formate the datetime from timestamp with type 'MM-dd-yyyyTHH:mm',you could refer to screenshot below to create the flow:

Capture.PNG

 

The expression in the Compose 2 as below:

formatDateTime(outputs('Compose'),'MM-dd-yyyyTHH:mm')

The flow would run successfully as below:

Capture.PNG

 

 

Please let me know if your problem could be solved.

 

Best regards,

Alice

 

 

 

 

View solution in original post

Celdere
Level: Powered On

Re: Formatting Date and Timestamp to Excel

Made it work using the DateTime convert timezone function. Thanks!

View solution in original post

GrischkePro
Level: Powered On

Re: Formatting Date and Timestamp to Excel

You're a waste of space!

 

If you got it working, why didn't you say how? Delete this thread!

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

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 Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,282)