Power Platform Community Forum Thread Details

Hi folks,

I am trying to create a simple barcode scanner app for my team to use. The app worked file but it cannot send the barcode data to the Excel file. The Excel file is connected to my app via PowerApps Connector. My app interface:

Screenshot_20220110-170629_Power Apps.jpg

My "Scan Barcode" button has the following action syntax:

Set(varScan, BarcodeScanner1.Value); Set(varTimeScan, Now()); Collect(scanneditems, Table({Scan: varScan, TimeScanned: varTimeScan}))

I have used the following COLLECT syntax to place the data within the 'scanneditems' collection in my PowerApps:

Collect(scanneditems, {BarcodeValue: BarcodeValueLabel.Text, TimeScan: TimeScanValueLabel.Text})

For my button "Upload to Excel", I have used the following:

ForAll(
scanneditems,
Patch( Table1, Defaults(Table1),
{BarcodeValue: varScan, TimeScanned: varTimeScan})

)

However, the data sent across to Table 1 (which is inside an Excel in OneDrive) is gibberish. Instead of the above 4 sets of barcodes, my Table 1 is filled with gibberish in the 3rd unknown column as shown: