web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Combo Box 'Depends On'...
Power Apps
Unanswered

Combo Box 'Depends On' Delegation Warning

(0) ShareShare
ReportReport
Posted on by beagle123

Hi PowerApps Community, 

I have searched for a solution for my query on here but to no avail..

I have two sharepoint lists. One to store the data from my app and a second to act as a look up table. 

Ive created a new form and  combo box where i have used the 'depends on' function.

Depends On.pngFields.png

Filter('CI Parent List', Title = DataCardValue19.Selected.Value)
 
The 'Title' column is the same as the parent control and I want it to filter 'Department' options. 
 
However when i try to input a new form, all items except 'Department' pull through in the sharepoint list. A delegation warning appears saying 'The "Search" part of this formula might not work correctly on large data sets.'
Both lists combined contain no more than 250 rows, I have extended the row limit to 2000.
 
Any help with this issue would be greatly appreciated.
Thanks
 
 
 

Delegation Warning.PNG

 

 

Categories:
Building Power Apps
  • JR-BejeweledOne Profile Picture
    JR-BejeweledOne 5,836 Moderator on at

    Here is an excellent explanation of the Delegation and how you can work with and around it.

     

    https://youtu.be/UaBmVUQx_Fk

  • v-siky-msft Profile Picture
    v-siky-msft Microsoft Employee on at

    Hi @beagle123 ,

     

    The delegation warning is due to the Search function for Combo Box, set 'Is Searchable' property to false if you want to eliminate this warning.

    Regarding to the issue that no department value pull through SharePoint list, I don't believe this issue is related to Delegation Issue since lists records number is under the delegation issue limits.

    I would suggest you check if there are any items in CI Parent List that match the criterion (Title = DataCardValue19.Selected.Value). 

    Sik

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans