Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Visible Formula Not Working

Posted on by 26

Hi,

 

I have a drop down menu with 5 different options.  I also have a 3 different sub options fields to be displayed depending the value selected.

 

For the 3 different sub options, I used these formulas below. The user can select multiple values from the drop down menu and I want to show the sub options based on the value selected. Theoretically all 3 sub options should show up if the specific list items are selected.  The issue I am running into is that only one sub option is showing up even though I selected all the different options.

 

If(DataCardValue4.Selected.Value = "Apple", true, false)

If(DataCardValue4.Selected.Value = "Orange", true, false)

If(DataCardValue4.Selected.Value = "Cherry", true, false)

 

  • LaurensM Profile Picture
    LaurensM 12,525 on at
    Re: Visible Formula Not Working

    My apologies @Poweruser811, it seems that I did not capitalize the I. It should be SelectedItems instead of Selecteditems.

     

    I have adjusted the code in my previous comment accordingly.

  • Poweruser811 Profile Picture
    Poweruser811 26 on at
    Re: Visible Formula Not Working

    Its strange, I reentered it again and it worked. Thank you so much!

  • Poweruser811 Profile Picture
    Poweruser811 26 on at
    Re: Visible Formula Not Working

    Its not taking the formula, did I miss something? 

    Poweruser811_0-1715379554953.png

     

  • Verified answer
    LaurensM Profile Picture
    LaurensM 12,525 on at
    Re: Visible Formula Not Working

    Hi @Poweruser811,

     

    .Selected.Value will only return the last selection (in the context of multi-select comboboxes). In order to check whether your value is present within one of the selected values, use the following structure instead:

     

    //Sub option 1 visible property
    "Apple" in DataCardValue4.SelectedItems.Value
    
    //Sub option 2 visible property
    "Orange" in DataCardValue4.SelectedItems.Value
    
    //Sub option 3 visible property
    "Cherry" in DataCardValue4.SelectedItems.Value

     


    If this solves your question, would you be so kind as to accept it as a solution✔️

    If you liked my solution, please give it a thumbs up👍

     

    Connect with me: LinkedIn | Blog

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard