Unanswered

Starts with formula

(0) Share

Report

Posted on by Dannyw10

Need help with a formula to help put a default into a drop-down by the first few numbers of a text input. We have hundreds of thousands of barcodes but only a few separate products so having a list to lookup each individual barcode is a lot of work.

1 product starts with for example 2151106

Another product starts with 2171106

I would like it so if someone inputs a barcode into a text input like 21511061239876 it will automatically put Product A into drop-down by starting with 2151106 or if they put 21711065467890 is will put Product B because it started with 2171106.

Hopefully this makes sense. As I can not get any kind of formula to work correctly. Thanks

Hopefully this is poss

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Gochix 1,935 Moderator on at

Like (0)

Report
In your dropdown Item option use:
Filter(NameOfYourCollection, StartsWith(YourBarcodeColum, TextInput.Text))
Then select Advanced options and set the DATA value to the product column.

Was this reply helpful? Yes No
Dannyw10 10 on at

Like (0)

Report

Thanks for your reply. The barcode they scan into the text input is scanned by a Bluetooth scanner so when the numbers go past the first 7 numbers that define that Product it doesn't filter anything anymore. If Product A is 217110698765 i can manually type 2171106 and it filters correctly by filtering Product A but soon as anymore numbers are added after the 6 it produces nothing. If possible I would like it so any products that start with 2171106 it will always assign Product A even if there are numbers after it.

Was this reply helpful? Yes No
Verified answer

Gochix 1,935 Moderator on at

Like (0)

Report
Ah I see. Then you can do something like:

If(Left(TextInput.Text,7)="2151106",{Value:"Product A"},{Value:"Product B"})

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
Dannyw10 10 on at

Like (0)

Report

Thanks so much. So simple but as an amateur this was not something I'd have come up with. Would buy you a drink if I could!

Was this reply helpful? Yes No