# Tables with recipe data source

Workflow apps enable you to use recipes as a data source for table components. This allows you to dynamically populate tables with data from your other applications. This ensures data consistency and reduces manual effort.

You can create new recipes directly from the page editor.

Table with recipe data sourceTable component populated by recipe data

# Use cases

The following use cases provide examples of how you can use this feature to address your business objectives.

# Customer support

  • Scenario: A customer support workflow requires updating customer account information, which is dynamically populated based on data from a CRM system.
  • Solution: A recipe retrieves a list of customer accounts from Salesforce in real-time, ensuring that the table reflects the most up-to-date data. The employee can then update the account using a Workflow apps page. Submitting the page triggers an additional recipe that updates the account in the CRM.

# Sales lead processing

  • Scenario: Sales representatives must review accounts and related opportunities as part of a lead processing workflow. They require details about opportunities such as the name, description, and amount. Opportunities are stored in a CRM such as Salesforce and change frequently.

  • Solution: A recipe fetches the latest opportunities for a specific account from Salesforce and returns them to your app page in table format.

# HR onboarding

  • Scenario: An HR team needs to assign new hires to various departments, which are stored in a database and frequently updated.

  • Solution: A recipe fetches the latest list of departments from the database whenever the page loads, ensuring the HR team always sees the most current options.

# Limitations

This feature has the following limitations:

  • Pages can have a maximum of one table that uses a recipe as its data source. If your page includes additional tables, they must be configured to use data tables as the data source.
  • Table component recipes have a maximum run time of 10 seconds.
  • Long-running actions are not supported in table component recipes.
  • Runtime user connections are not supported in table component recipes.
  • Public (anonymous) pages don’t support recipes as a data source for table components.

# How to set up recipes as a data source

EXAMPLE USE CASE

This guide uses a sales lead processing use case and is intended to serve as an example. Recipe modifications such as trigger and action configuration may require additional customizations to suit your specific requirements.

Configuring recipes as a data source for table components consists of the following steps:

  1. Set up your recipe
  2. Configure page components

# Configure your recipe

Complete the following steps to set up this functionality in your Workflow app:

1

Sign in to Workato and create a Workflow app or select one of your existing Workflow apps.

2

Create a new page or edit an existing page.

3

Add a Table component to your page and select Recipe as the data source.

Select recipe as the data sourceSelect recipe as the data source

4

If existing recipes in your Workflow apps project contain the New component event (Drop-down) trigger, Workato displays them here. Otherwise, click Create recipe.

5
Set up your recipe
1

Go to the Name field and enter Get opportunities for table as the recipe name.

2

Go to the Location drop-down menu and ensure the recipe is in the same folder as your app page.

3

Click Start building.

Workato generates a recipe pre-configured with the New load event from table (real-time) trigger and the Return data to component action:

Recipe skeletonRecipe outline

6
Modify the New load event trigger

Complete the following steps to modify the New load event trigger:

1

Select the New load event trigger.

2

Go to the Setup tab.

3

Go to Input parameters and click + Add field

4

Go to the Name field and provide a unique name for this parameter, such as account_id.

5

Go to the Label field and provide a unique name for this field, such as Account ID.

6

Go to the Data type field and select String.

7

Go to the Optional field and select No. When No, this field is required.

8

Go to Output parameters and click + Add field.

9

Go to the Name field and provide a unique name for this output parameter, name.

10

Go to the Label field and provide a unique name for this field, such as Name.

11

Go to the Data type field and select String.

12

Go to the Optional field and select No. When No, this field is required.

13

Create the following additional output parameters:

Name Label Data type Optional
description Description String Yes
opp_type Opp type String Yes
stage Stage String Yes
deal_amount Deal amount Number Yes
probability Probability Number Yes
opp_id Opp ID String Yes

Your configuration should look as follows:

Trigger configurationNew Load event from a table trigger

7
Configure a Search for Opportunities in Salesforce (Batch) action

This action fetches the opportunities and related details for an account you specify. The output populates the output fields specified in the New load event trigger.

1

Click Step 2.

2

Search for and select Salesforce as your app and select the Search for Opportunities in Salesforce (Batch) action.

3

Use the Object drop-down menu to select Opportunities

4

Use the Fields to retrieve drop-down menu to select Opportunity ID, Name, Description, Stage, Amount, Probability (%), and Opportunity Type.

5

Map the Account ID | Step 1 datapill into the Account ID field.

Your configuration should look as follows:

Search for Opportunities in Salesforce (Batch) actionSearch for Opportunities in Salesforce (Batch) action

8
Modify the return data to drop-down action
1

Select the Return data to component action.

2

Go to the Table data source options field and map in the Opportunities | Step 2 datapill.

3

Go to the Table data section and map datapills into the following fields:

Field Datapill
Name Name | Step 2
stage Stage | Step 2
Deal amount Amount | Step 2
Opp ID Opportunity | Step 2
Description Description | Step 2
Probability Probability | Step 2
Opp type Opportunity type | Step 2

You configuration should look as follows:

Return data to component actionReturn data to component action

9

Click Save.

Your completed recipe should look as follows:

Completed Get data for table recipeCompleted Get data for table recipe

# Configure page components

Complete the following steps to configure your recipe as a data source for table components in the page editor:

1

Click the Data table component to select it.

2

Go to the Properties panel.

3

Use the Recipe input parameters section to set up an input parameter for use in the Get data for table recipe created in the previous step:

  • Map the Selected value | Select an account page component datapill into the Account ID field.
4

Use the Displayed columns menu to select the columns you plan to display on your page.

5
Configure component visibility

Complete the following steps to configure this component to be visible only after a user selects an account:

1

Go to the Appearance section.

2

Click Conditional.

3

Map in the Selected label | Select an account datapill to the Data field.

4

Use the Condition drop-down menu to select Is present.

6

Type Opportunities into the Title field.

7

Enter 10 into the  Max table height field.

8

Click Save.

Your configuration should look as follows:

Component configurationComponent configuration


Last updated: 6/23/2025, 9:17:04 PM