> ## Documentation Index
> Fetch the complete documentation index at: https://docs.flowforma.com/llms.txt
> Use this file to discover all available pages before exploring further.

# FlowForma Connect

> Export and import data between a FlowForma form and other systems using a business rule that calls an Azure Logic App, mapping questions to request and output properties.

**FlowForma Connect** allows you to export data from a **FlowForma** form to other systems, and import data from other systems into a **FlowForma** form, using the Azure Logic App feature.

The feature comprises a business rule that interacts with the Azure Logic App to simplify the creation of the Logic App.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-1.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=a0722c061a7319243c93bcebf7c5616c" alt="FlowForma Connect business rule" width="613" height="910" data-path="images/product/flowforma-connect/flowforma-connect-1.png" />

## Title

The first part of the business rule lets you define a **title** for your rule and select the event on which it operates. The default title is the standard **FlowForma** rule name; change it by deleting the text and entering your own.

In the **event** field you determine when the rule is executed. For a flow this can occur when the form is loaded, started, or completed. For a step this can occur when the step is started, saved, or completed. For questions it can occur when the question is updated.

## Rule condition(s)

The second part of the business rule lets you set conditions. These are not required, but if entered they control when the rule is executed in relation to other items in the form.

## Rule actions

**Url**: This is the Url of the Azure Logic App that is called by the business rule. Copy it from the Logic App.

**Request parameters**: To export data from a **FlowForma** form to a Logic App, map the **FlowForma** form questions to Logic App properties. Create these properties and mappings here, then use the button provided to copy the properties so you can paste them into the Logic App.

**Form properties**: Standard properties for each form are passed to the Logic App: the **FlowForma** form Form Id, Form title, the date the form was created, and the user who created the form. These are exported to the Logic App automatically when the rule executes.

**Output mappings**: When the Logic App executes, you can receive data back from it into the **FlowForma** form. To do this, create mappings between the **FlowForma** form question and the Logic App property. Create these properties and mappings here, then use the button provided to copy the properties so you can paste them into the Logic App.

**Stop execution**: If enabled, no other rules run after this rule executes.

**Enabled**: As rules are not saved to a list like questions and steps are, toggle this option to enable or disable a rule without having to delete it.

**Enable audit**: If checked, a record will be added to the audit trail when this rule is executed. This option is available when the Compliance feature pack is activated.

Transferring data using **FlowForma Connect** requires updating a **FlowForma** flow and an Azure Logic App at the same time.

Below are the steps required to create the business rule in the FlowForma flow and create the Logic App.

## Step 1. Create business rule in the FlowForma form

Once you have created the questions that will be used to send data to the Logic App or receive data from the Logic App, add a **Call Azure Logic App** business rule.

## Step 2. Create the Logic App

Go to the Azure portal: [https://portal.azure.com/#blade/HubsExtension/Resources/resourceType/Microsoft.Logic%2Fworkflows](https://portal.azure.com/#blade/HubsExtension/Resources/resourceType/Microsoft.Logic%2Fworkflows)

The following screen will be displayed.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-2.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=579600d5ebf060ad3ad8ca7a204d0060" alt="Azure Logic Apps portal" width="1914" height="910" data-path="images/product/flowforma-connect/flowforma-connect-2.png" />

Click <img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-3.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=ff1a781dea437250570baee491af4175" alt="Add button" style={{display:"inline-block",height:"1.5em",verticalAlign:"middle",margin:"0 0.15em"}} width="55" height="24" data-path="images/product/flowforma-connect/flowforma-connect-3.png" /> to create a new Logic App. The screen below is displayed.

<img src="https://mintcdn.com/flowforma/46u--5D7TPNcEo4x/images/product/flowforma-connect/flowforma-connect-4.png?fit=max&auto=format&n=46u--5D7TPNcEo4x&q=85&s=5979b812b37cc166c914d47757aca082" alt="Create Logic App form" width="316" height="1015" data-path="images/product/flowforma-connect/flowforma-connect-4.png" />

**Name**: Enter a name for your Logic App.

**Subscription**: This will be populated by your current subscription.

**Resource group**: Select existing.

**Location**: This will be populated when you have selected a Resource group.

**Log Analytics**: Leave Off.

<img src="https://mintcdn.com/flowforma/46u--5D7TPNcEo4x/images/product/flowforma-connect/flowforma-connect-5.png?fit=max&auto=format&n=46u--5D7TPNcEo4x&q=85&s=41ccdbdc36c2e6095e949a9d71ecfd78" alt="Create Logic App form with values entered" width="317" height="1013" data-path="images/product/flowforma-connect/flowforma-connect-5.png" />

When you have entered or selected all the fields, click <img src="https://mintcdn.com/flowforma/46u--5D7TPNcEo4x/images/product/flowforma-connect/flowforma-connect-6.png?fit=max&auto=format&n=46u--5D7TPNcEo4x&q=85&s=61db3283049059e01e79baf5e79abaed" alt="Create button" style={{display:"inline-block",height:"1.5em",verticalAlign:"middle",margin:"0 0.15em"}} width="92" height="25" data-path="images/product/flowforma-connect/flowforma-connect-6.png" />

You now need to select which type of Logic App you want to create.

Select **Blank Logic App**.

<img src="https://mintcdn.com/flowforma/46u--5D7TPNcEo4x/images/product/flowforma-connect/flowforma-connect-7.png?fit=max&auto=format&n=46u--5D7TPNcEo4x&q=85&s=f1e2bfee44941b903afd2815b3cc804b" alt="Blank Logic App template" width="272" height="275" data-path="images/product/flowforma-connect/flowforma-connect-7.png" />

The following screen is displayed.

<img src="https://mintcdn.com/flowforma/46u--5D7TPNcEo4x/images/product/flowforma-connect/flowforma-connect-8.png?fit=max&auto=format&n=46u--5D7TPNcEo4x&q=85&s=4f86c6357c311dce8e83193de113de45" alt="Logic App Designer" width="1918" height="547" data-path="images/product/flowforma-connect/flowforma-connect-8.png" />

Select **Request**. This is the first section on the Logic App, where data is received from the FlowForma form.

<img src="https://mintcdn.com/flowforma/46u--5D7TPNcEo4x/images/product/flowforma-connect/flowforma-connect-9.png?fit=max&auto=format&n=46u--5D7TPNcEo4x&q=85&s=af295acfd944760734293382eda991fe" alt="Request trigger" width="602" height="350" data-path="images/product/flowforma-connect/flowforma-connect-9.png" />

Click <img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-10.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=fee94f9a3b638017ddb758510845a16a" alt="Save button" style={{display:"inline-block",height:"1.5em",verticalAlign:"middle",margin:"0 0.15em"}} width="60" height="30" data-path="images/product/flowforma-connect/flowforma-connect-10.png" />

The Logic App has now been saved, and a Url for the Logic App generated. Click the <img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-11.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=94c2b2861cce598d3926cee538f0873d" alt="Copy symbol" style={{display:"inline-block",height:"1.5em",verticalAlign:"middle",margin:"0 0.15em"}} width="26" height="31" data-path="images/product/flowforma-connect/flowforma-connect-11.png" /> symbol next to the HTTP Post URL to copy the Url.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-12.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=64e0aeaced405349a10430f832ed1825" alt="HTTP Post URL" width="601" height="129" data-path="images/product/flowforma-connect/flowforma-connect-12.png" />

Copy this Url into the business rule on your FlowForma flow.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-13.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=8d31ef738bc4eae32a5a4f1ab80a9004" alt="Url pasted into business rule" width="601" height="924" data-path="images/product/flowforma-connect/flowforma-connect-13.png" />

## Step 3. Create request parameters (Questions used to send data to the Logic App)

In the request parameters section, open the **Question value** dropdown and you will see all the questions contained in the FlowForma flow.

Select the question you require, and a parameter title is created using this question name.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-14.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=b4ff3a57706278a18a7fa0913455bb64" alt="Question value drop down" width="619" height="260" data-path="images/product/flowforma-connect/flowforma-connect-14.png" />

Repeat this process for all the questions that are to be used to send data to the Logic App.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-15.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=00b3eb57d3d2046b3f53d0bf81e2e71f" alt="Multiple request parameters" width="621" height="255" data-path="images/product/flowforma-connect/flowforma-connect-15.png" />

Below the parameters is a button <img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-16.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=5d6961d048fa48be4c9c4172dff3b91d" alt="Copy request structure button" style={{display:"inline-block",height:"1.5em",verticalAlign:"middle",margin:"0 0.15em"}} width="147" height="24" data-path="images/product/flowforma-connect/flowforma-connect-16.png" />, which copies the request structure to your clipboard so you can paste it into the Logic App using Ctrl+V.

Click the button and return to your Logic App, paste it into the Request body JSON Schema field, and press Ctrl+Y.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-17.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=2049fcfd9ab447d507af0db9bdc16594" alt="Request body JSON Schema" width="604" height="355" data-path="images/product/flowforma-connect/flowforma-connect-17.png" />

The properties have now been added to the Logic App. Close the Logic App and reopen it to see the formatted version.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-18.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=3ab4eb354f2f794cf406bbcf9a0b7733" alt="Formatted request properties" width="602" height="354" data-path="images/product/flowforma-connect/flowforma-connect-18.png" />

At this point, the data has been received by the Logic App, and you now decide what you want to do with it.

In this example, we insert a row in a SQL database table.

In the Logic App, click <img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-19.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=7dbfede8dea57ea608742b5de31552c8" alt="New step button" style={{display:"inline-block",height:"1.5em",verticalAlign:"middle",margin:"0 0.15em"}} width="124" height="38" data-path="images/product/flowforma-connect/flowforma-connect-19.png" />

Search for the action you require, in this case SQL server.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-20.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=5d8b449026c8901a0e1e8886046fd600" alt="Search SQL server action" width="601" height="255" data-path="images/product/flowforma-connect/flowforma-connect-20.png" />

When you click on SQL server, it will list the options available.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-21.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=ff6c000d6443f580ac861664e06f05bb" alt="SQL server actions list" width="601" height="638" data-path="images/product/flowforma-connect/flowforma-connect-21.png" />

In this example we will select **Insert row**.

You will need to enter the Server Url and credentials to update the database.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-22.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=15516dd99b26b03db669552db8571ed2" alt="SQL server connection details" width="604" height="367" data-path="images/product/flowforma-connect/flowforma-connect-22.png" />

You are then asked to select a table to update.

Select a table from the database.

All the columns in the table are now shown as parameters.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-23.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=943999d7273df0629e927a3fa13f57d6" alt="Table columns shown as parameters" width="599" height="453" data-path="images/product/flowforma-connect/flowforma-connect-23.png" />

If you click in a textbox next to a parameter, you can add dynamic content.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-24.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=de350f7336d72eb50f84d4ffd716afff" alt="Add dynamic content" width="1011" height="556" data-path="images/product/flowforma-connect/flowforma-connect-24.png" />

The dynamic content includes properties defined in the request parameters, so it picks up form items.

Click in the Parameter textbox, then click the property required.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-25.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=298dd392697e14b5219c8de87311dd72" alt="Selecting dynamic content property" width="598" height="460" data-path="images/product/flowforma-connect/flowforma-connect-25.png" />

Now, when the rule executes in the FlowForma form, a row is inserted in the database.

You can leave the flow and Logic App at this stage, or you may want to receive notification in the form that the database has been updated.

To do this, create an output mapping in the business rule.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-26.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=bf6b8282ccabbef4664795dfdf000d2b" alt="Output mappings" width="617" height="360" data-path="images/product/flowforma-connect/flowforma-connect-26.png" />

This is the same process used when creating request parameters. When you select a question value, a Logic App parameter is created.

After you have created all the output mappings required, click the <img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-27.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=062ade63efdd11afc2fd04a93c28f7dc" alt="Copy response structure button" style={{display:"inline-block",height:"1.5em",verticalAlign:"middle",margin:"0 0.15em"}} width="151" height="20" data-path="images/product/flowforma-connect/flowforma-connect-27.png" /> button to add the response structure to your clipboard.

Go back to your Logic App and click <img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-28.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=86903a3e176f3d5a2c1e4d3f53a99da0" alt="New step button" style={{display:"inline-block",height:"1.5em",verticalAlign:"middle",margin:"0 0.15em"}} width="123" height="38" data-path="images/product/flowforma-connect/flowforma-connect-28.png" />

Select the action you require, in this case **HTTP response**.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-29.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=5d25c4716d74ab04c13fe831abe1bd54" alt="HTTP response action" width="603" height="202" data-path="images/product/flowforma-connect/flowforma-connect-29.png" />

Click it and the editor opens.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-30.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=47fa0d21f1b7867f31cef498e6238fe2" alt="HTTP response editor" width="599" height="183" data-path="images/product/flowforma-connect/flowforma-connect-30.png" />

Copy the Response structure from above into the body section.

<img src="https://mintcdn.com/flowforma/gumTE6P5hwG_CiSR/images/product/flowforma-connect/flowforma-connect-31.png?fit=max&auto=format&n=gumTE6P5hwG_CiSR&q=85&s=e74158f640ae64593fa1dbd073e112d9" alt="Response structure in body section" width="604" height="209" data-path="images/product/flowforma-connect/flowforma-connect-31.png" />
