Others

Fix Power Apps Not Displaying All SharePoint List Items

Maira Mehtab Sep 22, 2026 869 views

Question details

A Power Apps canvas app is failing to display all records from a connected SharePoint list when filtering with a Combo box.

Product: Power Apps / SharePoint
Device & OS: not provided
Scenario: Filtering SharePoint list items within a Power Apps canvas app using a Combo box.
Observed behavior: Some records are missing from the filtered results despite a successful connection to the SharePoint list, particularly when dealing with single-line text columns.

Before you start

Ensure you have the appropriate permissions to edit the Power Apps canvas app and view the source SharePoint list. Check if your SharePoint list contains more than 500 items, as this often triggers delegation limits.

Solution 1Recommended

Resolve Power Apps Delegation and Configuration Issues

Address missing records by checking delegation warnings, adjusting row limits, or seeking specialized Power Apps support.

Missing records in Power Apps when connected to SharePoint are often caused by delegation limits. By default, Power Apps only processes the first 500 records if the filtering formula is not delegable to SharePoint.

To resolve this, you need to adjust your app settings, modify your formulas, or consult community experts for advanced configurations.

Check for delegation warnings

Open your canvas app in Power Apps Studio and look for a yellow warning triangle next to your Combo box filtering formula. This indicates a delegation issue.

Increase data row limit

Go to Settings > General in Power Apps Studio and increase the 'Data row limit for non-delegable queries' from the default 500 up to a maximum of 2,000.

Consult the Power Apps Community

For complex formula fixes, visit the Microsoft Power Platform Community forums and post your specific Combo box formula for expert assistance.

Contact Microsoft 365 Support

If you are an administrator, go to the Microsoft 365 admin center, select Support > Help and support, and open a new service request to investigate potential backend issues.

Delegable Functions: When filtering SharePoint single-line text columns, use delegable functions like 'StartsWith' or the '=' operator to prevent missing data.

Free Microsoft Office alternative

Manage Your Data Easily with WPS Office

While WPS Office does not replace Power Apps for building custom apps, WPS Spreadsheet provides a robust, lightweight, and free alternative to Excel for managing, filtering, and analyzing large datasets without complex delegation limits.

1. Open your data in WPS Spreadsheet: Launch WPS Office and open your exported list or dataset.
2. Apply Data Filters: Navigate to the Data tab and click 'Filter' to easily manage and view specific records.
3. Save and Share: Save your filtered views in standard XLSX format for seamless compatibility.

100% compatible with Microsoft Excel (.xlsx) formatsHandle large datasets with advanced filtering and pivot tablesFree and lightweight alternative to Microsoft OfficeFamiliar user interface with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

What is the delegation limit in Power Apps?

The delegation limit determines how many records Power Apps will pull from a data source (like SharePoint) to process locally when a formula cannot be delegated. By default, this limit is 500, but it can be increased to 2,000 in the app settings.

Why does a Combo box fail to show all SharePoint items?

Combo boxes often use search or filter formulas that may not be delegable to SharePoint, causing Power Apps to only search the first 500 items. If the target record is beyond the 500th row, it will not appear in the results.

Can I filter single-line text columns in SharePoint without delegation warnings?

Yes, filtering single-line text columns using the '=' operator or the 'StartsWith' function is fully delegable to SharePoint. However, using the 'Search' function or 'In' operator on text columns usually triggers a delegation warning.

How do I raise a support ticket for Power Apps issues?

Microsoft 365 administrators can raise a support ticket by logging into the Microsoft 365 admin center, navigating to 'Support', clicking 'Help and support', and submitting a detailed request.

Office Quick Solutions