cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
Power Apps
Power Apps

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
Highlighted
Power Apps
Power Apps

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,799)