Limit selected items in nested navigation table

[JoseCVM]

Hello,

As the title says, I'm having trouble figuring out how do I limit the number of selected items in a nested navigation table. I need to enforce a global maximum of 1 selected leaf item, independently of which subcategory its into. I'm basing my code around
https://github.com/microsoft/DataConnectors/blob/master/samples/NavigationTable/NavigationTable.pq
More specifically the NavigationTable.Nested one. Is it possible to disallow the selection of more than 1 leaf item across the whole table? How do I go about it? 

[artemus]

What you could do it make each subtree node a function which takes in a single value. You can then add metadata to that parameter with  a list of possible values based on the leaf nodes.

[artemus · Accepted solution]

Here is an example of a function that only lets you choose one of three options:

= Value.ReplaceType((txt as text) => ..., (type function (txt as (type text meta [Documentation.AllowedValues={"a", "b","c"}])) as any))

[JoseCVM]

I get the idea, but I'm not sure how to make this fit into my current navigation table. Still, thanks!

[Jimmy801]

Hello @JoseCVM , @v-lid-msft 

thank you about involving me, but I have to admint that I'm not an expert on custom connectors. However I gave it a deep look and I unfortunatly didn't find and handling possibilities for this, because the only way to make this work is a option in the library itself. 

I don't have any testing environments, so can't really figure out by myself

- on the SQL data connector is available an option "select multiple elements". so it seems to me that there might be some possibilities to have an impact on this. 

- what if for every navigation table row the option for "isleaf" is set to false (and not launch a navigation table function but invoke the data connector)... how would this work out.

Hope that helps at least a little bit

Jimmy

[v-lid-msft]

Hi @JoseCVM ,

Sorry for that, we did not find any function can achieve this according this document. We are not very good at developing cutome connector, Maybe there are some solution we did not come up with.  Hi @Jimmy801 and @artemus , Could you please look into this  scenario and give some help, Thanks in advance.

Best regards,