Power Automate (formerly known as Microsoft Flow) allows you to connect your forms with hundreds of different pre-built systems and activities.
You can implement multi-stage workflows where different logic or integrations are applied, depending on your form data. For example, you may want to pass some of your form data to Sharepoint or Salesforce, or save data to your database, or even send image data to the Azure Blob store. Power Automate also offers the ability to add approvals into your submission flow.
Important Note
- To use the CP connector, a Power Automate license is required as well as an Office 365 subscription. You may find you already have a license with your Office 365 account, or if not you can sign up for a trial or paid account from the Power Automate site.
Instructions
- Navigate to Developer Keys on your CivicOptimize site
- Copy your Power Automate API Key
- Note: If you do not have a Forms API key, you will need to create one
Important Note
It is possible to edit a trigger to be conditionally triggered. To do so, go into the settings and add a trigger condition.
Instructions
- Open the Power Automate site
- Navigate to the Connectors tab and select the CivicPlus Transform connector in the list
- Select the trigger, Triggers when a Form submission occurs, to start your flow
- The first time you select the CivicPlus connector, you’ll be asked to enter the Connection Name (this can be anything), as well as the API Key you copied from your CivicOptimize instance
- Click Create
- Click New Step
- Search for CivicPlus
- Select the Retrieve From Submission Data to get the data your user has submitted
- Note: this action will bring back an object containing both the form definition and the submission data, allowing you to build out your flow from there.
- Fill in the Form ID and Submission ID fields
- Form ID: Search and select the appropriate Form ID
- Submission ID: Search and select the appropriate Submission ID
- Select +New Step
- From Choose an operation select Condition
- Note: This Action will allow you to specify when this Flow should run – only when a specific Optimize form is received by the Flow.
- In the first Choose a value field search for Form Id
- In the second Choose a value field enter the Optimize form ID number
- Note: You can find the form ID by navigating to the form’s Details page within your Optimize account, in the Information box.
- Within the If yes column, select Add an action
- Search for Parse JSON
- Note: The Parse JSON action instructs Power Automate to take your data and turn it into dynamic values you can use in further flows. In order to parse the JSON value, you will need access to the form's JSON Schema.
- In the Content field search for Submission Data
- In the Schema field input your form’s JSON schema.
- Note: The Parse JSON action instructs Power Automate to take your data and turn it into dynamic values you can use in further flows. In order to parse the JSON value, you will need access to the form's JSON Schema.
-
Build out your Flow for your specific use case.
-
Examples:
-
Add a row into a table to send data to an Excel file on SharePoint (database)
-
Send an email (V2) to send an email(s) to specific individuals/groups, or even back to the form submitter if the form collected their email address
-
Create files on SharePoint or OneDrive from form attachments
-
-
- Click Save
You can use Power Automate to capture and create files from Optimize form submissions. Creating the files with Power Automate requires access to SharePoint or OneDrive. These Actions may be created after creating the Flow as detailed in the previous steps.
Form Submission Attachments
- Select +New step
- Search for CivicPlus
- Select Retrieve Form Submission Attachment (preview)
- Select Form Id in the Form ID field
- Search for and select the result that matches Files Element Name: Attachment ID
- Note: After the Attachment ID item is input, Power Automate will show the Retrieve Form Submission Attachment (Preview) action within a new Apply to each action.
- Select Add an action
- Select Create File
- Note: To create the file in SharePoint search for and select the Create file SharePoint action
- Note: To create the file in OneDrive search for and select the Create file OneDrive for Business action
- Complete the fields
- Site Address: Navigate to and select the appropriate SharePoint group
- Folder Path: Navigate to and select your destination folder in the Folder Path field
- File Name: Search for and select the Files Element Name: Item Name
- File Content: Select the Attachment Content
Generate Form Submission PDF
- Select +New step
- Search for CivicPlus
- Select Generate Form Submission PDF (preview)
- Complete the fields
- Form ID: Select the Form ID
- Submission ID: Select the Submission ID
- Select Add an action
- Select Create File
- Note: To create the file in SharePoint search for and select the Create file SharePoint action
- Note: To create the file in OneDrive search for and select the Create file OneDrive for Business action
- Complete the fields
- Site Address: Navigate to and select the appropriate SharePoint group
- Folder Path: Navigate to and select your destination folder in the Folder Path field
- File Name: Search for and select the Files Element Name: Item Name
- File Content: Select the Form Submission PDF Content
Comments
Let us know what was helpful or not helpful about the article.0 comments
Please sign in to leave a comment.