
Description
Adds a data source or connector to a Power Apps code app. Asks what the user wants to accomplish and routes to the appropriate specialized skill.
SKILL.md
📋 Shared Instructions: shared-instructions.md - Cross-cutting concerns.
Add Data Source
Router skill that understands the user's goal and connects them to the right data source -- without requiring them to know Power Platform terminology.
Workflow
Check Memory Bank
Check for memory-bank.md per shared-instructions.md.
Understand the Goal
- If
$ARGUMENTSis provided or the caller already specified what's needed, use it directly and skip the question below. - Otherwise, ask the user what they want their app to do -- not which connector to use. Focus on the end goal. Example questions:
- "What kind of data does your app need to work with?"
- "What should your app be able to do? (e.g., search company info, manage tasks, send messages)"
- Based on their answer, recommend the best approach and explain why it's the right fit. The user shouldn't need to know the difference between Dataverse, SharePoint, or other connectors -- that's our job.
Route to the Right Skill
Map the user's goal to the appropriate skill:
| User's goal | Best approach | Invoke |
|---|---|---|
| Store and manage structured business data (custom tables, forms, CRUD) | Dataverse is the platform's native database | /add-dataverse |
| Track work items, bugs, builds, or pipelines | Azure DevOps connector | /add-azuredevops |
| Send or read Teams messages, post to channels | Teams connector | /add-teams |
| Read/write Excel spreadsheet data | Excel Online (Business) connector | /add-excel |
| Upload, download, or manage files | OneDrive for Business connector | /add-onedrive |
| Work with SharePoint lists or document libraries | SharePoint Online connector | /add-sharepoint |
| Send emails, read inbox, manage calendar events | Office 365 Outlook connector | /add-office365 |
| Invoke an AI agent or copilot built in Copilot Studio | Copilot Studio connector | /add-mcscopilot |
| Something else or not sure | Generic connector (we'll figure it out) | /add-connector |
Important routing rules:
- When the user wants to perform actions (send an email, post a message, create a file), use the specific connector for that action (e.g.,
/add-office365for sending email,/add-teamsfor posting messages).
- If the user wants multiple capabilities, invoke each skill in sequence.
When the User Isn't Sure
If the user describes a vague goal (e.g., "I need data for my app"), guide them:
- Ask what their app does and who uses it
- Ask what data they need to display or interact with
- Recommend the simplest approach that meets their needs
- Explain the recommendation in plain language (avoid jargon like "connector", "Dataverse", "tabular data source" unless the user uses those terms first)
More skills from the power-platform-skills repository
View all 26 skillsactivate-site
provision and activate Power Pages sites
Apr 6DeploymentMicrosoftPower Pagesadd-connector
add Power Platform connectors to apps
Jul 31IntegrationsPower AppsPower Platformadd-dataverse
add Dataverse tables to Power Apps
Jul 31Data ModelingDataverseMicrosoftPower Appsadd-excel
integrate Excel Online into Power Apps
Jul 31ExcelIntegrationsMicrosoftPower Appsadd-mcscopilot
add Copilot Studio connectors to Power Apps
Jul 31AgentsCopilot StudioIntegrationsMicrosoft +1add-sample-data
populate Power Pages tables with sample data
Apr 6DatabaseDataverseMicrosoftPower Pages +1
More from Microsoft
View publisherrushstack-best-practices
manage Rush monorepos with best practices
rushstack
Apr 6EngineeringLocal DevelopmentMicrosoftProject Management +1azure-ai-agents-persistent-dotnet
build AI agents with Azure .NET SDK
skills
Jul 3.NETAgentsAzureLLMazure-ai-anomalydetector-java
build anomaly detection applications with Java
skills
May 13AnalyticsAzureData AnalysisJava +2azure-ai-contentsafety-java
build content moderation applications with Azure AI
skills
Jul 7AI InfrastructureAzureJavaSecurityazure-ai-contentsafety-py
detect harmful content with Azure AI Content Safety
skills
Jul 18AzureComplianceLLMMicrosoft +2azure-ai-language-conversations-py
implement conversational language understanding with Python
skills
Jul 31AnalyticsAzureLLMPython