Unanswered

ComboBox based on Managed Metadata not showing all items

(0) Share

Report

Posted on by SachS

151

I have a PowerApp based on a SharePoint list. One of the columns in the SharePoint list is a based on a company managed metadata list. The metadata list has about 70 items.

The PowerApp is a simple app with a gallery and an edit form. In the edit form, the said metadata column is bound to a Combo Box. However, when I pull down the combo box, it only shows the top 20 (alphabetical, ascending) items in the list. It does let me search for and find the other items, it just doesn't show them all by default.

What's the reason for this and how do I fix it? Most online questions similar to this has the responses saying increase the data row limit from 500 to 2000 (which I did) but I can't imagine how it would help in this situation.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

cha_cha 4,932 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hello @SachS

It actually lies down with the API of SharePoint used by Power Apps. They have predefined behavior that we can modify.

Even if you are just using one list in your app, on the backend, it's actually fetching lots of information related to the list. Some information, like metadata, may be stored in a larger list on the backend. Fetching the first 500 could mean only getting system set metadata, so that's why setting it higher to 2000 can provide a higher chance that custom metadata can be loaded by default. Instead of calling the information through search and going back to the backend database, it's just loading from the cached 2000 records. I hope I'm making sense.

Was this reply helpful? Yes No
Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

What is the column type in SharePoint?
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
SachS 151 on at

Like (0)

Report
Copy link

Link copied!

@cha_cha well, it kind of does make sense, but as I mentioned I have already set it to 2,000 and its still not fetching more than 20. Also, my main list only has about 25 items in total (the app is still in development) so I doubt it actually I've exceeded such a limit.

Was this reply helpful? Yes No
SachS 151 on at

Like (0)

Report
Copy link

Link copied!

@FLMike the type is 'managed metadata'. It is essentially a list of our customers, in other words, textual information, but the column type is managed metadata. Please see the column details below:

Was this reply helpful? Yes No