Setting up dynamic list of values

We have a requirment as below.

We are setting up a General List to track the consumption of hardwares at different sites in the world.

There are two columns in this general list. One is Combination which can have three values (Region/Country/Site).

The next column is Combination_Name.

The idea is based on the value entered in the Combination column, the Combination_Name should show a relevant list of values. ex. If the users enter Region in the Combination column,then they can select either EMEA or APAC or AMERICAS in the Combination_Name. Same way, if they select Country in the Combination column, thenCombination_Name will have the list of countries from which users will select one.

Much appreciate if anybody provides some pointers on how this can be acheived.

Thanks

Prabakaran

Accepted answers

VIGNESH.M

Hi,

To achieve this, we need a Dynamic list.

1. Create a list called Combo Parent, in this list add your Top Level item(i.e, Region, country, siite...)

2. Create a another List called Combination List/Dynamic List, make parent of this list as combo parent list.

Add Respective data under each parent items

3. After this Create a module , as shown below.

1st(Combination) Line item format is Combination Parent,

2nd(Combination Name) line item format is Combination list, it's a dependent list based on Combiation

Now based on selection in 1st line item, your 2nd line item will show valid values only.

Regards,

~Vignesh

pnataraj

Thank you very much Vignesh.. It worked..

Regards

Prabakaran

All comments

VIGNESH.M

Hi,

To achieve this, we need a Dynamic list.

1. Create a list called Combo Parent, in this list add your Top Level item(i.e, Region, country, siite...)

2. Create a another List called Combination List/Dynamic List, make parent of this list as combo parent list.

Add Respective data under each parent items

3. After this Create a module , as shown below.

1st(Combination) Line item format is Combination Parent,

2nd(Combination Name) line item format is Combination list, it's a dependent list based on Combiation

Now based on selection in 1st line item, your 2nd line item will show valid values only.

Regards,

~Vignesh

pnataraj

Thank you very much Vignesh.. It worked..

Regards

Prabakaran

DeepakPrasad

Hi Vignesh,

Is there a way to default a value in a dependant list.

I have a list which I am populating based on values selected from another list. Now When I want to ask the user to make the selection I want it to be defaulted to the first value in the list. Is there a way to achieve this?

Regards,

Deepak

Misbah

@DeepakPrasad

No, I don't think so. Anaplan doesn't have an option of defaulting the dependent list to its first value. You have to make the selection. Also Drivers need to be selected first before the selection is made in the Dependent dropdowns

If you have a use case for which you need this you can post this into idea exchange forum.

Thanks,

Misbah

BahalR

Hi,

Do you know if there is a way to make a dependent dropdown based on multiple drivers

AmalGHL

Thank you, it works !

Do you know if there is a way to create a dynamic list based on a mapping module? (no hierarchy relation between the lists)

ShubhamCh

Hi @AmalGHL

Usually dependent dropdown list is created by module mapping only. Here is the link to documentation. You can study it and see how it's done with the help of a module.

If you still have any doubt, I can also show you the implementation for the case mentioned above.

Thanks!

- Shubham

Screenshots seem to be messed up. Sad i cannot follow the solution without :-/

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…