cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrstian89
Resolver I
Resolver I

Remove choices based on a lookup column

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?

2 REPLIES 2
phipps0218
Super User
Super User

<> 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

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

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,637)