Drop Down List Should Exclude Previously Selected List Items

Highlighted
Contributor

Drop Down List Should Exclude Previously Selected List Items

I am trying to limit the options in a dropdown list so that a user cannot select "option A" for both "slot 1" and "slot 2". In the attached image, the equivalent would be blocking the user from assigning "testtest" or "matt 622 upload" in the third slot for the parent "CUMMINGS, JAMIN".

 

Note: every parent should be able to select every option once, but never more than once. What is the easiest way to do this? Is there a certain way I need to setup my lists?

 

Thank you in advance for any help.

4 REPLIES 4
Highlighted
Super Contributor

Re: Drop Down List Should Exclude Previously Selected List Items

Hi @RobinSilk - I have a one question?

 

is the dimension of the module and format of a line item are same....?

 

 

Thanks,

Sorna Raja Prabhu
Highlighted
Certified Master Anaplanner

Re: Drop Down List Should Exclude Previously Selected List Items

Hi, @RobinSilk 

 

Recently, I realized that it is sometimes easier to use the boolean input instead of choosing from dropdown list items.

Here is an example.

 

dashboard.png 


1. You choose Parent Item (List: Lv1, Select_Parent.select)
2. 'Select_Example' module below is filtered by Select_Parent.select (GroupA). So you can choose from Child items of GroupA (Product A1, A2 or A3)
3. Boolean inputs on the not chosen item are hidden with DCA.

In this example, 'Product A1' has been already chosen in 'A', and you cannot choose 'Product A1' in Item D.

 

This may not be what you exactly want to build.
But "Boolean Input with DCA" hopefully helps you.

See attached blueprint Excel sheets in the detail.

 

I hope it helps,
Taichi

Highlighted
Community Boss

Re: Drop Down List Should Exclude Previously Selected List Items

the dependent drop down is using a line item to map to a property of the list.

If you change the property in the list to not match that line item, then if won't be proposed.

nathan_rudman_0-1592994203662.png

The trick is to bring the correct value of the selection status in the list, which you can do by adding the dimension to the line item with the classic first non blank

 

nathan_rudman_1-1592994266316.png

 

 


Nathan Rudman, Anaplan Model Builder
Highlighted
Occasional Contributor

Re: Drop Down List Should Exclude Previously Selected List Items

Hi @RobinSilk,

Here's how to set up the dependent list filter so that you exclude previously selected list items.  First you will need to set up a Selection Criteria list and add Yes or No to that list.

jocelynbell_0-1593189975507.png

Then set up 3 staging line items in your module. One with the selection criteria set to no, another staging line item to determine which items have been selected, and then finally a line item that determines if the item has ever been selected.

jocelynbell_1-1593190135528.png

The summary method for the Package Selected Staging should be First-non blank and the formula for Package Selected? is:

jocelynbell_2-1593190197293.png

Add a Filter Driver Property to the dropdown list and set the formula to be the Package Selected? line item:

jocelynbell_3-1593190245752.png

Finally, set up the dependent dropdown on your picklist and you should be good to go:

jocelynbell_4-1593190282305.png

Results:

jocelynbell_5-1593190459521.png