Barcode Scanner bringing data from SharePoint List

(0) Share

Report

Posted on by PJS-Data-Admin

141

Hello All,

I have an app for a new business process that I want to scan a barcode, once it scans that barcode it finds that barcode number in a SharePoint List column and brings specific data from that row in the SharePoint list back into the Power App. Then, after reviewing the information, it is then submitted and specific data goes into another SharePoint List - I am have an issue getting it to function correctly.

First, when the data comes over from the first SharePoint list and is submitted to the next one, it does not clear that data after it is then submitted to another list.

Second, when the data is submitted and we return to scanning page, it is displaying another rows data (this row is not reference at all so I do not know how that data comes in but it is the next row of data)

Could someone please assist?

OnScan: If(IsBlank(LookUp('Building List Austin', Barcode = BarcodeScanner1.Value, Barcode)), Patch('Building List Austin',LookUp('Building List Austin', Barcode = BarcodeScanner1.Value), {'Building_Name':BuildingName_value, 'Address': Address_value, 'Area Manager:': AreaManager_value}))

Text: LookUp('Building List Austin', Barcode = BarcodeScanner1.Value, 'Building Name')

OnSelect: Patch('Building Barcode Scans' , {Location: BarcodeScanner1.Value, WhoScanned: User().FullName, Time: Now()})

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @PJS-Data-Admin ,

I will fix the first bit - you are testing for a blank record and if this is the case trying to patch to it (which will not work as it does not exist) - do this to test for and patch to an existing record

With( { wCode: LookUp( 'Building List Austin', Barcode = BarcodeScanner1.Value ) }, Patch( 'Building List Austin', If( IsBlank(wCode.Barcode), Defaults('Building List Austin'), {Barcode:wCode.Barcode} ), { 'Building_Name':BuildingName_value, 'Address': Address_value, 'Area Manager:': AreaManager_value } ) )

and either patch the existing record (if it exists) or create a new one if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
PJS-Data-Admin 141 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Thank you for assisting!

I did have to add a .Text after each label to get this to work correctly. As this did work, I do not want to add any data to the original SharePoint List. Every barcode is linked to a specific row in that list. I simply need it to search that list for the row with that same scanned barcode and bring that data back into PowerApps for the user to see before submitting.

Thank you for all assistance that is provided!

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@PJS-Data-Admin ,

I cannot see you model, so assumed the references with _value at the end were Variables - if they are Text boxes, then yes - you need .Text on the end.

I was not sure what you needed fixed here and the first one was what I posted - for this one

LookUp( 'Building List Austin', Barcode = BarcodeScanner1.Value ).'Building Name'

will bring back the building name in the record matching the scanned value - is this what you are trying to do?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No