Answered

if comparison with multiple condition

(0) Share

Report

Posted on by jaleefpk

i have SharePoint customized form using power app

in that one column value isdatacardvalue1= Value((DataCardValue34.Text) + (DataCardValue35.Text) + (DataCardValue30.Text)+ (DataCardValue18.Text)+(DataCardValue28.Text)+(DataCardValue20.Text)+(DataCardValue32.Text)+(DataCardValue42.Text)+(DataCardValue40.Text)+(DataCardValue38.Text))/10

and i have another column where i am trying to get value from data card 1 and depending on that setting a value

4.50 to 5.00	Outstanding
4.00 to 4.49	Very Strong
3.00 to 3.99	Strong
2.00 to 2.99	Adequate
1.00 to 1.99	Developmental

i tried t0 use If(Value(DataCardValue1.Text) >= 4.5 , "Outstanding", Value(DataCardValue1.Text) >= 4 , "Very Strong")

but its not working , please help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jaleefpk

Switch(ValueDataCardValue >4.5,"Outstanding", >=4.0 && < 4.5, "Very Strong", >=3 && <4.0, "Strong", >=2.0 && < 3.0, "Adequate", <2,"Developmental" )

Was this reply helpful? Yes No
jaleefpk 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp thanks for responding

but i am getting below error , am i missing anything

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@jaleefpk

Trying again, This formula in a text box

If( DataCardValue1.Text*1 >= 4.5, "Outstanding", DataCardValue1.Text*1 >= 4.0 && DataCardValue1.Text*1 < 4.5, "Very Strong", DataCardValue1.Text*1 >= 3 && DataCardValue1.Text*1 < 4.0, "Strong", DataCardValue1.Text*1 >= 2.0 && DataCardValue1.Text*1 < 3.0, "Adequate", DataCardValue1.Text*1 < 2, "Developmental" )

Was this reply helpful? Yes No