How to substitute code below with compact loop?
let // SourceX are a table type variables
Source0 = SourceTable,
Source1 = fnCheckId(Source0, "T" ),
Source2 = fnCheckId(Source1, "PR" ),
Source3 = fnCheckId(Source2, "Fen"),
Source4 = fnCheckId(Source3, "XAL"),
Result = Source4
in Result
Tried this:
let
ParametersList = {"T","PR","Fen","XAL"},
Result = fnCheckId(Source, each ParametersList{_})
in
Result
Estimated Output: the same Result table as for the 1st example with no loop.
Returns following Error:
Expression.Error: We cannot convert a value of type Function to type Text.
Details:
Value=[Function]
Type=[Type]
Returns following Error: