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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Drop-down box to filte...
Power Apps
Answered

Drop-down box to filter gallery from SharePoint choice column

(0) ShareShare
ReportReport
Posted on by 94

Hello,

 

I have a SharePoint list that has a choice field column with the ‘can select multiple’ option enabled.

 

I have an app with a gallery that displays the items in said SharePoint list. I would like to use a drop-down from aforementioned choice column to display all items  where one of the options are mentioned in the column.

 

So for example, if I select option 1, all entries on the SharePoint list with ‘option 1’ in the choice column are shown regardless of other choices mentioned. Option 1 could have 5 entries, 4 of which ‘Option 1’ is the only selection but 1 of the entries has ‘Option 1, ‘Option 2’ & ‘Option 3’ selected also which need to be displayed.

 

I currently have a search box and a toggle on the gallery which I would like to keep - it’s formula is:

 

Search(Filter(‘SHAREPOINTLIST’,!Toggle1.Value || Status.Value = “Open”),TextSearchBox1.Text,”Title”)

 

Any assistance would be greatly appreciated!

Categories:
I have the same question (0)
  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    Hi 

    Plz try this formula it may help you

     

    Search( Filter( 'SHAREPOINTLIST', !Toggle1.Value || Status.Value = "Open",
    Dropdown1.Selected.Value in ChoicesColumnName.Value ), TextSearchBox1.Text, "Title" )

     

    Thanks!

    Please click Accept as solution & Give a Thumps Up if my post helped you solve your issue.

  • Stephenp88 Profile Picture
    94 on at

    Hi Rajkumar,

     

    Thank you for your time. I’ve tried the suggested formula but unfortunately it doesn’t work. 

    it doesn’t like the ‘.value’ after Dropdown1.Selected

  • Stephenp88 Profile Picture
    94 on at

    @Amik 

    do you have any ideas on a solution?

  • Talha_Dar Profile Picture
    870 Super User 2024 Season 1 on at

    Hi @Stephenp88,

     

    Here is a formula that might help resolve the problem you are attempting to solve.

     

     

     

    Search(
     AddColumns(
     Filter(
     'YourListName',
     Toggle1.Value = false,
     TextSearchBox1.Text = Title
     ),
     "newNameForChoicesColumn",
     Concat(
     'currentNameOfChoicesColumn',
     Value,
     " "
     )
     ),
     Dropdown1.Selected.Value,
     "newNameForChoicesColumn"
     )

     

     

     

    Liked My Solution? Click on the Thumbs Up below.

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Ami K Profile Picture
    15,687 Super User 2024 Season 1 on at

    @Stephenp88 ,

     

    Assuming your dropdown control is a Combo Box:

     

     

    Search(
     Filter(
     'Your Data',
     !Toggle1.Value || 'Status' in YourComboBox.SelectedItems
     ),
     TextSearchBox1.Text,
     "Title"
    )

     

     

    @Rajkumar_404 - you had the right idea but there is no need for ".value".

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

  • Stephenp88 Profile Picture
    94 on at

    Hi Amik,

     

    Thanks for your help!

    unfortunately this didn’t work. Also, I’m having an issue where the field I wish to use isn’t displaying as an option within the combo box itself, which I think might be because it’s a choice type in SharePoint lists.

  • Talha_Dar Profile Picture
    870 Super User 2024 Season 1 on at

    Hi @Stephenp88,

     

    Are you currently using the following formula to render the choices column in your combo box? If not, I suggest giving it a try.

     

    Choices(Reference to your SharePoint Choices Column)

     

  • Stephenp88 Profile Picture
    94 on at

    Hi Talha,

     

    sorry I’m still learning PowerApps, where would I put that formula?

  • Talha_Dar Profile Picture
    870 Super User 2024 Season 1 on at

    on the items property of your Combo Box

  • Stephenp88 Profile Picture
    94 on at

    When I add that formula I get the below error:

    “The function ‘Choices’ has some invalid arguments”

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard