Forum Discussion
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 ...
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
ImkeF
Community Champion
Community ChampionHi Anonymous
if you want to refresh your query in the service, you have to use a)
Otherwise you could use Expression.Evaluate for b)
Unfortunately I don't yet understand what your problem with solution a) is. What exactly do you mean with "I have not been able to find the name of the table I passed"?