Power Query ; Custom function to work on a list

[Dicken]

Hi,

I have made a custom function to work on a list and insert a range of values, I have not worked these into the function yet,

the fucntion in based on this

Please Login or Register  to view this content.

and the list.Accumulate to insert rows at the above positions,

Please Login or Register  to view this content.

But I have made a basic function not incorporating the rows to insert or grouping by number, but I can only get it to work
by type it in so; Function ( list) , but can't figure out how to use the options to enter parameter ; invoke dialog box ?
is there a way to select a list as you would a table? I don't know whether to use ( func name as list) => or just leave it out ?

I have attached work book with example and function,

Richard.

[CK76]

You are missing attachment to your post

[Dicken]

Sorry will amend.

[CK76]

1. In order to allow list to be selectable, you need it to be converted into table column. Table column ex:TableName[ColumnName] is considered list in PQ. This is partly due to limitation on PQ UI. Alternately you can pass List as is (i.e. query name that returns List type). i.e. add blank query and source = F(Query1)

2. If you need one or more parameter to be optional. Have it in the parameter but nullable type. ex: (alist as list, groupe as nullable number). Of course, you'll need to handle it in the function itself.

[Dicken]

Thank you, at least I can stop trying to do what can't be done.


Richard.