cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AccessPowerApps
Level: Power Up

Hide 1st column of dropdown or combo box

I would like to have a dropdown or combo box that hides the first column and only displays the second column. The item list will come up from an On-Premise SQL Server via gateway. The ID will be the selected value of the control. Example...

HiddenID | DisplayedPlusSearchName

1              | Bugs Bunny

2              | Homer Simpson

3              | Mickey Mouse

4              | Bart Simpson

5              | Charlie Brown

6              | Fred Flintstone

Any suggestions on how to make that happen? I was not able to find any examples on the Web.

Thanks for your help in advance.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Hide 1st column of dropdown or combo box

You can set the Items property of the dropdown control to your SQL table - each item in the dropdown will represent the entire row of the table. What you should do then is to select which of the columns is displayed in the dropdown, which you can do in the Advanced pane when you select the dropdown control:

ForumPost001.PNG

Then, if you want to know the id of the selected item, you can reference that property:

Dropdown1.Selected.HiddenID

View solution in original post

1 REPLY 1
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Hide 1st column of dropdown or combo box

You can set the Items property of the dropdown control to your SQL table - each item in the dropdown will represent the entire row of the table. What you should do then is to select which of the columns is displayed in the dropdown, which you can do in the Advanced pane when you select the dropdown control:

ForumPost001.PNG

Then, if you want to know the id of the selected item, you can reference that property:

Dropdown1.Selected.HiddenID

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,720)