How to auto populate Dropdown based on Textbox Input

[Am4ree]

Hi Community,

basically I have list called PDItemlist. it has 2 Columns are FilmNumber (Single Text) and CylinderNumber (Single Text).

so I want to achieve, when I input FilmNumber (Text Input), the Clindernumber (Dropdown) will auto populated record from PDItemlist.

I have tried to input this code to dropdown items property but not work.

Any advise?

Thanks.

am4ree

[Gochix]

Hi,

you haven’t mentioned which column to display on the second dropdown. 

LookUp(PDItemlist, baancylindernumber =txtFilmnumber.text, cylindernumber)
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[Am4ree]

Hi @Gochix ,

I have tried your code but error prompted on the code. 

[Gochix]

Sorry I haven’t noticed that first check was incorrect in your code. This should work:

LookUp(PDItemlist, txtFilmnumber.text = FilmNumber, cylindernumber)

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

[Am4ree]

Hi @Gochix 

Not luck, I still got error prompted

[Am4ree]

Finally I can auto populated the dropdown but there is still something I need to achieve which is I only seen 1 record at the moment and should be 2 record based on filmnumber I have inserted.

below is sample

I found 2 record based on FilmNumber I had inserted but in the dropdown only show 1 record

[v-bofeng-msft · Accepted solution]

Hi @Am4ree ,

Cause lookup can only return the first record that meets the criteria. In order to get multiple records, please use "Filter" instead of "LookUp" .

Best Regards,

Bof

[Am4ree]

Thanks @v-bofeng-msft , Yes I should use filter instead of lookup.