cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
caballar
Level: Powered On

How to Generate a List of Choices for a Text Box

Hi,

 

I've got three screens connected to three different databases:

Screen 1 connected to dbo.Students

Screen 2 connected to dbo.CourseTitles

Screen 3 connected to dbo.Enrollments

 

I have a form for Screen 3 with fields for Student and Course Title. I want to have a text box in this form where I can begin typing a student's name from dbo.Students and get a list of options to choose from. Example: type "Dav" and get a list of David, Davis, etc. Then choose the student and the course title and submit the form.

 

If I use a Drop Down box, I don't think I would be able to filter by typing the first few letters of the name to find the student I want.

 

How can I accomplish this?

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to Generate a List of Choices for a Text Box

Hi @caballar

 

The control that you're looking for is the Combo box control. Unlike the drop down control, users can type into the control to carry out a search.

 

https://docs.microsoft.com/en-us/powerapps/controls/control-combo-box

2 REPLIES 2
Super User
Super User

Re: How to Generate a List of Choices for a Text Box

Hi @caballar

 

The control that you're looking for is the Combo box control. Unlike the drop down control, users can type into the control to carry out a search.

 

https://docs.microsoft.com/en-us/powerapps/controls/control-combo-box

caballar
Level: Powered On

Re: How to Generate a List of Choices for a Text Box

Thank you!

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 72 members 4,414 guests
Please welcome our newest community members: