What an excellent tool
December 04, 2023

What an excellent tool

Naseem Ahmad | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Software Version

Other

Modules Used

  • AI Builder
  • Power Automate Cloud

Overall Satisfaction with Microsoft Power Automate

Following are some of the business problems,
1. Collecting site engineers daily time detail and pushing that detail to PeopleSoft (ERP)
2. Weekly cross ERP data reading, Creating reconciliation report, and pushing this report to Power BI
3. Reading daily unapplied cash items from ERP systems, Pushing them to the SharePoint list, and Sending push notifications to business teams to give the details
4. Many others
  • API Interaction
  • UI Automation
  • MS 365 tools interaction
  • Reading, and sending outlook emails
  • Dealing with bulky json response: There should be an inbuild json explorer so that Power Automate itself can parse the json response responded by Power Automate flow so that developer could easily digest the json
  • Test logs action activity: There is no activity that can print log messages.
  • Way to comment out an activity: Currently there is no way to comment out an activity. There should be a way to do so.
  • SharePoint cloud interaction
  • Outlook Interaction
  • AI Builder
  • DataFlow (Power Query)
  • High return on investment when we compare it with other automation tools we have such as UiPath
  • Quick Developement and Production: Because it is low code no code solution which is always quick to build automation
  • Developement Time savings: Because we have trained our business users to build automation workflow by themselves which gave them capability to build the automation flows by themselves
It was quite tough to migrate the solution from any tool such as UiPath to Power Automate
We have used AI Builder to its max to convert our historical data from unstructured format to structured format. CBRE's automation capability touched the high due to AI Builder capability.
  1. Power Automate beats UiPath basically from a costing perspective. I prefer Power Automate over UiPath because of its different costing segments that make it way cheaper than UiPath.
  2. Smartsheet provides a number of functions when it comes to dealing with and showcasing tabular data, but Sharepoint Lists along with Power Automate becomes a strong candidate for dealing with tabular data.

Do you think Microsoft Power Automate delivers good value for the price?

Yes

Are you happy with Microsoft Power Automate's feature set?

Yes

Did Microsoft Power Automate live up to sales and marketing promises?

Yes

Did implementation of Microsoft Power Automate go as expected?

Yes

Would you buy Microsoft Power Automate again?

Yes

Best suited,
1. Power Automate is excellent for automating business processes on MS 365 tools such as Outlook, SharePoint, Excel etc
2. To interact with the other tools that support REST API interaction.
3. Excellent to create/train/use ML models

Less appropriate,
1. To process big data, Because it is processing data in the form of json, which has some fundamental limitations when it comes to big data