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 / Delegation Warning: Fi...
Power Apps
Answered

Delegation Warning: Filter Gallery using "in" operator

(0) ShareShare
ReportReport
Posted on by 55

Hello,

 

I have a dropdown with 4 values, NE, NW, SE, SW.  I want to use these values to filter a Gallery with addresses that contain those values, eg.

 

Dropdown1 Items: ["NE", "NW", "SE", "SW"]

Gallery1 Items: Filter( CDSTable, Dropdown1.Selected.Value in LookupColumn.Name)

 

This results in a delegation warning - any thoughts?

 

Greg

Categories:
I have the same question (0)
  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @deltaformtech 

    Perhaps the problem is with the target of the Filter being a Lookup column.  It works fine for a regular text column.  I am spitballing here but what if you used AddColumns() to add the value from the Lookup to your table and then filtered on it. 

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 883

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 477

Last 30 days Overall leaderboard