pass a column name as variable

Question

Hi guys, I need your knowledge 😄&nbsp;I am trying to pass the name of a column as a variable to create a table from a custom function.this M code work:&nbsp;(tabla as table, fecha as date, name as text) =&gt;
    let
        nameColumn = "Full Name",
        Origen = tabla,  
        #"Filtro" = Table.SelectRows(Origen, each (  [Full Name] = name) and ( [Created Date] = fecha))    
    in
        #"Filtro"&nbsp;but I would like something like this:&nbsp;(tabla as table, fecha as date, name as text,nameColumn) =&gt;
    let
        Origen = tabla,
        #"Filtro" = Table.SelectRows(Origen, each (  [nameColumn] = name) and ( [Created Date] = fecha))    
    in
        #"Filtro"&nbsp;&nbsp;but I get the following error; "Expression.Error: The field 'nameColumn' of the record wasn't found"&nbsp;Please any idea why the variable is not recognised in the filter context?

andres_montanag · Accepted Answer

Hi, I found the solution in this post.My code is as follows:&nbsp;(tabla as table,nameColumn as text, fecha as date, name as text) =&gt;
    let
        Origen = tabla,
        #"Filtro" = Table.SelectRows(Origen, each (  Record.Field(_,nameColumn) = name) and ( [Created Date] = fecha))    
    in
        #"Filtro"&nbsp;the solution is the function:Record.Field(record as record, field as text) as any&nbsp;

Forum Discussion

pass a column name as variable

2 Replies

Related content

pass a dynamic variable from pipeline to notebook

Dynamic Variable in Calculated Columns

Passing a variable from one pipeline to another

Using Record.Field to pass column name variable

UDF: can we pass a column as parameter?