Forum Discussion

1up's avatar
1up
Icon for Resolver I rankResolver I
6 years ago
Solved

Custom Column in Query Editor throwing "We Cannot apply field access to the type Function"

In trying to add a custom column in the query editor, an error is displayed.   "Expression.Error: We cannot apply field access to the type Function. Details: Value=[Function] Key=Repairing Deale...
  • HotChilli's avatar
    HotChilli
    6 years ago

    You need brackets

    Text.Lower([#"CustomerName"])

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

You need brackets

Text.Lower([#"CustomerName"])

  • 1up's avatar
    1up
    Icon for Resolver I rankResolver I
    6 years ago

    So it was that simple after all, thanks a lot, all of a sudden this day seems much better. 🙂

     

    Any one knows why paranthesis are needed for the text.lower-statement, while it is not needed for the if-statement?

  • JGrant8708's avatar
    JGrant8708
    Frequent Visitor
    2 years ago

    I had the same error message when I forgot an "&" between two text fields I was appending. 

    E.g., [Company] & " (" [Address]

    Which needs to be [Company] & " " & [Address]