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

All responses (6)

Answers (1)

Sort by

COX 14 on at

Like
a
(0)

Report
Copy link

Link copied!

here i have foto's of my sharepoint list.
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

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.
COX 14 on at

Like
a
(0)

Report
Copy link

Link copied!
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.
Verified answer

SebS 4,867 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
@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
COX 14 on at

Like
a
(0)

Report
Copy link

Link copied!
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.
COX 14 on at

Like
a
(1)

Report
Copy link

Link copied!
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) )