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.
To get started, simply select the OneBlink connector from the available integrations and get creating! Or if you’d like a little more detail, we’ll dig deeper below.
To use the CP connector, you’ll need a premium Power Automate account — 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 their site.
Once you have your account, you’ll be able to find the CP connector in the Power Automate connector list.
To use the connector, you’ll need your API key from the CP Console.
Getting Your API Key
Your API Key is available from within your console.
In the Advanced section, select Developer Keys. This page shows you all the API keys you have available to you.
If you don’t yet have a Forms API key, simply add a new one by selecting the Plus button in the bottom right of the screen. When creating a new key, give it a name that makes sense to you, and then select the Forms privilege.
You should now see a card with your Forms API keys listed including your Power Automate API Key. You’ll need this when you first set up your OneBlink connector in Power Automate.
Creating a Flow
If you haven’t used Power Automate before, the best place to get started is to log into your Power Automate account and select Learn from the side menu. Microsoft has created a lot of great tutorials from beginners to advanced.
Once you’re familiar with Power Automate, there are a couple of pointers below that will help you get up and running as quickly as possible:
Create a Trigger
Select the trigger that runs when a form is submitted Triggers when a Form submission occurs. This is the trigger that will start your flow.
The first time you select the OneBlink connector, you’ll be asked to enter the name of your connection (this can be anything), as well as enter the API Key from the console.
Add an Action
The trigger doesn’t contain all of your form data. To get the data your user has submitted, you can use the Retrieve OneBlink Form Submission Data action.
- Note: There are dynamic values for both Form ID and Submission ID available to you.
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.
The next stage of the flow is completely up to you. However, in most cases, you will probably want to use the Parse JSON connector to take your data and turn them into dynamic values you can use in further flows.
In order to parse the JSON value, you will need access to the form JSON Schema.
The easiest way to get the JSON schema is to navigate to the forms menu and select the side menu of the form. This will give you the option to "View Schema".
From here you can copy the schema to your clipboard and paste it in the Parse JSON connector. See below:
The Content for the Parse JSON connector will need to be 'Submission Data'.
Microsoft has released an Approvals connector that will allow you to add an approval step to your submission.
This means when a user submits a form, an approval must happen before your flow is completed.
Approvals can be handled both via email and the Power Automate app, depending on what best suits your needs.
This is a feature offered directly from Microsoft and may solve a lot of your approval needs without having to use a more complex workflow solution.