Canvas App -Search

[AVTS]

I am having inventory scanning application with barcode option .

My table follows

I am having

Barcode scanner  (Counter 1)

Input Text (Counter2)

DropDown(Counter3)

Exisiting Setup,

Input Text (Counter2) and DropDown(Counter3) Changes automatically based on the Barcode Scanning.

Example :  Input Text (Counter2) is 5449000066947 is then dropdown change to 10121900.

Requirement :

I need to activitied the search in the Input Text (Counter2).

Example : If i enter 250 ml then dropdown box should display follows

10153701

10121900

Exisiting formulas.

Barcode scanner  (Counter 1)

Onscan: Collect(MaterialMasters,{TextInput4:BarcodeScanner1.Value,Dropdown1:BarcodeScanner1.Value})

-------------------------------

Input Text (Counter2)

Default :BarcodeScanner1.Value

------------------------------------

DropDown(Counter3)

Items: If(IsBlank(TextInput4.Text),MaterialMasters,Filter(MaterialMasters,'full cases'=(TextInput4.Text)||'single cases'=(TextInput4.Text) || mm=(TextInput4.Text) || Materialdesc=(TextInput4.Text)))

-------------------------------------------------

[v-bofeng-msft · Accepted solution]

Hi @AVTS :

Please try this formula:

If(
    IsBlank(TextInput4.Text),
    MaterialMasters,
    Search(
        MaterialMasters,
        TextInput4.Text,
        "full cases",
        "single cases",
        "mm",
        "Materialdesc"
    )
)

Best Regards,

Bof

[AVTS]

Many Thanks Its worked