Barcode scanner value search gallery

(0) Share

Report

Posted on by 00rebe

Hi Guys!

I'm having a little issue - I'm quite new to PowerApps

I'm trying to set my app so that when the barcode is scanned, the data is cross checked with a gallery, and if the data is matched, to navigate to another page in the app.. Here's the code I have (what I thought would work) in the barcode OnScan:

Set(varScan, BarcodeScanner.Value);

If (varScan in "Column1",Navigate(Screen2,none),Notify("No records match this barcode",Error));

If anyone could shed some light on how to do this I'd really appreciate it! 😁

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Set(varScan, BarcodeScanner.Value);

If (!IsBlank(LookUp(DataSource,"Column1" = varScan)),Navigate(Screen2,none),Notify("No records match this barcode",Error));

Try that

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
00rebe 24 on at

Like (0)

Report

@Nogueira1306 Thanks for your help, however unfortunately it hasn't worked, it's still coming back with the else value..

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Which value do you scan and which values "Collumn 1" has?

Was this reply helpful? Yes No
00rebe 24 on at

Like (0)

Report

@Nogueira1306 Scanned value is an equipment number & Column1 is also equipment number - I have everything in OneDrive excel
The purpose of the app is to check inventory - if the number matches the column navigate to a screen showing equipment details , otherwise just notify it's not found.
Been stuck on this part a while now!
When the barcode is scanned and the value is printed to a label it is the correct value - I just can't seem to get it crossed with the gallery

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Are you trying to compare text and number?

Was this reply helpful? Yes No
00rebe 24 on at

Like (0)

Report

@Nogueira1306 oh yes, I am, should varScan be changed? Or would you have another method? Thanks for your help!

Was this reply helpful? Yes No
Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Yes. If you want to compare text, on the field that is number write this:

Text(field)

With number

Value(field)

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-value

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
This_is_Asta 4 on at

Like (0)

Report

Hey there, I'm also new to power apps making same king app like you said but I'm stucked after inserting a bar code reader button, I need to populate other screen with respective details. Can you please help me with this

Was this reply helpful? Yes No