Forum Discussion

Gabe_V's avatar
Gabe_V
Helper I
2 years ago

Receiving errors when trying to pass and evaluate fields between functions

Hi folks,   Hoping someone can help me because I'm stumped (and also kind of a newbie). I have made a custom function, and need to reference it from my main query, passing in each record and a spe...
Need Help
ImkeF's avatar
ImkeF
Community Champion
2 years ago

Hi Gabe_V ,
I cannot follow which approach you are actually taking now.
Could you please post the full code you are currently using?

Gabe_V's avatar
Gabe_V
Helper I
2 years ago

Hi ImkeF,

Sorry about that. Here's what I'm currently using:

Function:

let
  #"Output Test" = (r,c) =>
if Table.RowCount(Table.SelectRows(
      Table.FromRecords(r),   
      each c = Text.Contains(Record.Field(r, c),"(SMT)")   
))>0 then "true" else "false"
  in
  #"Output Test"

The call I'm making is:

= Table.AddColumn(#"Flag 2b", "Flag 2 Test", each #"Output Check"({_},[DescriptionTypeValue]))

I should note that I also tried your other suggestion for the function, of:

let
  #"Output Test" = (r,c) =>
Text.Contains(Record.Field(r, c),"(SMT)")
  in
  #"Output Test"

But no luck there either.