FROM
Returns a FROM object for lookup configuration.
Passes the connection configuration to the data provider to work out where the data is coming from, used within functions such as LOOKUPA and LOOKUPB.
Syntax
LFROM FROM(string name)
Example
In the example below the account name in the account entity of Dynamics is being extracted, when the source is connected to the contact entity.
You would use the FROM
function to define that the name should be pulled from the account entity, and the WHEN
to define the conditions that need to be met.
LOOKUPA("name", FROM("account"), WHEN("accountid",accountid))