Answered

How to auto populate Dropdown based on Textbox Input

(0) Share

Report

Posted on by CU22070439-0

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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Gochix 1,937 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
CU22070439-0 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gochix ,

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

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
CU22070439-0 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gochix

Not luck, I still got error prompted

Was this reply helpful? Yes No
CU22070439-0 40 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CU22070439-0 40 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No