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 / Format hh:mm:ss from F...
Power Automate
Unanswered

Format hh:mm:ss from Flow to SP List

(0) ShareShare
ReportReport
Posted on by 5,323 Super User 2025 Season 2

I am trying to figure out how to eliminate the '12' from the output to the SharePoint List 'TestWaitTime' column.

The content should read 00:10:39, similar to what is shown in the SharePoint 'WaitTime', but without the date.

Update item action from Flow -

Phineas_3-1681763365208.png

TestWaitTime Expression -

     formatDateTime(items('Apply_to_each')?['WaitTime'],'hh:mm:ss')


Output of 'Update item'

Phineas_2-1681763306989.png


View in SharePoint List 
  DateTime                   Single-line Text

Phineas_0-1681763046358.png

Categories:
I have the same question (0)
  • Verified answer
    v-peijunz-msft Profile Picture
    Microsoft Employee on at

    Hi @Phineas 

     

    Please try the formula below:

    formatDateTime(items('Apply_to_each')?['WaitTime'],'00:mm:ss')

     

    Best regards,

    Sylvia

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard