Try our new research platform with insights from 80,000+ expert users
reviewer1294329 - PeerSpot reviewer
Senior Product Manager Data Science at a government with 1,001-5,000 employees
Real User
Comes with many capabilities and phenomenal support, and allows us to trigger a workflow at a certain time or when an event happens
Pros and Cons
  • "Different trigger events were most valuable. You could schedule a process on a recurring basis, at a certain time of day or week, or when something happens, which is huge."
  • "Their connector to Oracle or premium data sets that aren't Microsoft would often fail for me. The information given back about why it failed wasn't always robust to understand how to fix it and why it happened."

What is our primary use case?

We held a hiring event specifically for veterans. All the people who were registering were external to our organization, so we had them fill out a Microsoft form, which then triggered an email, took all their information, and stored it into a SharePoint list. This list fed a Power App, and we were able to:

  • Check members in whenever they arrived.
  • Capture extra details about them.
  • Pass the information onto hiring managers whenever a hiring manager was interested in an individual applicant or somebody who showed up.

In another use case, we used it to track the vaccination status of all employees. There were about 90,000 employees. If they scheduled it, it would trigger reminders whenever an employee's vaccination was coming up.

How has it helped my organization?

We set up a process to monitor Twitter so that whenever specific hashtags that we cared about were used, the whole record of what was tweeted out was captured and stored into a SharePoint list because it was free and easy to analyze as well. That has helped. Event triggers, several different connections, and what you can do with the information once you have it have been very helpful.

We also used it as a one-time solution in a scenario where records were captured in a Power App, and oftentimes, those records, which were almost like medical records, would need to go to another team one at a time. We used Power Automate to capture all the information that was stored in Oracle. From the record, it would put the information into a Word document, convert the Word document to a PDF, and then email the PDF off to the team. All that was done behind the scenes with the user clicking one button. It was great.

What is most valuable?

Different trigger events were most valuable. You could schedule a process on a recurring basis, at a certain time of day or week, or when something happens, which is huge. 

What needs improvement?

Their connector to Oracle or premium data sets that aren't Microsoft would often fail for me. The information given back about why it failed wasn't always robust to understand how to fix it and why it happened.

Sometimes, Power Automate's flow would turn off when it got fired incorrectly or misfired, but we didn't always get a notification of when it was turned off, and that was a problem.

Buyer's Guide
Microsoft Power Automate
May 2025
Learn what your peers think about Microsoft Power Automate. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
856,873 professionals have used our research since 2012.

For how long have I used the solution?

I have been working with this solution since October of 2019.

What do I think about the scalability of the solution?

It can scale. We used it to track vaccinations for 90,000 employees.

How are customer service and support?

I did deal with their tech support, and they were phenomenal. Their support person taught us the whole process of how to take a record, put it into a Word document template that you can customize, turn it into a PDF, and then send that email off. He was phenomenal.

How was the initial setup?

It was straightforward for the most part. Once you do it a couple of times, it becomes more intuitive. There are so many different YouTube videos or resources on Google to be able to figure out how to do something, what are you doing wrong, or how you can work around an issue.

In terms of maintenance, everything that I did was more of a one-off solution. It was me and one other person who would maintain an individual Power Automate statement.

What other advice do I have?

There are so many different capabilities with it. I would advise mapping out your capability, usage, or whatever it is that you want it to do. After that, start to create and go from there.

I would rate it an eight out of 10.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
End User Computing Manager at Actuant
Real User
Comes as part of an E3 license and has great documentation and an active community
Pros and Cons
  • "The initial setup is very simple."
  • "It's not as user-friendly as a solution such as UiPath, which is really easy to use."

What is our primary use case?

We've just started with the solution. 

We are exploring Power Automate and trying to get rid of some of the mundane tasks and we're seeking ways to increase the productivity. We're trying to do the automation on it. 

It's not my day-to-day work; I'm into infrastructure. I'm basically heading the APAC team here in the APAC region. I got a request from a couple of users to get rid of the setup of mundane tasks. 

What is most valuable?

The solution is booming at the moment. They're adding lots of features all of the time. 

The initial setup is very simple.

There's a great community around the product that is very helpful and active.

The solution is free to use if you have a Microsoft E3 license. 

What needs improvement?

Power Automate has a lot to do. What I've seen, for example, is that UiPath seems to be very efficient and you don't need to have any sort of training. With Power Automate, training is needed. You need to know how to work with pretty advanced queries. They need to add more training materials to their offering. 

It's not as user-friendly as a solution such as UiPath, which is really easy to use. 

Creating unattended bots is quite expensive. 

Having the connectors with multiple platforms would be great. They have connectors for SAP, yet they don't have a connector for the Oracle ERP, for example, or Oracle HCM. They should come up with multiple connectors where it would ease integrating with any other tool, rather than having to create a custom connector and trying to integrate with a third-party tool. UiPath offers multiple connectors and it is very useful. It makes our life very simple. On the fly, we should be able to integrate and talk to the other applications directly without struggling.

For how long have I used the solution?

We've been working with the solution for just six months. It's only been half of a year so far. 

How are customer service and support?

The community that surrounds the product is very active and quite helpful. 

How was the initial setup?

The initial setup is very easy. It was very simple. In order to do automation, it is very easy to configure everything. It's also easy to maintain. The only part that is kind of complex, for example, is where you have to get into the website to get the data and try to feed the data into an Excel sheet. That happens if you're trying to automate some complex yet mundane task. That's where it helps to have someone on board that knows what they are doing and understands the solution quite well.

What's my experience with pricing, setup cost, and licensing?

Since we are on E3, we get Power Automate as a free service from Microsoft, for everybody in the organization.

I'm from India and anything that I look at, in terms of pricing, be it UiPath or Power Automate the pricing appears to be on the higher side. That said, we're on the E3 Microsoft license and the price for Power Automate comes along with that, as a part of the subscription. It basically covers the basic functionality of Power Automate. In that sense, it doesn't hurt us too much. However, if I have to go set up an unattended bot, it is very expensive. That's something that for sure that I would like to highlight with Power Automate. If you'd like to go for an unattended bot it's quite expensive.

Which other solutions did I evaluate?

I have looked at other solutions. I was exploring and trying to compare which is the right tool for our environment. I was trying to compare where exactly Microsoft intersects with other services such as UiPath or Automation Anywhere.

We'll likely stay with Power Automate. Power Automate fits our requirements in terms of what we are looking for. If anything is required in terms of the desktop automation that would require us to buy a separate license we may move to something else, however, at this point, we do not really foresee anything that we couldn't do with this product.

What other advice do I have?

I would urge users to stay on top of Microsoft by leveraging the community. They're very cooperative and trying to support us when we ask questions in the community, there'll be somebody who will always jump in and try to help us out. There are multiple forums, apart from the Microsoft community as well. I see multiple websites or blogs where you could find the solution for a question you have. There is a lot of documentation out there.

For working a bit with the solution and comparing it to options such as Automation Anywhere and UiPath, I'd rate the solution at an eight out of ten so far. 

Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Buyer's Guide
Microsoft Power Automate
May 2025
Learn what your peers think about Microsoft Power Automate. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
856,873 professionals have used our research since 2012.
Chargé de mission Transformation & Lean at Otis Elevator Company
Real User
Great for automating and monitoring processes; best when used with other Microsoft solutions
Pros and Cons
  • "We have a good overview of our processes now thanks to Power Automate."
  • "The integration of our system into Power Automate was a bit tricky. We had to put a data lake in place before automating anything because we were not very structured in terms of data. Our major issue was cleaning up the data."

What is our primary use case?

We use Microsoft's Power Automate in two major fields. Our first use case is reducing the time it takes a user to repeat a task, like, for example, rewriting some physical information in our system. We used Power Automate to extract information from physical documents and to digitalize them. We also use it to put these documents in the correct system as soon as we receive them. We are using a robot agent to do that now for our finance department, for example. 

Our other use case with Power Automate is system reconfiguration. Before, users had to manually reconfigure the software to configure our project. When we had a major update, for example, we have to change it manually with the data for the software. Now we have a process for automatically changing that data.

What is most valuable?

We choose Power Automate because it allows us to monitor our process and know where we can gain some time. We have a cockpit that shows us all the workflow for all automated tasks in place. We have a good overview of our processes now thanks to Power Automate. This is cool because previously we organized our processes on either paper or in a Word document. This was not really an accurate reflection of the tasks taking place. Now, we can have an interactive mapping of our processes.

What needs improvement?

There is room for improvement in the collaboration between the digital team and the business partners because Power Automate is not an easy tool to use. Our business partner does not have a clue about how to use Power Automate so it would be great to have an easy user interface that business partners can understand.

There are a few limitations to the tool. For example, you can't have 100,000 interactions in an hour. I would like to see that worked out. 

It would also be good if Microsoft contacted customers directly about building their own connectors. 

For how long have I used the solution?

We have been testing the solution since last summer, I think. We have just two solutions in production.

What do I think about the stability of the solution?

For now, it has been a good solution for us in terms of stability, but we don't know yet whether we will have mass production and who will use a lot of interactions per hour.

How are customer service and support?

We have not had any direct interactions with their tech support. We use their forum mostly. Microsoft has a good community.

How was the initial setup?

We ran into issues during the setup because our system is not entirely on the cloud or on major solutions. So we had a lot of information in a system we made. The integration of our system into Power Automate was a bit tricky. We had to put a data lake in place before automating anything because we were not very structured in terms of data. Our major issue was cleaning up the data.

What's my experience with pricing, setup cost, and licensing?

We choose 10 premium licenses for our digital team. We do not have a license for everyone in the organization. That's why it would be good to have a free view-only interface for stakeholders. They don't need a premium license because they will never use it to build anything but they needed insight into what is going on to relay the information forward to other stakeholders or clients. 

I am not managing the pricing, but I think it is pretty standard for solutions of that type. However, there is always room for improvement. 

What other advice do I have?

I would not recommend Power Automate to all organizations because whether or not it will work out for them will depend on a number of factors. If the organization is all in one Microsoft environment or well-connected with the cloud, it can be really good. But, the organization will have quite some costs if in a Google or Amazon environment. 

If an organization uses Power Automate, it is best if they use Power Automate's other tools like Power BI and Power Apps. That's why I think the pricing could be lower as you should be able to get several solutions in a bundle. This should be an option during relicensing, for example. 

Someone using Power Automate should also have a basic understanding of databases, Power Apps, Power BI, and Azure. You have to know the full environment to get the most out of this tool. In other words, training is mandatory.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Head of Digital Transformation at Zaact
Real User
Improves operational efficiency, integrates with all sorts of databases and Microsoft solutions, and is easy to use
Pros and Cons
  • "Workflow management is what clients select the most. It is very intuitive and pretty much drag-and-drop, so we can create escalation, decision flows, and if-else conditions pretty much by dragging and dropping boxes. Even someone who is not technical can develop a workflow for the business."
  • "While working with big data, when we have structured data like logs, we have to work with an ETL tool before manipulating the data and creating the workflows and the forms. This can be improved. Big data support is something that I'd like to be covered a lot."

What is our primary use case?

The most common use is for digitizing Excel forms or Excel spreadsheets. We use Power Automate to digitalize all Excel-based processes on a SharePoint page and link the libraries with the transactional data from the client.

It is cloud-based. It can be deployed on a public, private, or hybrid cloud. It depends on the client. It is linked with the Microsoft license that a client has. If the license is hybrid, then Automate is hybrid as well.

How has it helped my organization?

By digitizing Excel spreadsheets, we reduced the errors in information transactions. We also reduced the time for the internal processes and improved operational efficiency.

The cloud solution on Azure makes it easy for us to take care of the security, which is a big deal for us. We can use the same permissions that we already have in place in Azure Active Directory and just duplicate them for the forms in Power Automate and the SharePoint page, so managing security is very easy for us.

What is most valuable?

Workflow management is what clients select the most. It is very intuitive and pretty much drag-and-drop, so we can create escalation, decision flows, and if-else conditions pretty much by dragging and dropping boxes. Even someone who is not technical can develop a workflow for the business.

It is very easy to use. It doesn't need a technical resource to create and maintain forms. The UX/UI is very similar throughout the Microsoft platform, including SharePoint and Office 365

It integrates with all sorts of databases, such as SQL Server and Oracle Database, which is a plus. 

What needs improvement?

While working with non-structured data (like logs and user tracking information that usually fits the criteria of big data), all the data sources must pass by a data quality process via any ETL tool before linking and publishing any information to the automation workflows and forms. This process is important to standardize all the content and format types for the columns and fields in the tables that will be used to show data in the front end.

 The ability to read non-structured data and provide insights into how to sanitize and organize data automatically is something that I'd like to be covered in the next releases.

For how long have I used the solution?

I have been using this solution for two and a half years.

What do I think about the stability of the solution?

We never had any downtime, so it is pretty good.

What do I think about the scalability of the solution?

It is very scalable. We are working with hundreds of forms at the same time, and some of our clients have thousands of people working simultaneously on the same form, so it is very scalable.

Most of its users are function-based. They are process leads in their companies. We currently have more than 1,000 users.

It is being used a lot. It is currently our most important tool for team efficiency. We plan to increase its usage in the near future. We have lots of other internal applications and processes in the pipeline, especially for functional areas, which can be moved from paper and Excel to a SharePoint form by using Power Automate.

How are customer service and technical support?

The response time depends on your license level. If you are a gold partner, the response time is in a couple of hours, which is pretty decent. If you are an individual user or a company that doesn't have any L1, L2, or L3 licenses, the response time is up to 48 hours. So, it all depends on your license level with Microsoft, but whatever they say in the contract, they do respect that, which is good.

We were already users of other Microsoft solutions such as SharePoint and Teams, so when Power Automate became decent for the market users, we just adopted it naturally. Our experience with their technical support was good. They were able to answer our questions and solve our issues within the response time in our contract.

Which solution did I use previously and why did I switch?

I used Blue Prism a couple of years ago, and now I'm using Power Automate. Blue Prism is bigger and way more expensive, and they charge by the number of users. Microsoft was cheaper, and they charge by the number of forms. So, it was way cheaper for us to move to Power Automate from Blue Prism.

How was the initial setup?

It was pretty straightforward. Microsoft had two solutions: Microsoft Flow and Power Apps. Microsoft combined these two solutions and called it Microsoft Power Automate. It is pretty seamless because if you're already using Microsoft licenses, everything integrates with Office 365, SharePoint, and Teams. So, it is very seamless.

It took some days to create the front end of all the forms. Creating a whole page takes a couple of hours for a SharePoint administrator or developer or even a functional person, and we have hundreds of those. It took a few weeks to create the entire front end, but the connections were done in minutes. They were very simple.

What about the implementation team?

It was done in-house. In terms of maintenance, once the forms are created, we have just one full-time employee taking care of the maintenance of those 100 forms, and that's enough because it is pretty much adding or deleting fields. It is pretty simple to maintain.

What's my experience with pricing, setup cost, and licensing?

I don't know the exact number. It depends and varies a lot according to the licensing terms.

There is no cost to maintain if we have less than 10 forms. Microsoft only charges if there are more than 10 forms. So, most of the companies can survive without paying anything extra. It is included in the Office 365 licensing.

What other advice do I have?

I would advise others to first look at the process and then the technology. The biggest issue is that people think that whatever they have in the current system can be digitized and automated, but it is better to first do the roadmap, understand the process from A to B, and then design the flow on paper. After the flow on paper seems okay, then go to the tool and create the form.

I would rate Microsoft Power Automate a nine out of 10. Big data support is something that I'd like to be covered a lot. The other piece that my business needs is already taken care of by the solution. Big data support is the only piece that is missing currently.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
IT Manager at Funtocloud
Real User
Top 20
Helps with an efficient feedback mechanism and has a simple setup process
Pros and Cons
  • "It helps with the feedback mechanism, where we need to determine the relevant team and obtain their email addresses."
  • "More scripting capabilities could be included in Microsoft Power Automate."

What needs improvement?

More scripting capabilities could be included in Microsoft Power Automate.

What do I think about the stability of the solution?

The product could be more stable. I rate the stability as seven out of ten.

What do I think about the scalability of the solution?

I rate the platform's scalability an eight out of ten.

How are customer service and support?

There needs to be direct contact for the technical support team. The users need to submit a maintenance request and then wait for a callback or update from the support team.

How would you rate customer service and support?

Neutral

How was the initial setup?

The initial setup process was relatively simple, with additional modules that could be imported during the setup.

Only some individuals typically handle maintenance, as Microsoft automatically manages most updates. Additional maintenance tasks are required only when necessary, such as for critical updates or multi-case scenarios.

What's my experience with pricing, setup cost, and licensing?

The platform is averagely priced. I rate the pricing a five out of ten.

What other advice do I have?

I have used Microsoft Power Automate to develop mobile apps and other applications. Additionally, we have implemented workflows and automated solutions for various processes.

It helps with the feedback mechanism, where we need to determine the relevant team and obtain their email addresses.

Microsoft could enhance the learning experience by offering more video resources.

I rate it a nine out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Head of business transformation and digitalization at Apple
MSP
Very reliable, very easy to use, and can be integrated with different platforms
Pros and Cons
  • "The product is very reliable and very easy to use."
  • "The product should improve its RPA capabilities."

What is our primary use case?

We use the solution for dashboard reporting, RPA, and account management.

How has it helped my organization?

The product has helped us with support generation. We supported a client who required 42 hours of manual work every month. The solution enabled us to automate the process and save time.

What is most valuable?

The solution is integrated with Microsoft. It can be integrated with different platforms. The product is very reliable and very easy to use. Anyone can learn to use it.

What needs improvement?

The product should improve its RPA capabilities.

The product should add AI capabilities.

For how long have I used the solution?

I have been using this solution for four to five years.

What do I think about the stability of the solution?

I rate the solution’s stability a nine out of ten.

What do I think about the scalability of the solution?

I rate the solution’s scalability an eight out of ten.

How was the initial setup?

The initial setup is easy. I rate the ease of setup a nine out of ten.

What about the implementation team?

The time taken for deployment depends on the project. A small project would take a week to deploy. RPA, on the other hand, takes two months.

What other advice do I have?

I use the latest version of the solution. We use the solution daily. People using the solution should maximize their usability to get a good return on investment. Overall, I rate the solution a ten out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Khshsh Khhdh - PeerSpot reviewer
Associate Director at MIT ESP
Real User
Top 10
Reasonably priced and great for creating attended or unattended bots
Pros and Cons
  • "It makes work easier."
  • "Sometimes there are issues with security policies within the company. Some parts get blacked. There are some drawbacks when we use it connected to the cloud. We need to convince clients to open some parts. This is often an issue that originates from the company itself, not Power Automate."

What is our primary use case?

We help clients integrate Power Automate into their processes. 

What is most valuable?

The solution is great for attended or unattended bots. It makes work easier. 

Most clients that use Office 365 find it very easy to use this solution. There are lots of great integration points. It can connect with various Mircosoft products, like Microsoft Dynamics ERP.

It allows clients to existing in one main environment, which is quite useful. 

The setup is very easy.

What needs improvement?

We use the connector to the cloud, and we have noted that sometimes there are delays. We've seen some scenarios hang. Sometimes there are issues with security policies within the company. Some parts get blacked. There are some drawbacks when we use it connected to the cloud. We need to convince clients to open some parts. This is often an issue that originates from the company itself, not Power Automate

Sometimes when we work with Microsoft Excel, the process is not much faster. The automation doesn't speed up as much as we would hope as they go through cells one by one. If it is a time-sensitive activity, that might be an issue and should be improved. 

For how long have I used the solution?

I've been using the solution for two years. 

What do I think about the stability of the solution?

It is a stable solution. I'd rate the stability seven out of ten. The issue is that there are some security policies from the company side, or sometimes some updates that happen that can slow things down or stop the process altogether. 

What do I think about the scalability of the solution?

The solution can scale well. I'd rate it seven out of ten. If a product is on a particular machine, if we want to scale up, we need to use another machine or account. 

The product can work for any type of company, from small to large. 

How are customer service and support?

We've contacted technical support in the past, and it has been very good. We haven't had any issues with support and are happy with the level of service. 

Which solution did I use previously and why did I switch?

I also use UiPath as well. We use either or, depending on the client or the requirement.

The main difference is the price. Microsoft is cheaper than UiPath.

The AI capabilities for Microsoft are very good. With UiPath, sometimes you even have to use modules from Microsoft. 

How was the initial setup?

The initial setup is very simple. It is simple. It's similar to other tools.

What about the implementation team?

We can help implement the solution for clients. 

What's my experience with pricing, setup cost, and licensing?

The pricing is reasonable. I'd rate the affordability eight out of ten.

What other advice do I have?

I'd rate the solution eight out of ten. We've been pretty happy with its capabilities. 

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
IT consultant at Secoptrial
Real User
Helps to process documents without spending much time on them
Pros and Cons
  • "From my personal experience of using Microsoft Power Automate, I think that the automatic document processing feature is helpful for many organizations in streamlining administrative processes. It is a very good feature. It has helped many enterprises to process documents without spending much time on them."
  • "I would recommend removing the AI Builder feature from the automatic document processing functionality. The tool can serve even better with free automatic document processing features, it shouldn’t only be available in the trial version."

What is our primary use case?

The primary use case for this solution includes automating process work with optical character recognition. Companies can also automate document processing with Microsoft Power Automate.

How has it helped my organization?

From my personal experience of using Microsoft Power Automate, I think that the automatic document processing feature is helpful for many organizations in streamlining administrative processes. It is a very good feature. It has helped many enterprises to process documents without spending much time on them.

What needs improvement?

I would recommend removing the AI Builder feature from the automatic document processing functionality. The tool can serve even better with free automatic document processing features, it shouldn’t only be available in the trial version.

For how long have I used the solution?

I have been using this solution for a couple of months now.

What do I think about the stability of the solution?

I have found Microsoft Power Automate to be a stable solution.

What do I think about the scalability of the solution?

It is a scalable solution but I also think that the scalability of this solution depends on the type of organizations that are using it. For instance, public enterprises like government organizations can make very good use of this solution. I plan to propose the tool to my organization. It’s still in the loading phase and I have not got any feedback on it.

How are customer service and support?

I have not felt the need to contact the customer service and support team since most of my doubts were resolved through the tutorials and tech instructions available on the website, which are very helpful.

Which solution did I use previously and why did I switch?

I have previously used Power BI. I came across Power Automate while looking for other Power platforms. I saw the different features that Power Automate offers and so I chose it.

How was the initial setup?

It was easy to set up. Once you have access to the portal, navigate to the automatic document processing feature where you can see many examples. There are a total of just two or three steps that you need to follow for completing the entire setup process.

The setup took a couple of months. It requires much concentration like when you are training your model to analyze the documents. For example, when you are setting up the automatic process document, the tool will ask you to try with five documents. Also, we will have to look into the different fields from which we are going to extract the information from the documents.

Once the document upload is done and the training is finished, you will need to locate the locations where other documents are located. It’s recommended to use either the OneDrive or Sharepoint locations. Power Automate will locate the schema of the document, connect with it and the document upload will be done. When the upload is done, the AI Builder will apply the OCR. After the completion of the OCR, the information will be extracted and put on other documents like Excel. 

What's my experience with pricing, setup cost, and licensing?

I am not sure about the setup cost, pricing or licensing since I use the trial version.

What other advice do I have?

I would rate this tool a nine out of ten. 

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Microsoft Power Automate Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2025
Buyer's Guide
Download our free Microsoft Power Automate Report and get advice and tips from experienced pros sharing their opinions.