Convert a String into a Num

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm new into this.

I have the following formula on a Color property of a Label:

<If(Price.Text>= 1000, Red , Gray)>

<Price.Text> returns a String, so logically it doesn't evaluate.

Obvious questions is, how to convert that into a Number.

I tried <Price.Value> but i believe it doesn't work with labels.

Many thanks.

Categories:

Building Power Apps

All responses (28)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Use this code instead:

If(Value(Price.Text)>= 1000, Red , Gray)

---
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."
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous
If(Value(Price.Text)>=1000,Red,Grey)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It worked, but I´'m not getting the expected result. hum
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

What result are you expecting?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

To get the pricing on the label, above 1000, to be Red, else Gray (this is inside a gallery)
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Put my code in the Color property of the label to get the desired result.

---
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."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I did that. It doesn't. Weird!
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Can you try changing the Format property of TextInput for Price to this code which will only allow a number input?

Format.Number

Then please erase and retype the number in the text box.

---
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."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I found out the problem.
The Text property was:
ThisItem.Price & "€"
Erasing the € enabled the color. However I´m left without a currency after the price
mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Change the Text property of the label to this code to achieve the result with € at the end

Price.Text & “€“

---
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."