Skip to main content

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))