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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter using In Operat...
Power Apps
Unanswered

Filter using In Operator, but I received delegate warning

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi, 

 

I have 2 CDS entities, which are Departments and Employees. 

 

Departments

IdName
1Product Department
2Marketing Department

 

Employees

IdNameDepartment_Id(Lookup)
1John1
2James2
3Lee1

 

The Combo box (ComboBoxDepartment) is multi-select.

 

In the Gallery --> Item properties - Filter(Employees, Department_Id.Name in ComboBoxDepartment.SelectedItems.Name).

 

I received the Delegation warning. How can i avoid the this warning?

Categories:
  • WarrenBelz Profile Picture
    156,921 Most Valuable Professional on at

    Hi @Anonymous ,

    The In operator is not Delegable - if this works for you, it is delegable

    Filter(
     Employees, 
     StartsWith(
     Department_Id.Name,
     ComboBoxDepartment.SelectedItems.Name
     )
    )

     

    Please click Accept as solution 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 Thumbs Up.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @WarrenBelz ,

     

    Thanks for your reply. unfortunately it is not working. I received the error "Invalid argument type(Table). Expecting a Text value instead." It is because I need to filter the comboBox Selected Items Name(more than 1 item).

    Thank You

  • WarrenBelz Profile Picture
    156,921 Most Valuable Professional on at

    @Anonymous ,

    Yes - you did not mention it was multi-select.

    You do not need .Name on the end of .SelectedItems (as this is what is selected), however you have a Delegation issue with in and are also trying to do a many-to-many query which will produce the error Invalid argument type -cannot use Table values in this context

    I do not believe your current requirements can be achieved.

     

    Please click Accept as solution 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 Thumbs Up.

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @WarrenBelz ,

     

    Thanks, After removed .Name. I still received the same error which is "Invalid argument type(Table). Expecting a Text value instead". 

    I would like to know is there any workaround way? 

     

  • WarrenBelz Profile Picture
    156,921 Most Valuable Professional on at

    Hi @Anonymous ,

    Just to clarify, are you trying to do a "many to many" match here?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @WarrenBelz ,

     

    Each employee only from 1 department. But in the combo box, user can select more than 1 department(s). For example, I would like to know who are working in Marketing and Product departments?    

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 226 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 191 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 167

Last 30 days Overall leaderboard