Announcements
How to filter gallery with more than one value mentioned in textbox using comma.
I need to filter gallery using two or more values separated by comma in textinput
Hi @AishwaryaRane11
Try this in your gallery Items property:
Filter(YourDataSource,ColumnName in Split(TextInput1.Text,",").Result)
Note: If you put spaces between the commas in your textbox, this formula will not work properly.
Hi @Adrian_Celis , Is there any other way to do it without delegation warning? I have set the delegation limit to 2000 but the records in my SharePoint list are more than 30,000
Hi @AishwaryaRane11 Sorry, the 'in' operator is non-delegable. If you can filter it more to trim it down before you do your filtering in the textbox, then that can help.
Filter( Filter(YourDataSource,ColumnName="More Filtering", ColumnName in Split(TextInput1.Text,",").Result )
Otherwise, there is no other function that will do the same that is delegable.
Hi @Adrian_Celis is it possible without using in or exactin?
@AishwaryaRane11
One workaround is instead of a textbox where the user can place several values separated by commas, why not place for example 3 textboxes (one for each value) then you can use your filter formula like:
Filter(YourDataSource,ColumnName = Textbox1.Text Or ColumnName = Textbox2.Text Or ColumnName = Textbox3.Text)
The only downside is that you can only filter up to how many textboxes you provide.
@Adrian_Celis
That would have helped but my requirement is with comma separated values
@AishwaryaRane11 Sorry, as far as I know, the in / exactin method is the only way I know to get past your requirement. Hope others can also suggest another way.
Thanks for your help @Adrian_Celis .Really appreciate the efforts🙂
But what if you need to check for a substring of the text input anywhere in the column, not for a substring of the column in the text input?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
