Call a Function with a List of Arguments in Power Query M

Invokes a function using an argument list built at runtime, instead of writing out each parameter by hand.

Advanced M FunctionsAdvancedfunction.invokeargumentsdynamic

Power Query M code

let
    Add = (a as number, b as number) as number => a + b,
    Arguments = {5, 10},
    Result = Function.Invoke(Add, Arguments)
in
    Result

Notes

Function.Invoke is handy when the number or order of arguments is only known at runtime, such as when building them from a table row.

Requirements

A function and a list whose items match its parameters, in order.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Call a Function with a List of Arguments.