cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 360 members 4,692 guests
Please welcome our newest community members: