Announcements
Can someone please help me understand why am I getting this delegation warning? Please see the screenshot, the Company Name is actually the Title on the SharePoint list and it is indexed in SharePoint. It is not just warning I am not able to search all items, the list contains over 3000 items. The article (https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview) says if you use filter (no other function inside that doesn't support delegation) will retreive even if there are millions of records. Here is the qoute from the article ("All records that meet the search criteria appear, even if the data source contains millions of records").
Hi,
Filter is delegable, but you are using 'in' which is not a delegable predicate:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list
You could change your formula to the below which uses only delegable functions and will search as you type:
Filter(Companies, StartsWith('Company Name', CompSrchBox.Text))
Hope this answers your question 🙂
Thanks @iAm_ManCat that's what I thought, I think Microsoft needs to use better examples in their documents. Specially when trying to explain a topic i.e. it is not a good example for delegation topic.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 220 Super User 2026 Season 2
WarrenBelz 189 Most Valuable Professional
Mohsin Ali 139