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?