Answered

Barcode fill SharePoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm pretty sure its possible as I think I have seen someone do it before but cannot find it anywhere....

We are giving out a number of employees an iPad and want to record who is given which device. We have a sharepoint list with their name and a column to enter the iPad's serial number (12 random digits). To avoid human error when typing this long number I was wondering if it's possible for the barcode scanner to populate the field/column associated with that SharePoint item?

I know the barcode scanner can ADD a new item but this would mean they have to type the user's name in and then we woudlnt be able to see who has not recieved one yet etc.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous

We can update Sharepoint with the Barcode number. Ideally, Sharepoint should have a few columns

Employee-Person Field
Serial Number - Number or Text

Using PowerApps, You will be having a form to create or edit an existing item. The form should have Employee as Combo box and Text box for the Scanned Value

Set the Items property of person combo box to

Choices([@'Device Inventory'].Employee)

Set OnScan property of Barcode Scanner to

Set(DeviceSerialNumber, BarcodeScanner1.Value)

Set the Default property of Serial number text control to

If(IsBlank(Parent.Default), DeviceSerialNumber, Parent.Default)

And submit the form
SubmitForm(EditForm1)

Let me know I can help with more details

Thanks,
Stalin - Learn To Illuminate

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

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Please let us know if anything needs on your post. We can help with this.

Please mark the post as Solved If I have answered your question.
Please give it a Thumbs Up if you find the suggestion helpful

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No