Using lookup tables in Flows
Last updated
Last updated
You can read lookup tables in Flows to reuse centrally defined data.
To use a lookup table, first create one as described in the Managing lookup tables page.
Navigate to the "Process Automation" suite
Select the "Flows" option from the menu
Create an initial flow using a trigger type of your choosing.
Add a new Perform Lookup step to your flow. Click on Add New Action and either select it from the Lookup Tables group or search for it using the Search capability on the right:
You'll be shown a configuration screen where you can select the table to read from and configure how exactly you want to perform this lookup:
You'll see three components you can configure:
By then clicking the Test button will let you see the resulting data:
Configuring which table to read from required and you must add at least oneLookup
action. You're not required to add any Replace
actions.
Lookup Table Slug indicates what table you want to look at. By clicking in this field, Flows will show you the available lookup tables:
Lookup lets you determine what to retrieve and you can use the various variables available to you to construct this lookup key. Default operation is to return the value your look up points to as the root level value, but if you want to create an object of data - you can use the As capability to load it into a specific property:
Replace lets you replace variables in a returned lookup results with either a static value or a value that is defined somewhere in your lookup table. The following example would replace the text {{ MyVariableName }}
in any item returned with the Lookup action with the value it finds under key replacements.<locale>.MyVariableName
: