If you require to query multiple buffer lookups in one step, there is a Buffer Query Lookup step that is now available! It assists with flow optimization and flow performance as a bonus.
Illustrated below is an example of a part of a flow where multiple buffer lookup steps are used
To optimize the buffer lookup steps in the flow, you can query the buffer lookups in one step using the Buffer Query Lookup step. To add a buffer and a query to lookup on, click on the highlighted Add Lookup button in the below image. Select the concurrent method you require for the lookup/s. Prefer Secondary is reading the data from a second instance which is quicker to lookup but the results may be a bit delayed.
The below page will appear when you click on the Add Lookup button. You can add multiple lookups by clicking on the Add Lookup button. Type the object name that you require to be returned with the data that is being looked up on from the selected buffer. There is a Limit field which is the maximum number of records that you require to be returned which is circled in blue in the below image. Select the required buffer by clicking on the drop down list that is circled in red. This will return the buffer ID which is highlighted. Type out your SQL query and you can reference a record in the data set by using '{@record.fieldName}' in your SQL query. Click on the Validate button to validate your SQL query and save the step. Multiple buffer lookups can be done in this step.
NB: The maximum total number of records for all Buffer Lookups is 1000 records. If you want to return more than 1000 records, use a Buffer source step in a sub-flow or use a Buffer Lookup step.
For more complex queries, click on the below link to see the available syntax:
