Delegation Warning in Power Apps Combo box [How to Overcome]

When working with Power Apps Combo box control, you may face an error like a Delegation warning. The error shows as follows: The “Search” part of this formula might not work correctly on large data sets.

We can overcome this delegation warning issue by setting a data row limit or creating a Power Apps collection.

In this Power Apps tutorial, I will provide the solution to overcome the delegation warning while working with a Power Apps Combo box control.

Power Apps Error: Delegation warning. The “Search” part of this formula might not work correctly on large data sets

First, Let me tell you where we get this delegation warning while working with a Power Apps Combo box control.

Note,

Not only in the combo box, but also sometimes we may face this delegation warning issue while working with other controls in Power Apps.

Example: I have a SharePoint list [User Details], that has 2500 records in it.

Delegation warning in the Power Apps combo box control

On my Power Apps screen, I added a Combo box control and connected that box with the above SharePoint list country column.

Later, I faced an issue with a Delegation warning as “Delegation warning. The “Search” part of this formula might not work correctly on large data sets.”

It means my SharePoint list has more records.

Power Apps delegation warning in combo box control

Solution: Power Apps Delegation warning. The “Search” part of this formula might not work correctly on large data sets

Power Apps can only deal with 2000 records, but By default, the Data row limit is set to 500.

To overcome this, we can follow the below two solutions:

  1. Set Data Row Limit
  2. Create a Power Apps Collection

1. Set Data Row Limit:

  • On the Power Apps screen, click on More options (…) -> Select Settings.
Delegation warning combo box control in Power Apps
  • Under General settings, scroll down. By default, the Data row limit is set to 500, but it can be increased to a maximum of 2000.
Power Apps delegation warning
  • Still, the delegation warning will be present due to our records being larger than 2000.
Power Apps combo box delegation warning

To overcome after 2000 records, you can follow the below steps:

2. Create a Power Apps Collection using SharePoint list:

  • On the Power Apps app’s OnStart property, provide the code as:
ClearCollect(ColUsers,'Users Details')

Where,

  1. ColUsers = Power Apps collection name
  2. Users Details = SharePoint list name
Power Apps combo box delegation warning large data sets
  • Now, select the Combo box control -> Set its Items property to:
ColUsers.Country

Where,

  1. ColUsers = Collection name
  2. Country = SharePoint list column name
Delegation warning in the Power Apps combo box
  • We can’t see the delegation warning on the Power Apps combo box control.
Power Apps combo box not working showing a delegation warning

This is how we can overcome the Power Apps combo box delegation warning.

Some more Power Apps Combo box articles you may also like:

Conclusion

In this Power Apps tutorial, I have given a solution for your combo box delegation warning as “Delegation warning. The “Search” part of this formula might not work correctly on large data sets”.