add-data-source

To add a data source in Power Apps Studio, open your Canvas App, navigate to the Data panel, click Add data, select your desired data source or connector, complete the authentication process, and verify the connection is visible to the MCP server.

Data sources, connections, and API connectors cannot be added by the coding agent because they require manual authentication. They must be added through the Power Apps Studio interface so the system can verify the connection is available via the MCP server before continuing.

Yes, you can connect SharePoint, Dataverse, SQL, Excel, OneDrive, Teams, and Office 365 data sources. This process handles both standard data sources and API connectors, requiring you to authenticate and verify the connection in Power Apps Studio.

Verifying an API connector involves adding the connection through Power Apps Studio, completing authentication, and waiting for user confirmation. The system then uses MCP tools like list_apis and describe_api to verify the connection is available before proceeding.

Yes, adding a data source works with Excel, OneDrive, Teams, and Office 365. You must open Power Apps Studio, navigate to Data, click Add data, choose your specific connector, complete the required authentication, and verify the connection.

If your data source connection is not visible, ensure you have completed authentication in Power Apps Studio. The system waits for user confirmation and then verifies availability using MCP tools like list_data_sources and get_data_source_schema before continuing pending work.