Barcode scanner app export gallery to SharePoint list

(0) Share

Report

Posted on by Lift4life

Hello,

I have created the barcode scanner using the following:

Create a canvas app with the barcode scanner control (contains video) - Power Apps | Microsoft Docs

I would like to export the results from the gallery to a SharePoint list. I can easily capture the username and seem to be struggling to export the results from the gallery to the SharePoint list.

SharePoint list fields are:

Title: Barcode (hardcoded)

Username: Picks up User().FullName

Date: trying to get from gallery Thisitem.ScannedTime

Barcode: trying to get from gallery ThisItem.ScannedItem

Current scan button:

Collect(
colScannedItems,
{ScannedItem: BarcodeScanner1.Value, ScannedTime: Now()}
);

ForAll(Gallery3.AllItems;
Patch(BarcodeScannerApp;Defaults

Any help would be appreciated. Or should I just export the gallery items to text boxes and then patch to SharePoint list?

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Lift4life ,

Assuming the field names in your list are the same as the ones in your Collection

Patch( BarcodeScannerApp ForAll( colScannedItems As aPatch, { ScannedItem: aPatch.ScannedItem, ScannedTime: aPatch.ScannedTime } ) )

You could also Patch the gallery, but the collection is more direct.

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.

Visit my blog Practical Power Apps
Lift4life 15 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thank you for the details. I went a different direction and seems to be working a little better.

Now when you scan, it add the info to text boxes seen below

Scan button:

Collect(
colScannedItems,
{ScannedItem: BarcodeScanner1.Value, ScannedTime: Now()}
)

Text box 1:
Gallery3.Selected.ScannedItem
Textbox 2:
Gallery3.Selected.ScannedTime

Export to SharePoint button:
Patch(BarCodeScannerList,
{Username:User().FullName, Barcode:Barcoderesults.Text,Title:"Barcode Entry",Date:Dateandtimeresults})

The problem is the date and time gives an error when trying to import to SharePoint because I believe it's a formatting issue. Not to mention, date:dateandtimeresults needs an extension?

Thoughts on what I am missing?
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lift4life ,

I thought you wanted to Patch the Collection. Also where is Dateandtimeresults coming from ?
Lift4life 15 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Apologies I forgot to mention Textbox1 (top text box) = Barcoderesults Textbox2 (Bottom text box) = Dateandtimeresults.

Visually:

I moved away from the collection patching right away because it's better to have a review of the barcode before patching it to SharePoint list.
Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Lift4life ,

Assuming you have a valid date format in there, you will get a date with

DateValue(Barcoderesults.Text)

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.

Visit my blog Practical Power Apps
Verified answer

Lift4life 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, will give it a shot.