Power Automate Integration

What is the Power Automate Integration?

Power Automate (formerly Microsoft Flow) is Microsoft's automation platform built into the Microsoft 365 suite. It's the ideal choice if your organization already uses Microsoft products like Teams, SharePoint, Outlook, or Dynamics 365.

Our native Power Automate connector brings all 100+ APIVerve APIs into your flows with dynamic inputs. Select any API and Power Automate automatically displays the correct input fields. This seamless integration means you can add API capabilities to your existing Microsoft workflows without switching platforms.

Power Automate excels at enterprise scenarios - trigger flows from Teams messages, process data from SharePoint lists, send results to Outlook, or update Dynamics 365 records. The deep Microsoft integration makes these connections effortless.

Before You Start

To use APIVerve with Power Automate, you'll need:

• An APIVerve account with an active subscription (Starter, Pro, or Mega)
• A Microsoft 365 account with Power Automate access

Power Automate is included with most Microsoft 365 business plans. If you don't have access, check with your IT administrator or sign up for a standalone Power Automate license.

Getting the Custom Connector

The APIVerve Power Automate integration uses a custom connector that needs to be installed in your Power Automate environment. Contact us to receive the solution package containing the custom connector.

What You'll Receive

• Power Automate solution ZIP file with the custom connector
• Installation instructions for your environment
• Configuration guidance for your organization

Connecting APIVerve to Power Automate

Once the custom connector is installed, creating flows with APIVerve is straightforward. Power Automate uses a familiar interface if you've used other Microsoft products.

Step 1: Create a New Flow

Open Power Automate and click "Create" in the left sidebar. You can start from scratch with an "Instant cloud flow" (manual trigger), "Automated cloud flow" (automatic trigger), or "Scheduled cloud flow" (time-based trigger).

Step 2: Choose Your Trigger

Select what will start your flow. Popular triggers for API workflows include:

• When a new email arrives in Outlook
• When an item is created in SharePoint
• When a message is posted in Teams
• On a recurring schedule
• When an HTTP request is received (webhook)

Step 3: Add the APIVerve Action

Click "New step" and search for "APIVerve" in the connector search. The custom connector will appear in your available connectors after installation.

Step 4: Sign In with OAuth

The first time you use APIVerve, you'll be prompted to sign in. Click "Sign in" and you'll be redirected to the APIVerve login page. Authenticate with your APIVerve credentials and authorize the connection. Power Automate will securely store the connection for future use.

Step 5: Select Your API and Configure

Once connected, you'll see a dropdown with all available APIs. Select the API you need and Power Automate will display the input fields for that specific API. Use dynamic content from previous steps to populate the fields - for example, using an email address from an Outlook trigger as input for the Email Validator API.

Step 6: Use the Output

After the APIVerve action runs, you can use its output in subsequent steps. Add more actions to send the results to Teams, update a SharePoint list, compose an email, or store data in Dataverse.

Step 7: Test and Enable

Click "Test" in the top right to run your flow with test data. Review the run history to verify each step executed correctly. When satisfied, save your flow and it will run automatically based on your trigger.

Popular Use Cases

Teams Notifications with Data Enrichment

When a new lead fills out a form on your website, use the IP Lookup API to determine their location, then post a rich notification to your sales channel in Teams with the lead details and location information. Your sales team gets instant, enriched alerts.

SharePoint Document Processing

Automatically process documents uploaded to SharePoint. When a new file is added, use APIVerve's text extraction or OCR APIs to extract content, then store the extracted data in a SharePoint list or update document metadata for easy searching.

Outlook Email Validation

Before adding new contacts from emails to your CRM, validate their email addresses. Trigger a flow when you receive emails from unknown senders, validate the address with the Email Validator API, and only create CRM records for valid, deliverable emails.

Scheduled Data Reports

Build automated reporting workflows. On a daily or weekly schedule, fetch data from your systems, process it with relevant APIVerve APIs (currency conversion, data validation, etc.), then compile results into an Excel file in OneDrive or email a summary to stakeholders.

Tips for Success

• Use expressions - Power Automate's expression language lets you transform data before sending to APIs
• Add error handling - Use "Configure run after" settings to handle API failures gracefully
• Leverage environment variables - Store configuration in solutions for easier management across environments
• Monitor with analytics - Use Power Automate's built-in analytics to track flow performance
• Consider Premium connectors - The APIVerve connector is a Premium connector, requiring appropriate licensing

Troubleshooting

Connection Failed

If you can't connect to APIVerve, ensure your APIVerve subscription is active and you have a paid plan. Try removing the existing connection from Data → Connections and creating a fresh one. Also verify your browser isn't blocking pop-ups during the OAuth flow.

Flow Failures

Check the run history for detailed error information. Common issues include missing required fields, incorrect data formats, or token exhaustion. Power Automate shows the exact input and output for each step, making debugging straightforward.

Premium Connector Access

APIVerve is a Premium connector in Power Automate. If you see licensing errors, check with your Microsoft 365 administrator to ensure your account has access to Premium connectors, or consider a standalone Power Automate Premium license.

Additional Resources

• Contact Us - Request the custom connector package
• Integration Overview - More details on the main site
• API Reference - Explore all available APIs
• Rate Limits - Understand usage limits by plan