Forum Discussion

ritanoori's avatar
ritanoori
Resolver I
6 years ago

Expression.Error: We cannot apply field access to the type Function.

Hi, Can someone help on this error  Expression.Error: We cannot apply field access to the type Function. Details: Value=[Function] Key=Reference   Below is from advanced Editor let Source = E...
Need Help
ritanoori's avatar
ritanoori
Resolver I
6 years ago

I fixed it. It was syntax error.

if Text.Length([Reference]) = 9 and
Text.StartsWith([Reference], "FX")

then
Text.End([Reference],7)
else [Reference]

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Thanks for posting the solutions. Kudos to you.