topic Re: aopRe: @Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector) in Developer

Select Multiple Drop Down Navigation Table Menu (for custom data connector)

Anonymous — Tue, 23 Jul 2019 09:47:09 GMT

I am building my navigation table for my custom data connector and am looking to have a multi-select option in the menu as seen in one of the examples here: https://github.com/microsoft/DataConnectors/tree/master/samples/OpenApiSample

The closest I have been able to get is a single selectable drop down list, and as far as I can find there is nothing in the documentation on how to do this as there are many functions for custom data connectors which are not documented...

Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector)

Anonymous — Mon, 05 Aug 2019 18:13:49 GMT

I would also be interested in how to do this if anyone has any helpful tips.

Thanks,

Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector)

Anonymous — Tue, 06 Aug 2019 08:23:48 GMT

I have actually, after many many hours of trial and error, figured out how to do this.
It turned out, as most things do, to be annoyingly simple...

When you are adding the meta-data to the function for the navigation table, instead of having it as type text, simply put it as type list instead, and set the allowed values to be whatever you want to appear in the list box.

Hope this helps people!

Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector)

Anonymous — Fri, 20 Dec 2019 10:53:42 GMT

Hey @Anonymous, can you explain a bit more of how you did it?
I'm currently struggling to add a dropdown to my function parameters in the navigator.

I can replicate it in Advanced Editor and works fine, but not in the connector...

Best Regards,
Carlos

Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector)

ppraveenk — Thu, 25 Jun 2020 19:13:54 GMT

Hi @Anonymous I am struggling for few days now to understand how to add user input parameters for a navigation table. Could you please help to elaborate how you managed to achieve this fucntinality. Any code reference would be greately helpful. Thanks!

Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector)

Anonymous — Thu, 25 Jun 2020 19:38:36 GMT

Hi all, I haven't worked on this in a while so can't give much more insight than in my above post. To see the code where I used it (or a since updated version) have a look at the intelligent plant industrial app store data connector, that is what I was used this functionality for.

Thanks

@Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector)

Anonymous — Fri, 26 Jun 2020 08:16:02 GMT

Hi @ppraveenk , you can build a navigation table like this, and then expose your functions:

Hope it helps.

aopRe: @Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector)

ppraveenk — Fri, 26 Jun 2020 09:13:04 GMT

Hi @Anonymous

Many thanks for you reply. I want to capture the Start and End Date parameters from User before invoking the RestAPI call.

After implementing your suggestion, I am not seeing any input fields in the navigator, but getting a message "No parameter values specified".

Sorry for being ignorant, but I am trying my hands on power bi connector for the very first time.

This is how I am trying. Request you to let me know if I am doing something incorrectly. Thanks in advance!

GetUserSearchTable = (startDate as text, endDate as text) as table =>
let
body = "{ ""endDate"" : """&endDate&""" , ""startDate"" : """&startDate&"""}",
source = Web.Contents("https://rest.api/users", [ RelativePath = "search", Content = Text.ToBinary(body)]),
json = Json.Document(source),
#"Converted to Table" = Record.ToTable(json),
Value = #"Converted to Table"{0}[Value],
#"Converted to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table1", "Column1", {"userID"}, {"userID"}),
#"Renamed Columns" = Table.RenameColumns(#"Expanded Column1",{{"userID", "Id"}}),
#"Invoked Custom Function" = Table.AddColumn(#"Renamed Columns", "GetListTable", each GetListTable([Id])),
#"Expanded Users" = Table.ExpandTableColumn(#"Invoked Custom Function", "GetListTable", {"name", "type"}, {"name", "type"})
in
#"Expanded Users";

Re: aopRe: @Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector)

Anonymous — Fri, 26 Jun 2020 09:28:08 GMT

The thing that catches my eye is the "as table" that you have on your function. If it receives parameters, you have to define it as a function, I think.
So remove it from your NavTable and GetUserSearchTable. Also, define your GetUserSearch table as "function" on the navTable.

Re: aopRe: @Re: Select Multiple Drop Down Navigation Table Menu (for custom data connector)

ppraveenk — Mon, 13 Jul 2020 20:06:00 GMT

Hi @Anonymous, thanks for your response.

Could you please let me know if you are aware of how to pass default value as today' date for Start and End date params in Navigation table. Highly appreciate!