Add unit after number

(0) Share

Report

Posted on by chhe

140

Hello,

I have a calculated textfield. I want to add a unit behind the result. This is my code:

Text(541;"[$-de-DE]##%")

The little h is in Germany the shorten for "hours". If I replace the h through % everything works... But I want to place a "h" there. How is that possible?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@chhe

Maybe you can simply add an 'h' after as text like this.

Text(555,14);"[$-de-DE]##")&"h"

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
chhe 140 on at

Like (0)

Report
Copy link

Link copied!

Hi, this does not work. There appears an error.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@chhe

Please share the error.

Was this reply helpful? Yes No
chhe 140 on at

Like (0)

Report
Copy link

Link copied!

Unexpected signs. In the formula, characters are not used as expected.
For example, the character "\" is not expected after a number: "32\". A space ("32 ") is expected, indicating that only the number 32 is meant, or another number (e.g. "323").

Was this reply helpful? Yes No
timl 36,715 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@chhe

I suspect this is what @mdevaney meant. This should hopefully fix the error that you're seeing.

Text(555;"[$-de-DE]##") & "h"

Was this reply helpful? Yes No
ganeshsanap 1,555 on at

Like (1)

Report
Copy link

Link copied!
@chhe , Which unit you want exactly? Do you want to concatenate "h" to "541"? If Yes, try to use below:

Text(541,"[$-de-DE]##")&"h"
Note: If comma(,) does not work for you then use semicolon(;) instead of it.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@chhe

Yes, the answer of @timl is what I meant. You should accept his response as the solution.

Was this reply helpful? Yes No
chhe 140 on at

Like (0)

Report
Copy link

Link copied!

Hello,

the expression from @timl worked for the first step. But then I can't calculate with this TextInput. Another TextInput multiplies this TextInput with the value from another TextInput. This doesn't work then. Is there a solution to add a "h" and keep the fields as number fields?

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@chhe
Please start a new thread. Include a screenshot of your app to show what is required.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @chhe ,

Do you want to append a 'h' char after a number value, and keep the field as a number field?

Based on the needs that you mentioned, I afraid that there is no way to achieve your needs. I agree with @timl 's solution almost. If you want to append a 'h' char after a number value, please use the following formula:

Text(514; "[$-de-DE] ##") & "h"

If you want to multiply this TextInput value with the value from another TextInput, please take a try with the following formula:

Value(Substitute(TextInput1.Text, "h", "")) * Value(TextInput2.Text)

Note: The TextInput1 represents the Text Input box, where you want to add 'h' unit. The TextInput2 represents another Text Input box, whose value you want to multiply with the TextInput1 value.

Best regards,

Was this reply helpful? Yes No