Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

M Language - Custom Functions -> Passing a Table by a string name

This is very specific to writing a Power Query Custom Function.  Keep that in mind when responding because I am not looking for a another way to do it without a Custom Function.   I want to create ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Here  is the solution...

     

    let

        TargetTable = (TargetTableName as text) as table=>

          let

            TargetTable = Record.Field(#sections[Section1], TargetTableName)

          in

            TargetTable,

          MyTable = TargetTable("ccontl")
    in
        MyTable

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Here  is the solution...

 

let

    TargetTable = (TargetTableName as text) as table=>

      let

        TargetTable = Record.Field(#sections[Section1], TargetTableName)

      in

        TargetTable,

      MyTable = TargetTable("ccontl")
in
    MyTable

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous  and ImkeF  This approach is very cool.  I have been struggling with finding a way to integrate strings into expression values.  Anonymous Your soloution is great!  Do you think there is a way to further refine it and remove the need to cosider it a table and simply a variable or are we trapped by type?  

  • ImkeF's avatar
    ImkeF
    Community Champion
    6 years ago

    Hi Anonymous ,

    the definition of the output type is optional, so if you remove it, you can use this query to reference queries of any type.

     

    let
    fnTargetQuery = (TargetQueryName as text) =>
     
        Record.Field(#sections[Section1], TargetQueryName),

    CallFunction = fnTargetQuery("ccontl")
in
    CallFunction

    ... code is slighty rewritten ...

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      ImkeF Thanks alot this is a really powerfull pattern.