Item: Microsoft Power Automate
Rating: 6
Author: Verified User

Overall Satisfaction with Microsoft Power Automate

Use Cases and Deployment Scope

Microsoft Flow is only being used by a small group of people in a department. It helped to query Azure AD groups members using SharePoint online list.

Pros and Cons

Pros

Flow has quick and easy approval workflow for SharePoint online.
Has many actions easily available to complete the task that would take you days/weeks to build custom.

Cons

Needs a better History log.
Workflow settings should have conditions to start the workflow, rather than only starting on "created" or "modified."
It is good, but not really finished for productive applications.
You can’t include the content of multiline text in emails you send out in the Flow, null value is returned.
Person field that allows multiple selections. Instead of not seeing the field or a nice message, it simply returns a null value.

Most Important Features

Sends email
Query DB

Return on Investment

With Microsoft Flow, you can connect to many data sources such as DocuSign, Dropbox, Facebook, Google Drive, Google Sheets, Office 365, OneDrive, Salesforce, Slack, SQL Server, and Twitter.
Templates are often useful for automating many common business workflows, but you can easily create your own as well.
Negative - Not all column types are supported by Flow.

Implementation Rating

Alternatives Considered

Nintex Platform

We had a requirement to get all members of an AD group from Azure AD into SharePoint online list which Nintex Workflow for O365 can't do it and we chose Microsoft Flow to perform that action.