cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Issue trying to filter a barcode list

Dear all,

 

I created a little app to scan barcodes connected to a sharepoint list with generated barecodes. The scanner works well, but I am unable to filter my gallery with the code written in a TextInput. I tried multiple formulas using Filter or Search but I reached my limitations. The number of the barcode is written by the scanner, but the filter's function won't work.

 

Here is some of my attemps ;

SortByColumns(Search(Inventaire,Value(TextInput1.Text),"OData__dlc_BarcodeValue"),"Name")

SortByColumns(Search(Inventaire,TextInput1.Text,"OData__dlc_BarcodeValue"),"Name")

Filter(Inventaire,TextInput1.Text="OData__dlc_BarcodeValue")

 

Where ;

Database name : Inventaire

TextInput name : TextInput1

Barecode column name : "OData__dlc_BarcodeValue"

The scanner name is : monscanner

 

barcode scanner app.png

 

Thank you already for any help,

 

I wish you a nice day,

1 REPLY 1
JacksonPollock7
New Member

I think you need to filter using columns in SharePoint which is the data source of the gallery and the textinput is not part of this data source. This is the reason why gallery won't filter using your textinput control.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,654)