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 Doc Library by ...
Power Apps
Unanswered

Filter Doc Library by Multiple Choices

(0) ShareShare
ReportReport
Posted on by 221

I have choice columns that I would like to use to filter through a document library as shown below. I also have a search bar that I would like to maintain as well. How can I do this? 

 

EMA03356_0-1719492175371.png

 

If(Searchbox1.Text="",LastN('Training Videos',1000),Search('Training Videos',Searchbox1.Text,Concat))


Categories:
I have the same question (0)
  • anandm08 Profile Picture
    1,936 Super User 2024 Season 2 on at

    hi @EMA03356 ,

    try this:

     

    If(
     IsBlank(Searchbox1.Text),
     Filter(
     'Training Videos',
     YourChoiceColumnName.Value = SelectedChoiceValue
     ),
     Filter(
     'Training Videos',
     YourChoiceColumnName.Value = SelectedChoiceValue && 
     Search('Training Videos', Searchbox1.Text, Concat)
     )
    )

     

    Replace YourChoiceColumnName with the actual name of your choice column in SharePoint. SelectedChoiceValue should be the variable or property where you store the selected value from your choice column filter.

  • EMA03356 Profile Picture
    221 on at

    Tried this out and getting the following error: 

    EMA03356_0-1720632101282.pngEMA03356_1-1720632119348.png

     

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
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard