Hi, this is a tips to transform a dynamic field name in powerquery expression to compute for example field
#"Filtered Rows" = Table.SelectRows(#"Changed Type1", each ([email] <> ""))
summarize :
------------
// suppose field as parameter
fParam="email",
// build the name field for expression
pemail="[" & fParam & "]",
// build expression
e="each " & pemail & " <> " & """""",
// sample action before
#"Changed Type1" = ............................................................................................................................,
// =================================================================
// = THE SOLUTION =
// ==================================================================
// either
// #"Filtered Rows" = Table.SelectRows(#"Changed Type1", Expression.Evaluate("each " & pemail & " <> " & """"""))
// or
// #"Filtered Rows" = Table.SelectRows(#"Changed Type1", Expression.Evaluate(e))
#"Filtered Rows" = Table.SelectRows(#"Changed Type1", each ([email] <> ""))
summarize :
------------
// suppose field as parameter
fParam="email",
// build the name field for expression
pemail="[" & fParam & "]",
// build expression
e="each " & pemail & " <> " & """""",
// sample action before
#"Changed Type1" = ............................................................................................................................,
// =================================================================
// = THE SOLUTION =
// ==================================================================
// either
// #"Filtered Rows" = Table.SelectRows(#"Changed Type1", Expression.Evaluate("each " & pemail & " <> " & """"""))
// or
// #"Filtered Rows" = Table.SelectRows(#"Changed Type1", Expression.Evaluate(e))