What would you like to know more about?

Show Page Sections

Power Automate

Power Automate is Microsoft’s low-to-no-code integration platform that enables workflows, automation, and more across a set of known connectors. That means you can leverage the power of the Platform to create automated workflows between the Platform and your favorite apps and services to synchronize files, get notifications, collect data, and more.

Note: Power Automate is a flexible, dynamic tool that takes the power of the Platform to the next level. Professional Services can help create your Power Automate Connector and initial Flow. The time Professional Services spends on Flow creation is subject to the hourly $110 rate, but once configured, you'll be able to modify the Flow. Want to see Power Automate in action? Check out our MinistrySmart Conference recording called My First Power Automate Flow With MinistryPlatform In One Hour!

Configure MinistryPlatform Connector

Before you get started, set yourself up for success by putting a few things into place:

  • Obtain your Power Automate License. Licenses are $15 for each person who will be creating a flow using the same connector, but Microsoft might offer discounted pricing for non-profits.
  • Download the MinistryPlatform.swagger.json file. Feel free to review the related files in Github.
  • Open MinistryPlatform and navigate to the Administration section.
  • Open a GUID Generator in a separate tab, and generate a GUID.
  • Open Power Automate in a separate tab.
  • Confirm your license gives you the access you need:
    • Click the gear icon at the top right to open the Settings menu, then select View My Licenses.
    • Most of the items under Capabilities should have a green check mark next to them.
    • Make sure that you have access to both Premium connectors and Custom connectors.

In Power Automate

  1. From the left menu, select Custom Connectors. (You may need to click More to see this option.)
  2. At the top right, click New custom connector, and select Import an OpenAPI file.
  3. Enter a Connector name, then click Import and select the MinistryPlatform.swagger.json file you downloaded.
  4. Click Continue.
  5. On the General tab, set the Host URL to your MinistryPlatform base URL.
  6. On the Security tab, add "PowerAutomate" to the Client ID field.
  7. For Client secret, paste in the GUID you created using the GUID Generator.
  8. In the Authorization URL and Token URL fields, replace "qa.ministryplatform.net" with your MinistryPlatform base URL.
  9. Copy the Token URL into the Refresh URL field.
  10. Click Create connector at the top. This populates the Redirect URL field.
  11. Copy the newly created Redirect URL. (You'll add this to the API Client record in the Platform).

In MinistryPlatform

  1. Go to Contacts, and create a new Contact record with the following information:
    • Display Name: PowerAutomate
  2. Go to Administration > Users, open APIUser record, and copy it (and its security roles) to a new User record. Then, enter the following information:
    • User Name: PowerAutomate
    • Display Name: PowerAutomate
    • Password: P0werAutomate!
  3. Go to Administration > API Clients, and create a new API Client with the following information:
    • Display Name: PowerAutomate
    • Client ID: PowerAutomate
    • Client Secret: Paste in the GUID you created using the GUID Generator.
    • Client User: API
    • Authentication Flow: Authorization Code, Implicit, Hybrid, Client Credentials, or resource Owner.
    • Redirect URIs: Paste in the URL you copied from the Redirect URL field.
      Tip: Add a semi-colon to the end of the URI.
    • Leave other fields as-is.

Return to Power Automate

  1. On the Security tab, paste the same GUID you used as the Client Secret in the Platform into the Client Secret field.
  2. Continue through the Definition, API Plugin (preview), and Code tabs, leaving the information as-is.
  3. On the Test tab, click Update connector at the top. This may take a few minutes.
  4. Click + New Connection. You'll see a browser pop-up with the SSO window.
  5. Click Test Operation. If successful, you'll see a green check mark next to the connection you tested.