Convert control .value to string

(0) Share

Report

Posted on by knyklu

151

Hi,

I need to check if in scanned barcode is sign ';'.

Function Find looks for in string, so how to convert the control value to text.

Find(";"; (Text(ControlName.Barcodes.Value))) - 'Text' function has incorect arguments.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @knyklu

Try this formula

Find(";", Text(ControlName.Barcodes.Value))

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Verified answer

CarlosFigueira on at

Like (1)

Report
The barcode reader control can read multiple barcodes in a single session, so the Barcodes property is a table, not a string which you can use in the Find function. If you know that you only have one scanned barcode, you can use the First function to retrieve that from the table:

Find(";"; First(ControlName.Barcodes).Value)

If you want to retrieve all scanned barcodes with a ';' in it, then you can use something like

Filter(ControlName.Barcodes; ";" in Value) // this is still a table

Hope this helps!

Was this reply helpful? Yes No
knyklu 151 on at

Like (0)

Report

Where is the difference?

Was this reply helpful? Yes No
Verified answer

CarlosFigueira on at

Like (0)

Report
In your code, the call to

Text(ControlName.Barcodes.Value)

is invalid. The Text function can be used to convert scalar values (such as numbers / dates / times) to text/string. But ControlName.Barcodes.Value is not a scalar, it is a table with the values of all barcodes that were scanned by the control - and the Text function does not work with tables, only with scalar values.

By taking the first element of the ControlName.Barcodes table, we have a single record, and when we use .Value we are extracting the text/string from that record. That value can be used in the Find function to search for ';'.

Was this reply helpful? Yes No
knyklu 151 on at

Like (0)

Report

Sorry @CarlosFigueira, the question was for @Rajkumar_404 .

Concerning Your post... As for your post... I'm ashamed to admit it, but I got var First(Laser.Barcodes).Value to get the data from barcode and pass them to next operation, but there I just put scLaser.Barcodes.Value.
Sorry for problem.

Was this reply helpful? Yes No