Answered

How to filter Sharepoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey I would like to filter a Sharepoint List when an icon is clicked. The GalleryList should show the items where the selection column is like "abc".

Is there any solution?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,
I am assuming you have a text input box to put "abc" in and you want to click an icon to filter a list.
You don't actually need the icon.
I will call the text box SearchText, the source list in the gallery MyList and the field in this list MatchField
The Items property of the gallery should be
Filter( MyList, MatchField = SearchText.Text )
The gallery will be blank until a matching input is made.
If you want the field to match the start of the search text
Filter( MyList, StartsWith(MatchField, SearchText.Text) )
In this case, you can make the Default of SearchText "" (double quotes) and the gallery will show all items and then progressively show items starting with letters typed.

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

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

1. Insert A Textbox and a Gallery.
2. Place this formula on the item property of the Gallery:
Filter (YourtableName,ColumnName=Texbox.text)
3. Now when whatever you type in the textbox would be filtered

If it doesn't work, show your formula or describe your table columns

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to select columns as filter column dynamically via clicking the corresponding icon?

I have made a test on my side, please consider take a try with the following workaround:

Set the OnSelect property of the Column Selection Icon to following:

Set(SelectionColumn, "Column1")
Set(SelectionColumn, "Column2")
Set(SelectionColumn, "Column3")

...

...

Set the Items property of the Gallery to following:

Filter( 'Data Source', If( IsBlank(SelectionColumn), true, If( SelectionColumn = "Column1", StartsWith(Column1, "abc"), SelectionColumn = "Column2", StartsWith(Column2, "abc"), SelectionColumn = "Column3", StartsWith(Column3, "abc"), ... ... ) ) )

If you typed the "abc" within the TextSearchText box, please consider modify above formula as below:

Filter( 'Data Source', If( IsBlank(SelectionColumn), true, If( SelectionColumn = "Column1", StartsWith(Column1, TextSearchBox1.Text), SelectionColumn = "Column2", StartsWith(Column2, TextSearchBox1.Text), SelectionColumn = "Column3", StartsWith(Column3, TextSearchBox1.Text), ... ... ) ) )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No