Answered

power apps ———— If error in drop down

(0) Share

Report

Posted on by Tan_Jia_Ying

Hi,

I try to get five drop-down list is "ok" at the same time, and the result of the text label is "ok". But if one of the drop-down list is "Fail", then the result of the text label is "Fail".

The program I wrote did not produce errors, but the results it produced were not what I wanted. I've set the following:

Drop down: Items=

["OK","Fail"]

Text Label: Text =

IfError((Text(Dropdown6.SelectedText.Value)&&(Dropdown7.SelectedText.Value)&&(Dropdown8.SelectedText.Value)&&(Dropdown9.SelectedText.Value)&&(Dropdown10.SelectedText.Value)),"OK", "Fail")

Screenshot 2023-05-05 060857.png

Thanks for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

BCBuizer 22,720 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
Hi @Tan_Jia_Ying ,

The IfError function is not for your use case.

Instead use the in operator and a table to get compact conditions for the If function:

If( "Fail" in [ Dropdown6.Selected.Value, Dropdown7.Selected.Value, Dropdown8.Selected.Value, Dropdown9.Selected.Value, Dropdown10.Selected.Value ], "Fail", "OK" )

I also replaced .SelectedText with .Selected since .SelectedText is deprecated.

Was this reply helpful? Yes No
Tan_Jia_Ying 54 on at

Like (0)

Report
Copy link

Link copied!

This worked perfectly. Thank you.

Was this reply helpful? Yes No
Tan_Jia_Ying 54 on at

Like (0)

Report
Copy link

Link copied!

If I use Text Input instead of Dropdown, and the requirement is that the values are not far apart, then Text Label will display the value between the large value and the small value.

For example: Text Input1 value is 2.57
Text Input 2 value is 2.51
Text Input 3 value is 2.53

Text Label will show 2.53

Was this reply helpful? Yes No
BCBuizer 22,720 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Tan_Jia_Ying ,

Can you please open a new topic for this new question? Like that it is easier for members of the community to find answers solutions.

Please feel free to tag me for a guaranteed response.

Was this reply helpful? Yes No
Tan_Jia_Ying 54 on at

Like (0)

Report
Copy link

Link copied!

Got it.

Was this reply helpful? Yes No