Power Query Custom Function Parameters Nested Allowed Values

[alindquist]

I created a custom function in Power Query that takes 3 parameters. I was able to use Documentation.AllowedValues to create a drop down list of hard coded allowed values for the first parameter, "Namespace".

I was also able to successfully create a drop down list of allowed values that is the result of a query to make the list dynamic.

There is actually data in the source system that provides a full list of availale namespaces, services, and business objects. Rather than make the user type out a specific service and business object value, I was wondering if it is possible to return a list of allowed values in each parameter based on the selections made in other parameters.

For example, there is a table in the data source that looks like this:

Namespace	Service	BusinessObject
Erp	Service1	BO1
Erp	Service1	BO2
Erp	Service1	BO3
Erp	Service2	BO4
Erp	Service2	BO5
Ice	Service3	BO6
Ice	Service3	BO7

Is it possible to set up the allowed parameter values so that if I select "Erp" for the Namespace parameter, it uses a query for the allowed values for the Service parameter to dynamically return only "Service1" and "Service2" as the allowed values? Then if I select "Service1" for the Service parameter, it uses a query for the allowed values for the Business Object parameter to dynamically return only "BO1", "BO2" and "BO3" as the allowed values?

[Cristian_Angyal]

Hey @alindquist ,

How did you manage to get the Dynamic List?
Can you share an example, please?

Thank you

[v-yanjiang-msft]

Hi @alindquist ,

By my research, haven't found the exact way, please see if this document helps.

Additionally, @Vijay_A_Verma is an expert in PowerQuery. @Vijay_A_Verma, would you like to see if you have encountered this kind of problem? Thanks in advance!

Best Regards,
Community Support Team _ kalyj