Take input of list of records

[vivekjvs]

Hi experts,

How can I give list of records as input to a field. What datatype should I use in my power query code to enable taking input of list of records from the UI.

I have records like this

I want to utilize the above output in the below function

When I click on Choose Column, I am able to see the Query1 option in the dropdown but no columns are there to select.

Thanks
Vivek

[ronrsnfld]

If the input to your custom function is to be a List of Records, then the data type would be a List

[vivekjvs]

The above screenshots are results of setting the datatype to list. I was not able to select a list of records even when I used list datatype.

[ronrosenfeld]

You are only showing the screenshots from the user interface. For assistance, please post the code from the advanced editor.

[vivekjvs]

Please refer to the below screenshots
1) Code in .pq file

2) Code which generates a list of records

3) In the RunDummyCalc funcion, I am trying to select the above "Query1" but I am not able to see any option to select entire table/ list of records

[ronrsnfld]

Next time post your code as text (using the "code box" from the top menu) to make it easier for those who might help.

• Your Query1 produces a Table, not a list of records.
• To call your dummy function, from wherever, use something like below which returns Column1 of the table as a List.

= runDummyCalc(Query1[Column1])

• I don't know why it doesn't show up in the UI, but you can certainly call a function without the UI.