Microsoft Power Platform

Microsoft Power Automate –
what is it and how does it work?

What is Microsoft Power Automate?

Microsoft Power Automate (previously known as Microsoft Flow) is a cloud-based
service that is included within the suite of Microsoft Power Platform products. It allows users to build workflows that automate time-consuming business processes and tasks across their favourite applications and services, ensuring consistency and data integrity.

Ask our experts about Power Automate

First Name*
Last Name
Your Message*
Tick the box if you would like to receive additional Strategy 365 email updates
Please see our Privacy Policy and Data Protection Policy for information on how we use your data

How does Power Automate work?

Previously, automating business processes required programming, but thanks to over 400 Power Automate Connectors to Microsoft services such as SharePoint, Dynamics 365 and Outlook, plus external connectors such as Adobe Sign, Asana, Dropbox and Stripe, as well as the ability to connect to web-based APIs, users can now integrate multiple services.

By automating your business processes, you can ensure that steps are carried out in a predefined manner to ensure data consistency and save time. You can do this by creating a ‘flow’, which is the term for a set of automations, to allow your favourite apps and services to synchronise files, get notifications, collect data, integrate with external systems, and more.

How do Power Automate flows work?

A flow will always have one trigger and that trigger can be linked to multiple actions. The trigger is the event which begins the flow, and the actions are what you want the flow to do once the trigger happens.

For example, you could create a Cloud Flow that notifies you by email when someone sends a tweet that contains a keyword you specify. In this example, the tweet is the trigger, and sending an email is the action.

To get started, you can even choose from a selection of prebuilt Power Automate templates which best fit your scenario. Search all templates or browse by category, and then follow the steps to create a Cloud Flow from it. You can always add, edit, or remove triggers and actions to make it your own.



Take a look at this Power Automate video overview from Microsoft below.

Benefits of Microsoft Power Automate


With over 400 connectors to popular services such as SharePoint, Dynamics 365 and Outlook, you can be sure that all of your integration needs are covered.


A vast array of pre-built templates for common tasks saves you time in building your own Flows but also provides inspiration for further ways of improving your business processes.


Power Automate comes complete with an Approvals system, enabling both internal and external users to quickly and easily approve records from anywhere.

Access On-Premise Data

If your business has yet to fully move to the cloud, you can still utilise the power of Power Automate to integrate your on-premise data with online services.


Ensure that processes are only followed when certain conditions are met with Power Automate’s powerful condition logic.

Data Security

With Power Automate, you can help to prevent sensitive data leaving your business with built-in or customised data loss prevention policies.

What makes Microsoft Power Automate special?

Since it falls under the Microsoft banner, Power Automate is the perfect business process automation solution because it integrates seamlessly with all the Microsoft apps that your business already uses every day.

Microsoft’s relationships with multiple industry partners means those partners can create integration solutions themselves, rather than making more work for IT decision-makers, who can then focus on more sophisticated integration tools.

Power Automate provides you with a secure connection with local data and
cloud-based services

Other components of the Power Platform


What Microsoft Power Automate can do

You can use Power Automate with Excel by creating a form using Microsoft Forms, and an Excel document with a spreadsheet where you'd like the information to be stored. You'd then set up a flow in Power Automate which sends the form out upon a trigger and automatically enters the information into the spreadsheet – then sends an email to let someone know the entry has been completed.
Power Automate and DocuSign also work well together, so you could set up a trigger when a tender or customer status is changed in a SharePoint list to automatically send an approved contract out for signature.
Power Automate and Microsoft Teams can be used to notify a team when a new form response is submitted, or to create a sales opportunity from a chat.
Power Automate and Microsoft Forms can be used to send an email to a form responder after they submit a response, get an attachment from a form and send an email with the attachment, and more.

Microsoft Power Automate Pricing

Premium Plan

Per user, per month
Allows a user to run unlimited flows (within service limits) utilising the full capabilities of Microsoft Power Automate, including attended Robotic Process Automation (RPA) in attended mode.
Enquire Now

Per Process Plan

Per month
Includes digital process automation (cloud flows) and Robotic Process Automation (RPA) in unattended mode. Licensed on a per-flow basis.
Enquire Now

Seeded Plan

Some Dynamics 365 and Microsoft 365 licences include Power Automate access that allows for the running of Flows within the context of the respective licence.
Enquire Now

1. Prices quoted are for annual subscriptions. Monthly subscriptions are available, but incur an additional 20% cost.
2. Microsoft Power Automate capability is included with certain Dynamics 365 Customer Engagement licences when used with Dynamics 365 data.
3. Microsoft Power Automate capability is included with Power Apps licences when used with the same Common Data Service app.
4. Microsoft Power Automate capability is included with Office 365 licences when used in conjunction with Office 365 services.

Power Automate is an extremely powerful tool. We use it in all our projects. To discover how we can help your business take back control of processes and data, while saving time and money, call our Microsoft experts today on 01782 916920 or enquire now.

Enquire Now

Microsoft Power Automate FAQs