Bridge the gap between Pro-Code and Low-Code. GitHub Copilot Skills enable seamless Power Platform integration.

Closing the Gap

The Problem

• Pro-Devs work in VS Code/GitHub
• Citizen Devs work in Power Platform
• No shared workflow

The Solution

Custom Skills connect both worlds:

[GitHub Copilot] ←→ [Power Platform APIs] ←→ [Dataverse, Flows, Apps]

Dataverse Integration

Querying Data

export const queryDataverse: SkillAction = async (params) => {
  const { entity, filter } = params;
  
  const result = await dataverseClient
    .retrieveMultiple(entity, {
      filter: filter,
      select: ['name', 'status', 'created']
    });
    
  return result.entities;
};

Usage: "Show all active customers from Dataverse with revenue > 100k"

Creating Data

export const createRecord: SkillAction = async (params) => {
  const { entity, data } = params;
  
  const id = await dataverseClient.create(entity, data);
  
  return { 
    success: true, 
    recordId: id,
    message: `${entity} created`
  };
};

Usage: "Create a new lead in Dataverse for company ABC AG"

Power Automate Integration

Triggering Flows

export const triggerFlow: SkillAction = async (params) => {
  const { flowId, inputs } = params;
  
  const run = await powerAutomateClient.trigger(flowId, inputs);
  
  return {
    runId: run.id,
    status: run.status,
    monitorUrl: run.url
  };
};

Usage: "Start the approval flow for document #12345"

Checking Flow Status

export const getFlowStatus: SkillAction = async (params) => {
  const { runId } = params;
  
  const status = await powerAutomateClient.getRunStatus(runId);
  
  return {
    status: status.state,
    duration: status.duration,
    outputs: status.outputs
  };
};

Power Apps Support

App Metadata

export const getAppInfo: SkillAction = async (params) => {
  const { appId } = params;
  
  const app = await powerAppsClient.getApp(appId);
  
  return {
    name: app.name,
    version: app.version,
    lastModified: app.modifiedOn,
    owner: app.owner
  };
};

Generating Components

export const generateComponent: SkillAction = async (params) => {
  const { type, schema } = params;
  
  // Generate Power Apps Component Framework Code
  const pcfCode = await generatePCF(type, schema);
  
  return {
    code: pcfCode,
    instructions: 'PCF component for Power Apps'
  };
};

Practical Workflows

Bug to Ticket

GitHub Issue → Skill → Dataverse Case → Power Automate Notification

Developer: "Create a support ticket for GitHub Issue #456"

Data for Tests

Test Suite → Skill → Dataverse Query → Test Data

Developer: "Fetch 10 test customers from Dataverse for integration tests"

Deployment Trigger

Merge to Main → Skill → Power Automate Flow → Solution Deployment

Developer: "Deploy the current Power Apps solution to production"

Authentication

Service Principal

const credential = new ClientSecretCredential(
  process.env.AZURE_TENANT_ID,
  process.env.AZURE_CLIENT_ID,
  process.env.AZURE_CLIENT_SECRET
);

const dataverseClient = new DataverseClient(
  process.env.DATAVERSE_URL,
  credential
);

Permissions

Required API permissions:

• Dynamics CRM user_impersonation
• Flow.Read.All
• Flow.Manage.All
• PowerApps.Read.All

Best Practices

Error Handling

if (response.status === 403) {
  return {
    success: false,
    error: 'No permission for Dataverse access',
    suggestion: 'Check the security role in Power Platform'
  };
}

Rate Limiting

• Dataverse: 6000 requests/5 minutes
• Power Automate: 100 runs/day (basic)
• Implement caching

CNEXT Services

We offer:

1. 1Skill Development – Power Platform Skills
2. 2Integration Design – Pro-Code + Low-Code
3. 3Security Setup – Service Principal, Permissions
4. 4Training – Connecting both worlds

Conclusion

Power Platform Skills make GitHub Copilot the link between development and business automation. The best of both worlds.