Unanswered

Display the format hh:mm from dataype duration

(0) Share

Report

Posted on by alt88

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
alt88 171 on at

Like (0)

Report

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'

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@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).

Was this reply helpful? Yes No