Forum Discussion

JoseCVM's avatar
JoseCVM
Microsoft Employee
6 years ago
Solved

Limit selected items in nested navigation table

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, ind...
Need Help
  • artemus's avatar
    artemus
    6 years ago

    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))

     

Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

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