Announcements
Good day,
I would like to filter either by a collection or by a text input or by a scanned barcode. What would be the string for this?
My actual string is not working:
Filter( colArtikelUnterkategorie; Or(TextInput1.Text in Name) )
Thangs for you help.
Hi @John_Germany ,
Both would be
Filter( colArtikelUnterkategorie; Or( TextInput1.Text in Name, First(BarcodeReaderName.Barcodes).Value in Name ) )
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Thank you, @WarrenBelz. The string looks good, but there's still a problem. The system requires selecting the collection as a filter in the SharePoint list first, and then I can only search within that collection. However, I want the search to be performed using the text input and barcode across the entire SharePoint list without a prior filter, so the results can be displayed in the gallery.
@John_Germany ,
You can search the list directly (just replace the Collection with the List), however the in Filter is not Delegable, so you will be limited in the size of the list you can query to your (500-2,000) Data Row Limit.
@WarrenBelz Thank you for the help. The text search can certainly be pre-filtered with the collection, but the problem is that there are about 6000 records in the table from which the barcode reader needs to search.
Assuming the barcode exactly matches the name field
Filter( SPListName; Name = First(BarcodeReaderName.Barcodes).Value )
but you cannot do a "wildcard" search in 6,000 records from 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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 528
WarrenBelz 426 Most Valuable Professional
Valantis 306
