Answered

Visibility based on dropdown selection using cascade dropdowns from sharepoint list source

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have a dropdown that receives its values from a sharepoint list, one of the values is Opportunity to Improve

I have several boxes that I want to be hidden unless Opportunity to Improve is selected from the above dropdown box. I have set the code on the visibility to the below but i'm getting the red X, can you advise where i'm going wrong please?

If(
 'Dropdown-Classification'.Selected.Value = "Opportunity to Improve",
 true,
 false
)

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
If you are getting a red X then you should also be getting an error message. What is the actual error message?

FYI: You can shorten your formula by just using the example below in Visible property.

'Dropdown-Classification'.Selected.Value = "Opportunity to Improve"

Was this reply helpful? Yes No
Dave-ITMan on at

Like (0)

Report
Copy link

Link copied!

Hi @Jeff_Thorpe ,

Thanks for advising of the shortening, I will keep that in mind in future! The error message that is coming up is:
Incompatible types for comparison. These types can’t be compared: Error, Text.

Many thanks

Was this reply helpful? Yes No
Verified answer

Dave-ITMan on at

Like (0)

Report
Copy link

Link copied!
I have managed to work this out, the text at the end needed changing slightly so it should be:

If( 'Dropdown-Classification'.Selected.Result = "Opportunity to Improve", true, false )

Was this reply helpful? Yes No