add-data-source

1Data sources, connections, and API connectors cannot be added by the coding agent — they must be added through the Power Apps Studio interface. This skill informs the user, guides them to add the connection in their Studio session, verifies it is available via the MCP server, and then continues with any pending work.
2 
3## Phase 0 — Identify the Connection Type
4 
5From the user's request, determine what they want to add and how to verify it:
6 
7| Request type | Verify with |
8|---|---|
9| Data source (SharePoint list, Dataverse table, SQL table, Excel file, OneDrive, etc.) | `list_data_sources` |
10| API / connector (Office 365 Users, Teams, custom connector, etc.) | `list_apis` |
11| Unclear | Both `list_data_sources` and `list_apis` |
12 
13Note what the user is trying to add so you can look for it by name in Phase 3.
14 
15## Phase 1 — Inform the User
16 
17Explain that this step requires action in their Studio session. Tell the user:
18 
19- The coding agent cannot add data sources or connections programmatically — this must be done directly in Power Apps Studio.
20- To add the connection, follow these steps in their open Studio session:
21  1. Open the **Data** panel in the left sidebar
22  2. Click **Add data**
23  3. Search for the data source or connector they want (e.g., "SharePoint", "Dataverse", "SQL Server", "Office 365 Users")
24  4. Follow the authentication prompts and select the specific table, list, file, or dataset
25…