cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AaronHB
Level: Powered On

Using a barcode scanner to change a singular column in list

Hi,

 

How would you make a barcode scanner look at a list and match what it has just scanned so that it is able to change a column.

 

What I am trying to do is make it so that I can scan a barcode, and one of the columns for that barcode would be changed without a new entry being created in the sharepoint list.

msedge_2019-10-17_10-53-14.png

The red box is the one I am trying to change.

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Using a barcode scanner to change a singular column in list

Hi @AaronHB ,

Which value you want to scan through the Barcode Scanner control? Is it the Barcode column value in your SP list?

Could you please share a bit more about the 'In use' column in your SP list? Is it a Text type column or a Choice type column?

 

Based on the needs that you mentioned, I think the OnScan property of Barcode scanner control and the Patch function could achieve your needs. I have made a test on my side, please take a try with the following workaround:
Set the OnScan property of the Barcode Scanner control to following:

1. If the 'In use' column is a Text type column:

Patch(
'YourSPList',
LookUp('YourSPList', Barcode = BarcodeScanner1.Value),
{
'In use': "Specific Text Value"
}
)

2. If the  'In use' column is a Yes/No type column:

Patch(
      'YourSPList', 
       LookUp('YourSPList', Barcode = BarcodeScanner1.Value), 
       {
         'In use': true
       }
)

3. If the 'In use' column is a Choice type column:

Patch(
      'YourSPList', 
       LookUp('YourSPList', Barcode = BarcodeScanner1.Value), 
       {
         'In use': {
Value: "Specific Choice Option"
} } )

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Using a barcode scanner to change a singular column in list

Hi @AaronHB ,

Which value you want to scan through the Barcode Scanner control? Is it the Barcode column value in your SP list?

Could you please share a bit more about the 'In use' column in your SP list? Is it a Text type column or a Choice type column?

 

Based on the needs that you mentioned, I think the OnScan property of Barcode scanner control and the Patch function could achieve your needs. I have made a test on my side, please take a try with the following workaround:
Set the OnScan property of the Barcode Scanner control to following:

1. If the 'In use' column is a Text type column:

Patch(
'YourSPList',
LookUp('YourSPList', Barcode = BarcodeScanner1.Value),
{
'In use': "Specific Text Value"
}
)

2. If the  'In use' column is a Yes/No type column:

Patch(
      'YourSPList', 
       LookUp('YourSPList', Barcode = BarcodeScanner1.Value), 
       {
         'In use': true
       }
)

3. If the 'In use' column is a Choice type column:

Patch(
      'YourSPList', 
       LookUp('YourSPList', Barcode = BarcodeScanner1.Value), 
       {
         'In use': {
Value: "Specific Choice Option"
} } )

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 164 members 5,382 guests
Please welcome our newest community members: