Back to Details

add-data-source

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese
Data 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.
数据源、连接和API连接器无法由编码代理添加——必须通过Power Apps Studio界面进行添加。本技能会告知用户相关情况，指导他们在Studio会话中添加连接，通过MCP服务器验证连接是否可用，然后继续处理任何待完成的工作。

Phase 0 — Identify the Connection Type

阶段0 — 确定连接类型

From the user's request, determine what they want to add and how to verify it:
Request typeVerify with
Data source (SharePoint list, Dataverse table, SQL table, Excel file, OneDrive, etc.)
list_data_sources
API / connector (Office 365 Users, Teams, custom connector, etc.)
list_apis
UnclearBoth 
list_data_sources
and 
list_apis
Note what the user is trying to add so you can look for it by name in Phase 3.
根据用户的请求，确定他们想要添加的内容以及验证方式：
请求类型验证工具
数据源（SharePoint列表、Dataverse表、SQL表、Excel文件、OneDrive等）
list_data_sources
API / 连接器（Office 365 Users、Teams、自定义连接器等）
list_apis
不明确同时使用
list_data_sources
和
list_apis
记录用户想要添加的内容，以便在阶段3中按名称查找。

Phase 1 — Inform the User

阶段1 — 告知用户

Explain that this step requires action in their Studio session. Tell the user:
  • The coding agent cannot add data sources or connections programmatically — this must be done directly in Power Apps Studio.
  • To add the connection, follow these steps in their open Studio session:
    1. Open the Data panel in the left sidebar
    2. Click Add data
    3. Search for the data source or connector they want (e.g., "SharePoint", "Dataverse", "SQL Server", "Office 365 Users")
    4. Follow the authentication prompts and select the specific table, list, file, or dataset
  • Once added, the connection will be available to the MCP server and you can continue.
说明此步骤需要在他们的Studio会话中进行操作。告知用户：
  • 编码代理无法通过编程方式添加数据源或连接——必须直接在Power Apps Studio中完成。
  • 要添加连接，请在打开的Studio会话中按照以下步骤操作：
    1. 打开左侧边栏的Data面板
    2. 点击Add data
    3. 搜索他们想要的数据源或连接器（例如："SharePoint"、"Dataverse"、"SQL Server"、"Office 365 Users"）
    4. 按照身份验证提示操作，并选择特定的表、列表、文件或数据集
  • 添加完成后，该连接将对MCP服务器可用，后续即可继续操作。

Phase 2 — Wait for Confirmation

阶段2 — 等待确认

Use 
AskUserQuestion
to pause until the user has completed the steps in Studio:
"Please add the data source or connection in your Power Apps Studio session. Reply here when it's ready and I'll verify the connection before continuing."
Do not proceed until the user confirms they have added it.
使用
AskUserQuestion
暂停操作，直到用户在Studio中完成上述步骤：
"请在您的Power Apps Studio会话中添加数据源或连接。完成后请在此回复，我将先验证连接，然后继续后续操作。"
在用户确认添加完成前，请勿继续下一步。

Phase 3 — Verify the Connection

阶段3 — 验证连接

Once the user confirms, call the appropriate MCP tools to check that the connection is now available:
  • If the request was for a data source: call 
    list_data_sources
  • If the request was for an API / connector: call 
    list_apis
  • If the type was unclear: call both in parallel
Scan the results for the connection the user added:
Found — Confirm to the user that the data source or connection is now visible to the agent. Include the exact name as returned by the MCP tool (this is how it must be referenced in Power Fx formulas). If it is a data source, call 
get_data_source_schema
to retrieve its column names and types, and include the schema summary in your response so it is ready for use in edits. Similarly, for APIs/connectors, call 
describe_api
to retrieve the available endpoints and their parameters, and include the schema summary in your response.
Not found — Inform the user that the connection is not yet visible. Ask them to:
  1. Confirm they completed the Studio steps and the connection appears in the Data panel there.
  2. Check that their Studio session is still active (the MCP server must be connected to a live coauthoring session).
  3. Let you know when ready to try again.
Use 
AskUserQuestion
to wait for their follow-up, then re-run Phase 3.
用户确认后，调用相应的MCP工具检查连接是否已可用：
  • 如果请求是添加数据源：调用
    list_data_sources
  • 如果请求是添加API / 连接器：调用
    list_apis
  • 如果类型不明确：并行调用上述两个工具
在结果中查找用户添加的连接：
找到 — 向用户确认数据源或连接已对代理可见。请包含MCP工具返回的准确名称（这是在Power Fx公式中引用它必须使用的名称）。如果是数据源，调用
get_data_source_schema
获取其列名和类型，并在回复中包含架构摘要，以便在后续编辑中使用。同样，对于API/连接器，调用
describe_api
获取可用端点及其参数，并在回复中包含架构摘要。
未找到 — 告知用户连接尚未可见。请他们：
  1. 确认已完成Studio中的步骤，且连接已显示在Data面板中。
  2. 检查他们的Studio会话是否仍处于活动状态（MCP服务器必须连接到实时协作会话）。
  3. 准备好后告知您，以便再次尝试。
使用
AskUserQuestion
等待用户回复，然后重新执行阶段3。

Phase 4 — Continue

阶段4 — 继续操作

After the connection is confirmed:
  • If the user had a pending task (e.g., "add SharePoint as a data source, then build a gallery"), continue with that work now using the verified connection name and schema.
  • If adding the connection was the only request, summarize what was confirmed (connection name, type, and schema if applicable) and suggest a natural next step (e.g., building a screen or gallery that uses the new data).
连接确认可用后：
  • 如果用户有未完成的任务（例如："添加SharePoint作为数据源，然后构建一个图库"），请使用已验证的连接名称和架构继续完成该任务。
  • 如果添加连接是唯一的请求，请总结已确认的内容（连接名称、类型以及适用的架构），并建议一个合理的下一步操作（例如：构建使用新数据的屏幕或图库）。