filter gallery from text part

[aaronraja]

I have this scenario: one barcode scanner button and gallery from sharepoint list. I want to filter this gallery only from part of the text of scanned barcode. How can i do this filter?

[mdevaney · Accepted solution]

@aaronraja 

You can use the MID function to extract a partial string from your barcode scanner control.

Filter(your_datasource_name, EAN = Mid(Barcode1.Value, 4, 13)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[aaronraja]

Thanks for the answer, but if the data is in other position inside the text? The code searched int the gallery is every time with 13 digits but the position in the barcode could by in other position.

[mdevaney]

@aaronraja
You must supply some examples to show what you mean

[aaronraja]

Yes.

Tha gallery has this filter: Filter(vTablaArticulos;Mid(BarcodeScanner1.Value;4;13)='Código Barras (EAN)')

The datasource is a SharePoint list that loads on a collection on start the app to search results fast when the user do a scan.

The first question is not filtering.

In test env the code scanned is 01084353548190081120020110testlot, and in the gallery i have one column named LCEAN witch content the value 8435354819008, but dont filter anything with the filter. I dont understand why.

When I scan the code, the data inside text, could by on the fourth position (with 13 digits every time) but if its in other position?

With that filter you give me the search text every need to bee on start position 4, but if is on 5 o 2, then cant search it. That situation its secundary.

[mdevaney]

@aaronraja 

You must give me examples of what the barcode could look like other than the format you supplied.

[aaronraja]

For example
01084353548190081120020110testlot
0102784353548190081120020110testlot
084353548190081120020110testlot
The part of barcode i need to compare is 8435345819008

[mdevaney · Accepted solution]

@aaronraja 
The barcode always appears the same number of digits from the right so we can use a combination of the LEFT + RIGHT functions here.

Filter(your_datasource_name, EAN = Left(Right(Barcode1.Value, 30), 13))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." 

[v-xida-msft]

Hi @aaronraja ,

Based on the issue that you mentioned, I think the 'in' operator could achieve your needs.

Please consider set the Items property of the Gallery to following:

Filter(
        vTablaArticulos;
       'Código Barras (EAN)' in BarcodeScanner1.Value
)

If you want to compare with the LCEAN column, please modify above formula as below:

Filter(
        vTablaArticulos;
        LCEAN in BarcodeScanner1.Value
)

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

Best regards,

[aaronraja]

Thanks to all for response, but the problem is that the gallery dont filter. I need to filter the fixed data on column of the gallery, that has 13 digits with the text value on the code scanned that could have variable quatity of digits, but has content de 13 digits of text i would to compare.

Dont get any thing, but the file exist.

With option of left and right dont filter too.

Thanks.