Warning
This repository is still work-in-progress and expected to undergo significant changes
This is an experimental project to explore the use of Azure AI services with Microsoft Power Platform. It is based on the Dataverse Web API and the Azure Cognitive Services with use of Azure AI Functions.
It can be used as a starting point for building your own Copilot/AI Assistant for Microsoft Power Platform. ConsoleTestApp is a sample console application that demonstrates how to use it. You can add more skills to DataverseAIClient class or derive from it to create your own client. During runtime, the client will automatically discover all skills and their parameters.
- Assign roles
- Find Dataverse Solution and send email to owner
- Translate Table Descriptions
- Ask questions about Table Properties
- Ask questions about Canvas Apps
- Save Canvas Apps as msapp file to local folder
- List available solutions and whats inside them
- Share canvas apps
- Switching between Environments
- Listing of roles
This project is welcoming contributions. If you have any questions, feel free to start a discussion. I can even give temporary OpenApiKey for testing to people who contribute.
Copilot/AI Assistant Skills implemented as AI Functons
Open appSettings.json and update the following settings:
| Section | Setting | Description |
|---|---|---|
| TestApp | EnvironmentId | Dataverse environment id |
| AzureAI | OpenApiEndPoint | Azure AI Open API endpoint |
| AzureAI | OpenApiKey | Azure AI Open API key |
| AzureAI | OpenApiModel | Azure AI Open API model which supports Azure AI Functions version 0613 of gpt-35-turbo, gpt-35-turbo-16k, gpt-4, and gpt-4-32k |
| PowerPlatform | AzureAppId | Entra ID Applicatinon that has access to Power Platform |
| PowerPlatform | GraphAppId | Entra ID Applicatinon that has access to Microsoft Graph (can be same application) |