Manage connections in Power Automate

Power Automate uses connections to make it easy for you to access your data while building flows. Power Automate includes commonly used connections, including SharePoint, SQL Server, Microsoft 365, OneDrive for Business, Salesforce, Excel, Dropbox, Twitter, and more. Connections are shared with Power Apps, so when you create a connection in one service, the connection shows up in the other service.

Here's a quick video on managing connections.

You can use connections to perform these tasks:

  • Update a SharePoint list.
  • Get data from an Excel workbook in your OneDrive for Business or Dropbox account.
  • Send email in Microsoft 365.
  • Send a tweet.

You can create a connection in multiple scenarios, including:

Tip

For detailed information about using SharePoint with Power Automate, see the SharePoint documentation.

Add a connection

  1. In Power Automate, sign in with your work or organization account.

  2. On the left pane, select Data > Connections.

    Screenshot showing the Connections option.

  3. At the top of the page, select New connection.

  4. In the list of available connections, choose the connection that you want to set up (such as SharePoint) by selecting the plus sign (+).

    List of connections that can be configured.

  5. To find a particular connection option, enter the connector name into the search box that's located in the top right corner of the page, below the settings and help buttons.

  6. Follow the steps to enter your credentials to configure the connection.

    Tip

    You can find all the connections that you've created under Data > Connections.

Connect to your data through an on-premises data gateway

Some connectors, such as the SharePoint connector, support the on-premises data gateway. To create a connection that uses a gateway:

  1. Follow the steps earlier in this topic to add a connection.

  2. In the list of available connections, select SharePoint.

  3. Select the Connect using on-premises data gateway option.

    Select the on-premises option.

  4. Provide the connection's credentials, and then select the gateway that you want to use. More information: Manage gateways and Understand gateways

Note

After the connection is configured, it's listed in Connections.

Delete a connection

  1. Go to DataConnections, and select the connection that you want to delete.

  2. Select to view more commands, and then select Delete.

    Select Delete to delete the connection.

  3. Select Delete to confirm that you would like to delete the connection.

    Delete connection confirmation.

When you delete a connection, it's removed from both Power Apps and Power Automate.

Update a connection

You can update a connection that isn't working because your account details or your password changed.

  1. Go to DataConnections, and then select the Fix connection link for the connection that you want to update.

    Select the link to fix the connection.

  2. When prompted, update your connection with new credentials.

When you update a connection, it's updated for both Power Apps and Power Automate.

Find which apps and flows use a connection

You can identify the apps and flows that use a connection to understand how the connection is used.

  1. Go to DataConnections, and then select the connection that you want to learn more about.

  2. Select to view more commands, and then select Details to see the details for the connections, including the status and the date it was created.

  3. To view apps that use the connection, select Apps using this connection.

  4. To view flows that use the connection, select Flows using this connection.

Troubleshoot connections

Connection ownership by a different account

Per the policies in your organization, you might need to use the same account to sign in to Power Automate and to create a connection to SharePoint, Microsoft 365, or OneDrive for Business, for example.

For example, you might sign in to Power Automate with yourname@outlook.com but receive an error when you try to connect to SharePoint with yourname@contoso.com. You can instead sign in to Power Automate with yourname@contoso.com and you'll be able to connect to SharePoint.

Deprecation of the Power Automate Management connector's third-party authentication option

The Power Automate Management connector authentication option of third party was deprecated in June 2020 and will no longer work after October 1, 2022.

Follow these steps to replace third party authentication connections.

  1. Find the third party authentication connection you want to replace, and then delete it.
  2. Create a "first party authentication" connection.
  3. Add the new connection on the flows that need it.

Find Power Automate Management connections as an admin

If you are an admin, you can find these problematic connections using a repeatable pattern that can be automated in a flow with the help of some admin connectors:

  1. Find the environments using List environments as admin.
  2. Find the connections in those environments using Get Connections as admin.
  3. Find the connections to be replaced with id="shared_flowmanagement" and properties.connectionParametersSet.name="thirdParty" using a Parse JSON action with conditions .
  4. Then finally, get the connection details, including the connection display name and the creator who should replace the connection.

After you have that list of connections, contact the connection owners to let them know that the connections should be replaced.

Find Power Automate Management connections as a user

If you are a non-admin user, you can find your Power Automate Management connections and learn about the apps and flows that use each connection before replacement.

If you don't know what authentication option was used on the Power Automate Management connection, you could create a flow and use the List my connections action to see the advanced connection metadata, or delete the existing connection and replace it with a new connection using the Authentication Type of First Party.

Deprecation of the Power Automate Management connector's legacy default authentication option

The default authentication option was also deprecated in June 2020, however, it was immediately hidden so that it couldn't be used from that date. All connections with the authentication of default were created prior to June 2020. Those connections should also be replaced. If you use the Get Connections as admin action, those connections will have id="shared_flowmanagement" and properties.connectionParametersSet.name="".