web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Multiple Fields Visibl...
Power Apps
Answered

Multiple Fields Visible after Multiple choices selected

(0) ShareShare
ReportReport
Posted on by 129

Hello, 

 

I have an app where there is a "check all that apply" option.

ElizabethK_0-1641848138879.png

 

The three options shown as selected above need to make three additional fields in the form visible - one for the user to provide what the correct client E-Mail is, one for the user to provide what the correct owner E-Mail is and one to provide what their "other" request is.

 

These are three columns in a SharePoint list and I have tried many different variations in the visible field for these three columns, but I cannot get all three to appear at once. I have tried with check boxes instead of a combo box as well. Here are the formulas I have tried:

ElizabethK_1-1641848715212.png

ElizabethK_3-1641848302083.png

 

 

ElizabethK_4-1641848311474.png

 

ElizabethK_0-1641848706030.png

 

 

None of these formulas have allowed all three single line of text columns to appear together. Any help would be so appreciated!

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,297 Super User 2024 Season 1 on at

    @ElizabethK 

    I assume these are all in individual datacards.  If so, then the Visible property you have is correct, a little redundant, but in general correct.

    What is the Items property of your Combobox?

  • ElizabethK Profile Picture
    129 on at

    @RandyHayes 

    Hello and thank you yet again for helping me! The items property is Choices([@'Drop Ticket Assistance Form'].'Check All that Apply') 

     

    The column for "check all that apply" is a sharepoint choices column. I added the combobox to the form, copied the items property, deleted the original drop down and then updated the errors with "combobox1". 

     

    Since I provided four different visible formulas that I tried to make these datacards appear in my original post, I am not positive which one in particular you meant should be correct, albeit redundant. In the past I have always had success using the following for the datacard's visible property - Visible: If(Combobox1.Selected.Value="Choice in List", true,false)

  • Verified answer
    RandyHayes Profile Picture
    76,297 Super User 2024 Season 1 on at

    @ElizabethK 

    The redundant part is the If...true, false.  Your condition statement is already returning true or false, so it is a bit redundant to do an if statement to return, for example, true, if something is true...it is already true.

    So, all you would need is Combobox1.Selected.Value = "Choice in List"   That will be either true or false already.

     

    However, you are actually doing multiple values.  So you need to determine the text of multiple selections (SelectedItems).

     

    So, this in the Visible is valid:  "Choice in List" in Combobox1.SelectedItems.Value

     

    Now, that said, you might want to consider a slightly different approach to this.  And that is, let your combobox Items determine what is shown.

     

    Example, if you set your Items property to:

    ForAll(Choices([@'Drop Ticket Assistance Form'].'Check All that Apply'),
     {Value: Value,
     Show: 
     Switch(Value,
     "Correct the client E-Mail", "FieldName1, FieldName2",
     "Correct the owner E-Mail", "FieldName1, FieldName3",
     "Other", "FieldName4"
     )
     }
    )

    You would change the FieldName values to be the actual field names of the datacards you want to show with that option.

     

    Then change the Visible property of your datacards to the following:

    Self.DataField in Concat(comboboxName.SelectedItems, Show)

     

    This is a little more "generic" for the visible property on the datacard, and it puts all the logic into the Items property instead of scattered across a lot of datacards.

    Much easier to maintain and change.

     

     

     

     

  • ElizabethK Profile Picture
    129 on at

    @RandyHayes  your responses are easy to follow and informative. I so appreciate you for helping me get more comfortable with PowerApps and meeting me where I am in terms of knowledge.

    For now I went with the solution of  using "Choice in List" in Combobox1.SelectedItems.Value I will look into working on the logic you provided for letting the combobox choose in the future.

     

    I appreciate the additional learning opportunity about my redundancy with true false statements. I am just that much better at serving the company I work for with another useful app, thanks to your help. I so appreciate you! 

  • RandyHayes Profile Picture
    76,297 Super User 2024 Season 1 on at

    @ElizabethK 

    Very good!

    Yes, I prefer the other option only because it puts all the logic in one place.  As you do more in PowerApps, you'll start to notice the value of that as everything interconnects and sometimes it is hard to "track back" to many places.

    Keep up the good work and Happy PowerApp'ing!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 740 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 342 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard