Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Syntax
Expression.Evaluate(document as text, optional environment as nullable record) as any
About
Returns the result of evaluating an M expression document, with the available identifiers that can be referenced defined by environment.
Example 1
Evaluate a simple sum.
Usage
Expression.Evaluate("1 + 1")
Output
2
Example 2
Evaluate a more complex sum.
Usage
Expression.Evaluate("List.Sum({1, 2, 3})", [List.Sum = List.Sum])
Output
6
Example 3
Evaluate the concatenation of a text value with an identifier.
Usage
Expression.Evaluate(Expression.Constant("""abc") & " & " & Expression.Identifier("x"), [x = "def"""])
Output
"""abcdef"""