Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Power Apps Combo box delegation issue [Missing Items]

Posted on 11 Dec 2024 04:42:44 by 67
Hi Members,

I am facing an issue in the Power Apps Combo box control, some of the items are missing when I connect to the SharePoint list.

Requirement:
 
I have a SharePoint list [Employee List] over more than 5000 items, with a columns like:
  • Employee Name [Person or group]
  • Employee ID [Number]
  • Role Code    [Single line of text]
In the Role Code column, I have a items like [HYW, ORM,POL], [ORM,UYH, HYW], [HM, HYW], [POL,ORM]
 
Now, in the Power Apps form, I have a combo box control, here I need to display the Employee Names that contains "HYW" in the Role code column. 

Combo box Items property: 
SortByColumns(ShowColumns(Filter('Employee list',IsBlank('Role Code')=false && "HYW" in 'Role Code'),'Employee Name'),"Title",SortOrder.Ascending)
When I use this code, many items are missing in the combo box. 

There are 62 Employee names, that the role code contains "HYW",
 
But in the combo box there are only 42 employee names, that the last employee names are missing, may be due to the Delegation issue.

Please, help me out how can i achieve it, I need to display all the 62 Employee names that contains "HYW." If the items are adding also, I dont want to face any issues in further, because the list has more than 5000 items.

Thanks in Advance!
 
 
 
  • WarrenBelz Profile Picture
    WarrenBelz 143,595 on 15 Dec 2024 at 01:12:19
    Power Apps Combo box delegation issue [Missing Items]
    A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    Buy me a coffee
  • WarrenBelz Profile Picture
    WarrenBelz 143,595 on 11 Dec 2024 at 05:08:51
    Power Apps Combo box delegation issue [Missing Items]
    Firstly, the in filter is simply not Delegable with SharePoint, nor are either the IsBlank() or not filters, so your entire filter lacks Delegation support. This limits the returned data to being from a data sample the size of your Data Row Limit (maximum 2,000). There is also a second issue over 5,000 items in that you need to index (in SharePoint) any columns involved in queries ('Role Code' in this case), but this does not solve the primary issue.
    Are there other fields you could query with Delegable criteria to get the sample to be examined under 2,000 records ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,595

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,098

Leaderboard