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

Combo box data not displaying

Hi All,

 

I am trying to insert a combo box so user may search a list of items in a data source and select them.

 

The list is 150+ item and will grow in time.

 

See attachements for settings

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
SunnyJess
Level: Powered On

Re: Combo box data not displaying

The issue was there was a blank line in the top of the data. 

 

In the standard drop down I put a blank line in as it picks up the first row of data and I didn't want that showing.

 

With the combo box you musn't need the blank line as it gives you the search function.

 

Once I took the blank line away the data showed up.

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Combo box data not displaying

The value for the Items property doesn't seem right because it is called "Items" unless you are using a collection and you called it Items. The Items property should contain the source of data from which selections can be made.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
SunnyJess
Level: Powered On

Re: Combo box data not displaying

Hi @Jeff_Thorpe,

 

Yes the data table is called "Items".  The column within the data table being referenced is "Item Name"

 

I just also tried it on another table that I have within my app that I know works in another field and it didn't wotk on that either.

Super User
Super User

Re: Combo box data not displaying

I just noticed in the first screen shot that the empty drop down may not actually be empty. If you look closely at it you notice there is a small scroll bar indicating that there is lot of entries in the drop down. Have you tried scrolling way down on the drop down to see if it displays any texts. It is possible that a bunch of blank rows are being pulled in and that is why it looks empty when you first click on the drop down.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
SunnyJess
Level: Powered On

Re: Combo box data not displaying

Hi @Jeff_Thorpe,

 

It's not picking up any values at all.

 

It recognises that there is 150 odd lines within the table, but it doesn't pick up the values.

 

I patched the combobox to the write table, but it only displays "text, text, text, " when you write.

 

Like I said, I have tried with with new tables, the tables I am using in the app.  Large tables (150 lines), small tables (4 lines), text, values and nothing is working.

SunnyJess
Level: Powered On

Re: Combo box data not displaying

The issue was there was a blank line in the top of the data. 

 

In the standard drop down I put a blank line in as it picks up the first row of data and I didn't want that showing.

 

With the combo box you musn't need the blank line as it gives you the search function.

 

Once I took the blank line away the data showed up.

View solution in original post

Highlighted
ParakramaDhanan
Level: Powered On

Re: Combo box data not displaying

it should be "Items.column name" in item section 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 191 members 5,063 guests
Please welcome our newest community members: