cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
Community Support
Community Support

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

Highlighted
New Member

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
Highlighted
Community Support
Community Support

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

Highlighted
New Member

Re: Formatting Date and Timestamp to Excel

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

View solution in original post

Highlighted
Advocate III
Advocate III

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

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

Top Solution Authors
Users online (8,820)