Unanswered

ComboBox not showing all items

(0) Share

Report

Posted on by esjimenezp

485

Hi Community, I have the next issue, in SharePoint I have 29942 items and I need to use the column called "Project" (Single line of text) then in my canvas app I use a combo box to select one of the items (Project) but only show me a few items.

I use the next formula

Distinct(BDCMEX,Project).Result

The column in SharePoint is single line of text, I use the Distinct because the Project are repeats over multiple items

This is the current items in my SharePoint list

Is there a way to handle this option? Any help I really appreciate, thanks in advance.

Kind regards 👋

Categories:

Connecting to Data

Using Apps Using Formulas

All responses (2)

Answers (0)

esjimenezp 485 on at

Like (0)

Report

Re: ComboBox not showing all items

thanks @RandyHayes very clear, I'm going to talk with the customer and try to view different options for this specific column, may be create a new list with the values of that column or another way, I really appreciate your help, thanks....

Kind regards 👋
RandyHayes 76,287 Super User 2024 Season 1 on at

Like (1)

Report

Re: ComboBox not showing all items

@esjimenezp

Distinct, as with all other functions in PowerApps, are limited to the maximum number of records that your app is set to. So, if you have the max records set to 2000, then your distinct function will only return the distinct values of 2000 records.

Once your list goes beyond the limits available to you, you need to consider an alternative way to perform these type of actions. One method is to augment your primary list with a list of simply distinct values from the larger list. You would enlist PowerAutomate to keep that secondary list current when changes are made in the primary list.

I hope this is helpful for you.