Unanswered

Filter Doc Library by Multiple Choices

(0) Share

Report

Posted on by EMA03356

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?

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

Tried this out and getting the following error:

Was this reply helpful? Yes No