Answered

I am trying to have make a label that will display based on a value that is calculated from a SharePoint column.

(0) Share

Report

Posted on by OKCFD607

Specifically, if the "score" is 0-5 I would like a label appear that says "Low-Risk." If the score is 6-10, I would like the label to say "Moderate-Risk", and finally 11 or higher to display "High-Risk."

Risk Scale Pic.JPG

The text function value for the score is Value(Parent.Default). The data type is number.

The number, or "score" is derived from a calculated column from my data source in SharePoint.

When I try set up a label to display based on the value, this is what I see: Score Val.JPG

On DisplayMode:

I have attempted to use If(ScoreVal<=6,true), If(ScoreVal=0,DisplayMode.View). I have tried otheres

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

GarethPrisk 2,828 on at

Like
a
(0)

Report
Copy link

Link copied!
ScoreVal is the reference to the control itself. You need to then reference a property of the control.
Such as ScoreVal.Text if it's a label control
If you need to turn it into a numeric value, then wrap it in a Value function
Value ( ScoreVal.Text )

Is this part of a Form? Is it a standalone control?
OKCFD607 7 on at

Like
a
(0)

Report
Copy link

Link copied!

It is on a Display form on a canvas app.
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Try On the Label Text:
If(Value(DataCardValue22_1.Text)<=5,"Low Risk",
If(Value(DataCardValue22_1.Text)>5&&
Value(DataCardValue22_1.Text)<11,"Medium Risk",
If(Value(DataCardValue22_1.Text)>=11,"High Risk"
)))

Where DataCardValue22_1 is the Textbox the holds the Figure
------------

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.
OKCFD607 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank YOU!!!!

Worked as intended.