Expression.Evaluate
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"""
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for