M function with dynamic parameter

[necmik]

Hi,

I am trying to create a function with dynamic parameter inputs. Does M engine support this?

For example; here I am adding a new column to the table with a function with one parameter:
Table.AddColumn(RenamedColumnTable, "Data", each (InputColumn1 as text) as any -> (....))

What I want to do is making "InputColumn1 as text" input parameter as dynamic. It can be any number of records such as:
paramsRecord = Table.FromRecords({

   [paramName= "param1", paramType = "text"],

   [paramName= "param2", paramType = "number"]

})

Is there a way to reference this paramsRecord as input parameters of the function?

[v-yalanwu-msft]

Hi, @necmik ;

You could refer to those link.

Using dynamic parameter values in Power Query Queries - ORAYLIS

Power BI Blog: Composite Models and Dynamic M Query Parameters Part 3 < Blog | SumProduct are expert...

Chris Webb's BI Blog: Dynamic M Parameters Chris Webb's BI Blog (crossjoin.co.uk)

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[necmik]

Hi @v-yalanwu-msft ,

Thank you for the links. I have checked them out. But as much as I see, they are to make the "values" dynamic, not the metadata of the input parameters. For example, I want to reference param variable as the input of the function here:

param = "InputColumn1 as text"
Table.AddColumn(RenamedColumnTable, "Data", each (param) as any -> (....)) 

will transform to:

Table.AddColumn(RenamedColumnTable, "Data", each (InputColumn1 as text) as any -> (....))