web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Custom DateTime format
Power Automate
Unanswered

Custom DateTime format

(1) ShareShare
ReportReport
Posted on by

Hello Community!

I am wondering if there is a way to create a custom DateTime format when I am adding a row into a table. Listed below is a screenshot of the Add a row action and in it you can see that I have referenced certain outputs that from compose actions that reference different values from an excel spreadsheet. Within this spreadsheet there are dates and times for StartTime and EndTime (Ex: 8/24/2023 10:30:27 AM and 12:15:10 PM). Within the same row there is a TimeDifference column that calculates the difference between StartTime and EndTime. It gives its time difference in HH:mm:ss format.
When the row is added into the designated table, the numbers are converted from a HH:mm:ss (Ex: 03:55:22) format into a format I am unsure of. The screenshot of this new format is listed below. Is there a way to customize the DateTime format within the add a row action to ensure that the times from the rows referenced by the compose actions stay in a HH:mm:ss format?

Noah100_0-1692890621683.png

Noah100_2-1692891103136.png


Thank you,
Noah

 

Categories:
I have the same question (0)
  • trice602 Profile Picture
    15,886 Super User 2025 Season 2 on at

    Hi @Noah100 ,

     

    Please try updating the date format here:

     

    trice602_0-1692893132619.png

     

    If this was helpful, please mark as a solution.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard