Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

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

Posted on by

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! 

  • Verified answer
    Dave-ITMan Profile Picture
    Dave-ITMan on at
    Re: Visibility based on dropdown selection using cascade dropdowns from sharepoint list source

    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
    )
  • Dave-ITMan Profile Picture
    Dave-ITMan on at
    Re: Visibility based on dropdown selection using cascade dropdowns from sharepoint list source

    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

  • Jeff_Thorpe Profile Picture
    Jeff_Thorpe 6,089 on at
    Re: Visibility based on dropdown selection using cascade dropdowns from sharepoint list source

    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"

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard