Search By Barcode Generated by sharepoint itself

(0) Share

Report

Posted on by COX

Hello,

I made a Sharepoint list For device inventory.

in powerapps i added a barcode scanner. if I scan a qr code with a TAG in it, I get the desired result. it only searches in the "TAG" column.

now I have indicated in sharepoint at settings that I want to use barcodes. it generated the barcode automatically. now I want to be able to scan on it and that it retrieves and edits data via column "Barcode value".

I can't get it right unfortunately.

if you need the formulas, I will forward them to you.

Thanks in advance,

Cox

Categories:

Building Power Apps

3.png

1.png

2.png

I have the same question (0)

All responses (6)

Answers (1)

COX 14 on at

Like (0)

Report

here i have foto's of my sharepoint list.

5.png

4.png

Was this reply helpful? Yes No
SebS 4,616 Moderator on at

Like (1)

Report

Hi @COX

Can you provide Code You use in the Item property of the gallery please?

To achieve this, you will create a filter that I assume You already have what right now, filtering only the first column you are looking for. You can add another filter with OR (||) operator that will match the Scanned code to Your Barcode Column.

Was this reply helpful? Yes No
COX 14 on at

Like (0)

Report
Hii SebS,

the code in Items:

Search('P1100 Asset Manager';TextSearchBox1.Text;"Title";"Tag")

I also think that's the problem. if I edit or clear it, my whole gallery is gone too.

6.png

Was this reply helpful? Yes No
Verified answer

SebS 4,616 Moderator on at

Like (1)

Report
@COX

I assume the Title is a column with Your barcode Numbers, not the Image of the Barcode and the tag is your Tag1 column from the screen if not You need to replace this with the right names of the Columns

Filter('P1100 Asset Manager', IsBlank(TextSearchBox1.Text) || IsEmpty(TextSearchBox1.Text) || StartsWith(Title, TextSearchBox1.Text) || StartsWith(Tag, TextSearchBox1.Text) )

Search is not Delegable means when you get more than 2000 records it stops working this approach should be better

Was this reply helpful? Yes No
COX 14 on at

Like (0)

Report
the "Title" column is hidden in my sharepoint list. it is not used, if I take it out my content disappears from the gallery. i was testing to change the name of the "Tag" column. this one is called "Tag" and now back. I do not use the image itself but only the column with the value of the barcode. in this case, numbers. thanks for the tip, going to test it.

sorry for my bad english, im translating with google.
original dutch.

Was this reply helpful? Yes No
COX 14 on at

Like (1)

Report
its working!

big thank you!!!

ilter('P1100 Asset Manager'; IsBlank(TextSearchBox1.Text) || IsEmpty(TextSearchBox1.Text) || StartsWith('Waarde van streepjescode'; TextSearchBox1.Text) || StartsWith(Tag; TextSearchBox1.Text) )

Was this reply helpful? Yes No