Appending HTML Lines Using String Builder

Appending HTML Lines using a String Builder Step requires a few steps to get the data from the database and then select the information needed to Append an HTML line into Text. The String Builder Steps are found in the Steps Tab under Data> Text> Builder.

Example

The flow example below demonstrates how to append HTML lines to the String Builder. The steps used in the flow example are listed below.

Steps:

• Create String Builder: All Steps [Catalog] > Data > Text > Builder
• Get all from dbo.ProductData: Integrations> My Integrations> Database> Mock Data (Database)> dbo_Products(Table)
• ForEach Step: All Steps [Catalog] > Flow Management 
• Append HTML Line: All Steps [Catalog] > Data > Text > Builder 
• To HTML Text: All Steps [Catalog] > Data > Text > Builder

Appending HTML Lines using String Builder Step, Flow example (Figure 1).

Figure 1

Configure The Steps:

Create String Builder 

In the Create String Builder Steps editor under Outputs set the Done path to Rename and enter CreateStringBuilder_Output (Figure 2).

Figure 2

Get all from dbo.ProductData

Note: This step is populating data from an integrated database. It is not necessary to integrate with a database, this step should be replaced with the relevant data for your process. 

In the Get all from dbo.ProductData the Table will appear under Output Settings and under  Output Type. Under Inputs set the Limit count to Ignore or specify the Input. Under Outputs and Done select the data, set to ProductData_Result (Figure 3).

Figure 3

ForEach Step

In the Foreach Step Editor, select the Data Type and select the collection outcome under  Collection.  Under Common Properties and under Data select the database that Decisions has been integrated with (Mock Data). Next, under Inputs and Collection choose Select From Flow and then pick Products_Result outcome (Figure 4).

Figure 4

Append HTML line

In the Append HTML Line editor under Inputs next to line To Add select Merge HTML Text and select Show Editor to add the inputs. Next, to String Builder choose Select From Flow and select the CreatStringBuilder_Output (Figure 5). 

Figure 5

Show Editor: Select Show editor to open the Merge Text Editor. Create an HTML text using flow inputs on the left. Select the data from the database that you want to be displayed. Selected below is Current ProductName and Current Product ProductNumber (Figure 6).

Figure 6

To HTML Text

In the HTML Text editor under Inputs next to reset Data select Constant and check the box. Next to String Builder set to Select From Flow and then Pick CreateStringBuilder_Output (Figure 7).

Figure 7

Connect the Pathways and Debug the Flow

After the Steps are configured in the Properties Tab under Common Properties, connect the pathways as displayed in (Figure 1). Complete the flow by selecting Debug and verify that the flow works properly.

Links:

Integrating an External Database with a Flow

Additional Resources

• Multi-Tenant: Fix a Secondary Connection String