QR/Barcode Scan to retrieve EXISTING sharepoint list details

[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.

[StalinPonnusamy · Accepted solution]

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)

[Koketso1]

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!

[JCapps]

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

[StalinPonnusamy]

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

[JCapps]

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

[StalinPonnusamy]

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