Hi all,
as described in the subject I face the challenge that after having set up a Dynamic Lookup set filter for a lookup column, the filter dropdown shows values that arent't present in the view of the table. I see where the problem comes from but dont't know how to deal with it.
Background: I have two tables: LV and Position. LV ist a parent table, Position the child table that has a look up to LV (1:n). Since our company works and comments on both tables in different teams and projects, record ownership of LV an Position is assigned to internal project teams.
Now we want to grant access to external employees of craft companys via Power Pages to see what we commented on Positions. Authenticated Employees (in table contact) shall only see records of Position that their company (in table account) is given an order for.
To realize that, the table LV has a lookup column to the table account. For the table Position we have created a power pages specific view with a filter that only shows records where the accountname of the parent table account of the parent table LV eq the accountname. I learnd from other discussions that I can choose any created record of the account table as accountname. So my filter looks like "account equals 'Example Company C'". This works fine. When I log in as fake Albert, who is part of 'Example Company A', I only see Positions where the LV they belong to is appended to Company A. And as fake Bob I only see Positions that belong to 'Example Company B'...
The next step where I struggle is that for the case a craft company works on more LVs than one, their employees shall be able to filter down the Positions to one LV. At this point the dropdown of the Dynamic Lookup Set of the lookup column LV only shows LVs of Example Company C, that one, that is used to filter down the records in the first step.
So I wonder if there is another possibility of dynamically filtering down the records or should I modify the filtering of the first step.
Best regards,
Philipp
