let
Source = Expression.Evaluate("""Hello World""")
in
Source
let
Source = Expression.Evaluate("6+4")
in
Source
let
Source = Expression.Evaluate("let a=3, b=4, c=a*b in c")
in
Source
let
Source = Text.Upper("abc")
in
Source
let
Source = Expression.Evaluate("Text.Upper(""abc"")")
in
Source
let
Source = Expression.Evaluate("Text.Upper(""abc"")", #shared)
in
Source
let
Source = #shared
in
Source
let
MyList = {1,2,3,4,5},
GetSecondNumber = Expression.Evaluate("MyList{1}", #shared)
in
GetSecondNumber
let
MyList = {1,2,3,4,5},
GetSecondNumber = Expression.Evaluate("MyList{1}", [MyList=MyList])
in
GetSecondNumber
let
MyList_Outer = {1,2,3,4,5},
NumberToGet_Outer = 3,
GetNthNumber = Expression.Evaluate("MyList_Inner{NumberToGet_Inner}",
[MyList_Inner=MyList_Outer, NumberToGet_Inner=NumberToGet_Outer ])
in
GetNthNumber
let
MyList_Outer = {1,2,3,4,5},
NumberToGet_Outer = 1,
RecordOfVariables =
[MyList_Inner=MyList_Outer, NumberToGet_Inner=NumberToGet_Outer ],
RecordOfVariablesAndGlobals = Record.Combine({RecordOfVariables, #shared}),
GetNthNumber = Expression.Evaluate(
"List.Reverse(MyList_Inner){NumberToGet_Inner}",
RecordOfVariablesAndGlobals )
in
GetNthNumber