QR/Barcode Scan to retrieve EXISTING sharepoint list details

(0) Share

Report

Posted on by Koketso1

Hi POWERful people!😊

I have a laptop inventory app that manages inventory in a sharepoint list.

1 - My app has a scan button (scan new) that scans barcodes and writes them to a sharepoint list.

2 - It has a second scan button (Scan&go), that is supposed to bring already existing entries on the sharepoint list.

so if John has a new machine, I scan his barcode (scan new) and it gets added to the sharepoint list. So when I click on the scan&go button, its supposed to bring up the detail screen with Johns details on the sharepoint list with the code below :

Launch(BarcodeScanner2.Value);Navigate(DetailScreen1,ScreenTransition.Fade, { scanvalue: BarcodeScanner2.Value } ).

The PROBLEM is, if I just viewed Johns machine details now and I click on scan&go to scan Davids machine, it brings up Johns machines details.. so the scan&go button brings up the detail screen of whatever the last viewed entry was.

please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @Koketso1

No Launch command is needed if you are within the same application

Set the OnScan property to

Set(SelectedId,BarcodeScanner1.Value);Navigate(DetailScreen1,ScreenTransition.Fade)

On Browse Screen

Set(SelectedId,BrowseGallery1.Selected.ColumnName);

On DetailScreen use Variable "NewScanValue" to filter or get data from Datasource

Form Item Property

LookUp(DataSource,ColumnName=SelectedId)

Was this reply helpful? Yes No
Koketso1 27 on at

Like (0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy
This works PERFECTLY and precise!
Thank you very much for going above and beyond to resolve this issue with me.
Much appreciated and kudos to you!

Was this reply helpful? Yes No
JCapps 4 on at

Like (0)

Report
Copy link

Link copied!

You sir are a saint and a scholar....i've been trying to get this working for a week now and i've tried everything i could think of and every other offered solution out there. To clarify the on browse screen instructions above refer to the gallery individual record onselect control. That was not super clear but i eventually put two and two together. THANK YOU

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @JCapps

I'm glad the response was helpful. Please reach out to us if any issues or questions.

Thanks, Stalin (Microsoft MVP)
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos

Was this reply helpful? Yes No
JCapps 4 on at

Like (0)

Report
Copy link

Link copied!

Well I thought I had resolved this but I was mistaken.

My search function looks for a serial # and I had assumed that the barcodes in use had been coded for the serial#’s but in fact they are separate Barcode ID.

so now I need to figure out how to leave my gallery search to work with serial numbers but my barcode scanner to target the barcode ID

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @JCapps

Sorry for the delay. Somehow I missed this from my radar. My apologies.

Here is the solution to get an item based on Serial Number or Barcode.

Set the OnScan property of the Barcode Scanner to

Set(ScannedBarcode, BarcodeScanner1.Value); Set(SelectedSerialNumber, Blank()); Navigate(DetailScreen1,ScreenTransition.Fade)

Set the OnSelect property of the Gallery to

Set(ScannedBarcode,Blank()); Set(SelectedSerialNumber,BrowseGallery1.Selected.SerialNumber); Navigate(DetailScreen1,ScreenTransition.None)

On the Detail Screen, Set the Item property of the Form to

LookUp( SPList, BarcodeColumnName = ScannedBarcode || SerialNumberColumnName = SelectedSerialNumber )

Sample

Thanks, Stalin (Microsoft MVP)
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos

Was this reply helpful? Yes No