cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Glorfindel
Frequent Visitor

BarcodeScanner

How should I set the scan in order to validate into my DB if a value exists, in case that the value is not available give the option to save a new record.

 

foe example I have a DB imported from Excel which contains serialnumber I want to scan a Serial  number and if the value exists in the DB shows me some details from that value.

 

Glorfindel_0-1617664070030.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Glorfindel ,

You did not answer the original question - what type of field is SerialNumber?

It is clearly not Text as BarcodeScanner2.Value will produce Text and the error is that it is not matching the field SerialNumber.

 

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.

View solution in original post

14 REPLIES 14
WarrenBelz
Super User
Super User

Hi @Glorfindel ,

Assuming the barcode value is the SerialNumber - the Item of your Form would be

LookUp(
   YourTableName,
   SerialNumber=BarCodeScannerName.Value
)

 

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.

Glorfindel
Frequent Visitor

Show an error 

 

Glorfindel_0-1617746637283.png

 

@Glorfindel ,

I am sorry, but you will have to translate that.

Glorfindel
Frequent Visitor

Of course,

 

Incidence

I was expecting a text value

 

the propertie of this control expect a text values.

the rule create record values, which is incompatible 

@Glorfindel ,

What is the code (please post in Text) you used when you got this and what type of field is the field I referred to as Serial No?

Glorfindel
Frequent Visitor

Glorfindel_0-1617899395656.png

 

@Glorfindel ,

As asked before, what type of field is SerialNumber?

Glorfindel
Frequent Visitor

Text

@Glorfindel ,

Are you sure it is a Single Line of Text? The error is saying it is not Text.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,085)