Sharing the SQL Connector

The SQL connector can be used simultaneously by multiple apps or solutions. For example, if the connector already exists for Power Approvals, it can be shared so that Invoice Capture can also use it (and vice versa).

1. Open your browser and go to Power Apps studio.
2. Log in with the Power Approvals service account user (e.g., svc_powerapprovals@mycompany.com).
3. Select the correct environment (as shown below).
   

4. Click on Connections.
5. Open the SQL Server connector menu by clicking (…) and select Share.
   

6. Enter the email address of the account user for the respective service you want to share. E.g., svc_invoices@mycompany.com.
   

7. For the desired email address, set the permission to Can use.
8. Click Save to finalize sharing the connector.