How to: Retrieve a value from a Lookup using a Subaction

The Lookup Query subaction type can be used to retrieve a value from a lookup by Column and Row.
Note: This includes when Importing from Excel

Retrieving a value from Lookup using a Subaction

  1. Go to the Workflow Action when performed the value is to be retrieved.
    Module → Module Name → Workflow (tab) → Workflow Name → Actions (tab) → Action Name → Subactions (tab)

  2. Within the subactions tab select the menu to the right, the within that menu select Lookup Query.


     

  3. Define the Parameters to retrieve the data:

    Field – This is the Internal Name of the field the retrieved value is stored in within the current Request.

    Tenant Id – This is the ID to identify the relevant tenancy.
    (defaulted to current Tenancy when not visible -or- undefined)

    Lookup Id – This is the ID used to identify the lookup that the field value is to be retrieved from by Key Value, and Key Column. This value can be found by looking at the URL for the corresponding lookup.
    For example the below LookupId is 10563


    Lookup Field – The field by Internal Name within the lookup that will be returned based on the Key Value and Key Column. (This value from the lookup is what is assigned to the Field on the left of the equation)

    Key Value – This is the Internal Name of the field of the current Request used to identify the row that contains the corresponding value to be returned by Lookup Field.

    Key Column – This is the Internal Name of the field column within the Lookup for which we are finding a matching Key Value row and retrieving the corresponding Lookup Field value.

    Example:

     

  4. Select ‘OK’ then ‘Save’ to apply the changes to the Workflow Action.

  5. Return to the Grid, perform the Action for which the Subaction was defined and verify the expected value is stored into the corresponding field.

Retrieving a value from User information using a Subaction


Using a Lookup Id of '0' enables this subaction to retrieve info by value from the User information using the same subaction as above.

The Parameters for retrieving these values are as follows:

Field – This is the Internal Name of the field the retrieved value is stored in within the current Request.

Tenant Id – This is the ID to identify the relevant tenancy.
(defaulted to current Tenancy when not visible -or- undefined)

Lookup Id – When retrieving the User information this should be '0’.

Lookup Field – Value to be retrieved from the User information, stored in Field.
(Example: Email)

Key Value – The Internal Name of the field within the Request that contains the value to retrieve the matching User information.

Key Column – Value used to identify matching row/user within the User information
(Examples: FullName, FirstName, LastName)

Example:

 

If you have reviewed the above and are experiencing any issue or have any questions contact Stratawise Support