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 / Filter choice field wi...
Power Apps
Answered

Filter choice field with multiple options

(0) ShareShare
ReportReport
Posted on by 8

Hi all,

 

I'm building an app what contains a gallery which displays information from a SharePoint list.
The list is named "Competenties".

This list has a couple of columns. In this case the columns "Status" and "Categorie". They're both columns
of type choice. The difference between them is that Status does not allow multiple selections where Categorie allows multiple selections. 

I'm displaying the categories in a seperate gallery inside main gallery.

 

The problem is in the filter that I'm building.

It has a textinput field where the user can search through the title of the records and two sets of radio buttons.
One for the Status and the other for the categorie.
I've managed to get the filter working properly for the textinput and the status, however when I try to extend the lines of codes with a similair line as the status radio buttons, my filter wont work.

 

Does anybody has an idea how I can get this filter to work so that I can filter Status and Categorie?

 

The code that works:

 

 

Filter(
 Competenties,
 StartsWith(
 Title,
 TextTitelComp.Text
 ) && (Status.Value = RadioStatus.Selected.Value || RadioStatus.Selected.Value = Blank())
)

 

 

 

This is the situation:

stefanhems_0-1667488183640.png

 

Categories:
  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @stefanhems ,

     

    I did the following test:

     

    Create a list where 'status' is a single-choice column and 'Categorie' is a multiple-choice column.

    vxiaochenmsft_0-1667552124829.png

     

     

    Displaying the categories in a seperate gallery inside main gallery.

    vxiaochenmsft_1-1667552124832.png

     

     

    Create a textinput box and two sets of radio buttons. One for the Status and the other for the categorie.

    vxiaochenmsft_2-1667552124834.png

     

     

    Use the following formula in gallery.

    Filter(Competenties,StartsWith(Title,TextTitelComp.Text)&&(Status.Value=RadioStatus.Selected.Value||RadioStatus.Selected.Value=Blank())&&RadioCategorie.Selected.Value in Categorie.Value||RadioCategorie.Selected.Value=Blank())

    vxiaochenmsft_3-1667552124841.png

     

     

    Status and Categorie can be filtered.

    vxiaochenmsft_4-1667552124844.png

    Best Regards,

    Wearsky

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard