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 / Remove choices based o...
Power Apps
Unanswered

Remove choices based on a lookup column

(0) ShareShare
ReportReport
Posted on by 319

I am creating an app where one can create individual favorites / links in the app based on a list of standards.

 

Table: Department Setup has a LookUp column pointing towards a table called: Standards.

 

When one is to add a new link/shortcut to the department setup, one can choose from the list of standard inputs.

I would like to filter this ComboBox to not include the Standards which are already added to the department setup.

 

I have come up with the following code:

Filter(
 Choices([@'Department setup'].xx_StandardInput),
 Title <> LookUp([@'Department setup'],Status = 'Status (Department setup)'.Active,StandardInput.Title))

It works, but it gives me a delegation warning.


Is there any way to write this in a better way?

Categories:
  • MVP-Phipps Profile Picture
    3,521 Super User 2024 Season 1 on at

    <> is the reason you are getting the delegation warning. Not equals is not delegable. 

     

    Please Accept as Solution if it solves your question. Or give this a Thumbs Up if it is helpful because this can help others.

    LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
    Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
    Twitter: https://twitter.com/phipps0218

  • mrstian89 Profile Picture
    319 on at

    Thanks for the response! Same error using In or =. Does not really work since a lookup only returns one record. Cant make it work with filter. Hope someone can help

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 381 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 340

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard