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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Display the format hh:...
Power Apps
Unanswered

Display the format hh:mm from dataype duration

(0) ShareShare
ReportReport
Posted on by 171

I want to enter hours in an input field in my PowerApp. The hours are recorded in a dataverse table with the name activity recording. The data type is duration and stores whole numbers. Now I want to be able to enter, for example, 2:15 in the input. I do not want to change the data type.
How can I enter the format hh:mm, e.g. 2:15, in an input field, save this somehow in the dataverse table and have it output again in the format hh:mm?

 

Categories:
  • WarrenBelz Profile Picture
    156,969 Most Valuable Professional on at

    Hi @alt88 ,

    Much easier to store as Text in your data source, but to convert to a number (of minutes)

    With(
     {
     wTime: 
     Split(
     YourTextValue,
     ":"
     )
     },
     Value(First(wTime).Value) * 60 + Value(Last(wTime).Value)
    )

    To get it back

    RoundDown(
     YourNumberField / 60,
     0
    ) & ":" & 
    Mod(
     YourNumberField,
     60
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

  • alt88 Profile Picture
    171 on at

    The error message i get is:

    This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value. This is the shortest circular reference: 'inpGalleryMo'. 'Default' ->

    'inpGalleryMo'. 'Default'

     

  • WarrenBelz Profile Picture
    156,969 Most Valuable Professional on at

    @alt88 ,

    The second item is the Default, The first is the Update of the data card (or the Patch content if you are updating that way).

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 189 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 139

Last 30 days Overall leaderboard