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
Gabe_V's avatar
Gabe_V
Helper I
2 years ago

Hi ImkeF Thank you for your feedback. I tried what you suggested, and although I think it fixed that problem, now I get "Expression.Error: We cannot convert a value of type Table to type Logical." In my function, I am using two nested Table functions, but I don't see how else I can reach my objective of inputting a field (r row and c column), evaluating if it contains the text "(SMT)", and then returning true or false to the custom column, "Flag 2 Test" based on if it finds that text or not. Am I overthinking/over-engineering it?

 

AlienSx's avatar
AlienSx
Super User
2 years ago

Hi, Gabe_V do you really need a custom function? Why not simply 

#"Added Custom" = Table.AddColumn(#"Flag 2b", "Flag 2 Test", each Text.Contains([DescriptionTypeValue], "(SMT)"))

? 

  • Gabe_V's avatar
    Gabe_V
    Helper I
    2 years ago

    Hi AlienSx,

    That's a good question, and one that I knew would probably be asked eventually. Its mostly because this is a bare-bones version of the ultimate function, which will eventuall need to a) perform much more complex "if then" logic, and b) be able to take values from different tables' fields and compare them against each other, etc.