Microsoft Power Automate is a cloud-based service that makes it easy for line-of-business users to build workflows that automate time-consuming business tasks and processes across applications and services. Using Microsoft Power Automate, you can connect your Cognito Forms to a ton of different services; including OneDrive, Outlook 365, Dropbox, Gmail, and more!
- Flow – A flow is the connection between two applications (ex: Cognito Forms and Google Drive).
- Condition – Specify that a flow performs one or more tasks only if a particular condition is true.
A trigger is the event that starts a flow. For example, if you wanted to create a new subscriber in MailChimp whenever a new form is submitted, the new form entry is the Trigger. Cognito Forms triggers include:
- New Entry – Triggers when an entry moves from Incomplete to another status.
- Update Entry – Triggers when someone updates an entry (excluding entries with a status of Incomplete, such as entries that have not yet been submitted, or entries saved via Save and Resume).
- Entry Deleted – Triggers when an entry is deleted from your form. This notification contains all relevant entry data, excluding file links and entry links.
An action is the event a flow performs. For example, when a form is submitted, a new subscriber being added in MailChimp is the action. Or, you can perform actions in Cognito Forms:
- Create Entry – Creates a new form entry. This entry will be assigned the subsequent status following Incomplete.
- Update Entry – Updates an existing form entry.
- Set Form Availability – Sets the availability of a form.
- Get Document – Retrieves documents generated by Cognito Forms, such as custom documents and free standard documents.
- Get File – Retrieves files that have been uploaded to your forms via the File Upload field.
In relation to Workflow actions, integrations will trigger after a status change has taken place.
When you send file attachments (such as uploaded files and generated documents), Microsoft Power Automate restricts the total size of file attachments to 50MB. Select your documents from the list of Dynamic content:
You cannot target field list data that is nested inside another list. For example, you cannot target data from a repeating section inside of another repeating section, or a file upload field inside of a repeating section.
When targeting an uploaded file on a form with more than one File Upload field, you will need to first specify File as your dynamic content:
Then, you can specify the File Upload field on your form that you want to target:
Microsoft Power Automate supports up to 1,024 dynamic content fields. When this limit is reached, you will see a “No dynamic content available” message.
Using Microsoft Power Automate to create a new entry in Cognito Forms will trigger any notifications enabled on the form (including email notifications) to be sent.
Check out our Microsoft Power Automate blog series for in-depth tutorials about integrating your forms with other services:
- Use repeating data to create entries in another form
- Receive push notifications with Microsoft Power Automate
Creating a flow
To get started, you’ll need to sign up for a Microsoft Power Automate account. Or, if you already have an account with Microsoft, you can directly sign in on your tablet, your desktop computer, or even your phone.
Once you sign in:
Select My flows in the top navigation bar, and then select Create from blank.
Search for Cognito Forms in the services list and then select a trigger.
Log in to your Cognito Forms account and authorize access to your organization.
With your organization now connected, you can select a form.
Select New step, followed by Add an action.
You’ll be prompted to select a service, an action, and to connect your account. When you’re finished, select Create flow.
In My flows, you can view, edit, and update all of your flows in one place.
Not sure where to start? We built a variety of pre-built templates to choose from.