Forum Discussion
Passing a list or array to a function
Hi,
I have a simple function that evaluates an Excel's Named Range to get its value like this:
(RangeValue as text) =>
let
RangeValue = Excel.CurrentWorkbook(){[Name=RangeName]}[Content]{0}[Column1]
in
RangeValueTo call this I simply do
RangeValue("SomeExcelNamedRange")However, this will evaluate only individual named ranges at a time. What if I want to evaluate 3, 4, or any other number named ranges from Excel? I would call the new function like this:
RangeValues({"Name1", "Name2", ... "NameN"})
Could you help me write this new function?
Thanks
Here is an example
https://www.dropbox.com/s/r2ha4qe9513ft08/functions.xlsx?dl=1
4 Replies
What you have written as the pseudo code is one function with 3 parameters. You could execute the same function that takes 1 parameter 3 times instead. In power query, create. List of ranges. {“rg1”,”rg2”} etc. Convert to a table, Then insert column, invoke custom function and pass the column values to the function. Then combine
Sorry could you show me the code to do that?
I am not sure what your method does, but how would I invoke this new function?
The simplicity that I seek is that I can easily type in one line the items in my list and the desired macro would execute them, without having to create new queries or tables.Here is an example
https://www.dropbox.com/s/r2ha4qe9513ft08/functions.xlsx?dl=1
