I have one dimension "Employee" and want to assign two products A and B. Product A and Product B are two line items formatted as Product List.
It is perfectly fine if employee is assigned the first product however, when the employee is assigned product B, then product A should not be visible in the dropdown as the employee has already been assigned.
Employee Product A Product B
John Screws Nuts
When John is being assigned Nuts then Screws should not be visible in the drop down.
Seems like a simple situation but I am struggling to make the logic.
Try using dynamic cell access approach. When a user selects a value from Product B, then, the Boolean (you could use this name for line item: "Activate Product A") will become false, else true. Now, for Product A line Item, set Read access driver and Write access driver to use "Activate Product A" value.
You can create "Assign" action through which you can do that. Please see the below the screenshots. As you can see that Product A is assigned to John. When you will click again in "Assign Product to Customer " action. you will be able to assign Product B only.