# PowerPlatformExample **Repository Path**: company-test_0/power-platform-example ## Basic Information - **Project Name**: PowerPlatformExample - **Description**: PowerPlatform：PowerApps，PowerAutomate，PowerBI，PowerPages，Dataverse，Azure - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2024-09-06 - **Last Updated**: 2026-06-18 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # PowerPlatformExample ## 参考链接 * 认证 | 认证编号 | 培训链接 | 所属产品 | 课程名称 | 备注 | | -------- | -------- | -------- | -------- | ---- | | AI-102 | [Course AI-102T00-A](https://learn.microsoft.com/en-us/training/courses/ai-102t00) | Microsoft Azure | AI-102T00-A: Designing and Implementing a Microsoft Azure AI Solution | 针对软件开发者，专注于 Azure AI 服务 | | AI-900 | [Course AI-900T00-A](https://learn.microsoft.com/en-us/training/courses/ai-900t00) | Microsoft Azure | AI-900T00-A: Microsoft Azure AI Fundamentals | 基础级，介绍 Azure AI 基本概念 | | AZ-104 | [Course AZ-104T00-A](https://learn.microsoft.com/en-us/training/courses/az-104t00) | Microsoft Azure | AZ-104T00-A: Microsoft Azure Administrator | 涵盖 Azure 计算、存储、网络管理 | | AZ-140 | [Course AZ-140T00-A](https://learn.microsoft.com/en-us/training/courses/az-140t00) | Microsoft Azure | AZ-140T00-A: Configuring and Operating Microsoft Azure Virtual Desktop | 专注于 Azure 虚拟桌面 | | AZ-204 | [Course AZ-204T00-A](https://learn.microsoft.com/en-us/training/courses/az-204t00) | Microsoft Azure | AZ-204T00-A: Developing Solutions for Microsoft Azure | 针对 Azure PaaS 应用开发 | | AZ-305 | [Course AZ-305T00-A](https://learn.microsoft.com/en-us/training/courses/az-305t00) | Microsoft Azure | AZ-305T00-A: Designing Microsoft Azure Infrastructure Solutions | 设计 Azure 云解决方案 | | AZ-400 | [Course AZ-400T00-A](https://learn.microsoft.com/en-us/training/courses/az-400t00) | Microsoft Azure | AZ-400T00-A: Designing and Implementing Microsoft DevOps Solutions | 专注于 Azure DevOps | | AZ-500 | [Course AZ-500T00-A](https://learn.microsoft.com/en-us/training/courses/az-500t00) | Microsoft Azure | AZ-500T00-A: Microsoft Azure Security Technologies | 实施 Azure 安全控制 | | AZ-600 | [Course AZ-600T00-A](https://learn.microsoft.com/en-us/training/courses/az-600t00) | Microsoft Azure | AZ-600T00-A: Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub | 混合云配置 | | AZ-700 | [Course AZ-700T00-A](https://learn.microsoft.com/en-us/training/courses/az-700t00) | Microsoft Azure | AZ-700T00-A: Designing and Implementing Microsoft Azure Networking Solutions | Azure 网络解决方案 | | AZ-720 | [Course AZ-720T00-A](https://learn.microsoft.com/en-us/training/courses/az-720t00) | Microsoft Azure | AZ-720T00-A: Azure Support Engineer Troubleshooting Azure Connectivity | Azure 连接问题故障排除 | | AZ-800+AZ-801 | [Course AZ-800T00-A](https://learn.microsoft.com/en-us/training/courses/az-800t00)
[Course AZ-801T00-A](https://learn.microsoft.com/en-us/training/courses/az-801t00) | Microsoft Azure / Windows Server | AZ-800T00-A: Administering Windows Server Hybrid Core Infrastructure
AZ-801T00-A: Configuring Windows Server Hybrid Advanced Services | 需通过两门考试，管理 Windows Server 混合云 | | AZ-900 | [Course AZ-900T00-A](https://learn.microsoft.com/en-us/training/courses/az-900t00) | Microsoft Azure | AZ-900T00-A: Microsoft Azure Fundamentals | 基础级，介绍 Azure 云概念 | | DP-100 | [Course DP-100T01-A](https://learn.microsoft.com/en-us/training/courses/dp-100t01) | Microsoft Azure | DP-100T01-A: Designing and Implementing a Data Science Solution on Azure | 设计 Azure 数据科学解决方案 | | DP-203 | [Course DP-203T00-A](https://learn.microsoft.com/en-us/training/courses/dp-203t00) | Microsoft Azure | DP-203T00-A: Data Engineering on Microsoft Azure | 专注于 Azure 数据工程 | | DP-300 | [Course DP-300T00-A](https://learn.microsoft.com/en-us/training/courses/dp-300t00) | Microsoft Azure | DP-300T00-A: Administering Microsoft Azure SQL Solutions | Azure SQL 数据库管理 | | DP-420 | [Course DP-420T00-A](https://learn.microsoft.com/en-us/training/courses/dp-420t00) | Microsoft Azure | DP-420T00-A: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB | Azure Cosmos DB 应用开发 | | DP-500 | [Course DP-500T00-A](https://learn.microsoft.com/en-us/training/courses/dp-500t00) | Microsoft Azure / Power BI | DP-500T00-A: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI | 企业级分析解决方案 | | DP-600 | [Course DP-600T00-A](https://learn.microsoft.com/en-us/training/courses/dp-600t00) | Microsoft Fabric | DP-600T00-A: Implementing Analytics Solutions Using Microsoft Fabric | Microsoft Fabric 分析解决方案 | | DP-900 | [Course DP-900T00-A](https://learn.microsoft.com/en-us/training/courses/dp-900t00) | Microsoft Azure | DP-900T00-A: Microsoft Azure Data Fundamentals | 基础级，介绍 Azure 数据服务 | | MB-210 | [Course MB-210T01-A](https://learn.microsoft.com/en-us/training/courses/mb-210t01) | Dynamics 365 | MB-210T01-A: Microsoft Dynamics 365 Sales | 针对销售功能顾问 | | MB-220 | [Course MB-220T00-A](https://learn.microsoft.com/en-us/training/courses/mb-220t00) | Dynamics 365 | MB-220T00-A: Microsoft Dynamics 365 Customer Insights (Journeys) Functional Consultant | 将于 2024 年 11 月 30 日退役 | | MB-230 | [Course MB-230T01-A](https://learn.microsoft.com/en-us/training/courses/mb-230t01) | Dynamics 365 | MB-230T01-A: Microsoft Dynamics 365 Customer Service | 针对客户服务功能顾问 | | MB-240 | [Course MB-240T00-A](https://learn.microsoft.com/en-us/training/courses/mb-240t00) | Dynamics 365 | MB-240T00-A: Microsoft Dynamics 365 Field Service | 针对现场服务功能顾问 | | MB-300+MB-310 | [Course MB-300T00-A](https://learn.microsoft.com/en-us/training/courses/mb-300t00)
[Course MB-310T00-A](https://learn.microsoft.com/en-us/training/courses/mb-310t00) | Dynamics 365 | MB-300T00-A: Microsoft Dynamics 365: Core Finance and Operations
MB-310T00-A: Microsoft Dynamics 365 Finance | 需通过两门考试，MB-310 专注于财务功能 | | MB-300+MB-320 | [Course MB-300T00-A](https://learn.microsoft.com/en-us/training/courses/mb-300t00)
[Course MB-320T00-A](https://learn.microsoft.com/en-us/training/courses/mb-320t00) | Dynamics 365 | MB-300T00-A: Microsoft Dynamics 365: Core Finance and Operations
MB-320T00-A: Microsoft Dynamics 365 Supply Chain Management, Manufacturing | 需通过两门考试，MB-320 专注于制造 | | MB-300+MB-330 | [Course MB-300T00-A](https://learn.microsoft.com/en-us/training/courses/mb-300t00)
[Course MB-330T00-A](https://learn.microsoft.com/en-us/training/courses/mb-330t00) | Dynamics 365 | MB-300T00-A: Microsoft Dynamics 365: Core Finance and Operations
MB-330T00-A: Microsoft Dynamics 365 Supply Chain Management | 需通过两门考试，MB-330 专注于供应链管理 | | MB-500 | [Course MB-500T00-A](https://learn.microsoft.com/en-us/training/courses/mb-500t00) | Dynamics 365 | MB-500T00-A: Microsoft Dynamics 365: Finance and Operations Apps Developer | 针对开发者 | | MB-700 | [Course MB-700T00-A](https://learn.microsoft.com/en-us/training/courses/mb-700t00) | Dynamics 365 | MB-700T00-A: Microsoft Dynamics 365: Finance and Operations Apps Solution Architect | 针对解决方案架构师 | | MB-800 | [Course MB-800T00-A](https://learn.microsoft.com/en-us/training/courses/mb-800t00) | Dynamics 365 Business Central | MB-800T00-A: Microsoft Dynamics 365 Business Central Functional Consultant | 针对 Business Central 功能顾问 | | MB-900 | [Course MB-900T01-A](https://learn.microsoft.com/en-us/training/courses/mb-900t01) | Dynamics 365 | MB-900T01-A: Microsoft Dynamics 365 Fundamentals | 基础级，介绍 Dynamics 365 | | MB-910 | [Course MB-910T00-A](https://learn.microsoft.com/en-us/training/courses/mb-910t00) | Dynamics 365 | MB-910T00-A: Microsoft Dynamics 365 Fundamentals (CRM) | 基础级，专注于 CRM | | MB-920 | [Course MB-920T00-A](https://learn.microsoft.com/en-us/training/courses/mb-920t00) | Dynamics 365 | MB-920T00-A: Microsoft Dynamics 365 Fundamentals (ERP) | 基础级，专注于 ERP | | MS-102 | [Course MD-102T00-A](https://learn.microsoft.com/en-us/training/courses/md-102t00) | Microsoft 365 | MD-102T00-A: Microsoft 365 Endpoint Administrator | 针对端点管理员 | | MS-500 | 无官方课程（已退役） | Microsoft 365 | 不适用 | 已于 2023 年 6 月 30 日退役 | | MS-700 | [Course MS-700T00-A](https://learn.microsoft.com/en-us/training/courses/ms-700t00) | Microsoft 365 | MS-700T00-A: Managing Microsoft Teams | 针对 Teams 管理员 | | MS-720 | 无官方课程（已退役） | Microsoft 365 | 不适用 | 已于 2023 年 6 月 30 日退役 | | MS-740 | 无官方课程（已退役） | Microsoft 365 | 不适用 | 已于 2023 年 7 月 31 日退役 | | MS-900 | [Course MS-900T01-A](https://learn.microsoft.com/en-us/training/courses/ms-900t01) | Microsoft 365 | MS-900T01-A: Microsoft 365 Fundamentals | 基础级，介绍 Microsoft 365 | | PL-100 | [Course PL-100T00-A](https://learn.microsoft.com/en-us/training/courses/pl-100t00) | Power Platform | PL-100T00-A: Microsoft Power Platform App Maker | 针对应用开发者 | | PL-200 | [Course PL-200T00-A](https://learn.microsoft.com/en-us/training/courses/pl-200t00) | Power Platform | PL-200T00-A: Microsoft Power Platform Functional Consultant | 针对功能顾问 | | PL-300 | [Course PL-300T00-A](https://learn.microsoft.com/en-us/training/courses/pl-300t00) | Power Platform / Power BI | PL-300T00-A: Microsoft Power BI Data Analyst | 针对 Power BI 数据分析师 | | PL-400 | [Course PL-400T00-A](https://learn.microsoft.com/en-us/training/courses/pl-400t00) | Power Platform | PL-400T00-A: Microsoft Power Platform Developer | 针对开发者 | | PL-500 | [Course PL-500T00-A](https://learn.microsoft.com/en-us/training/courses/pl-500t00) | Power Platform | PL-500T00-A: Microsoft Power Automate RPA Developer | 针对 RPA 开发者 | | PL-600 | [Course PL-600T00-A](https://learn.microsoft.com/en-us/training/courses/pl-600t00) | Power Platform | PL-600T00-A: Microsoft Power Platform Solution Architect | 针对解决方案架构师 | | PL-900 | [Course PL-900T00-A](https://learn.microsoft.com/en-us/training/courses/pl-900t00) | Power Platform | PL-900T00-A: Microsoft Power Platform Fundamentals | 基础级，介绍 Power Platform | | SC-100 | [Course SC-100T00-A](https://learn.microsoft.com/en-us/training/courses/sc-100t00) | Microsoft Security | SC-100T00-A: Microsoft Cybersecurity Architect | 设计安全解决方案 | | SC-200 | [Course SC-200T00-A](https://learn.microsoft.com/en-us/training/courses/sc-200t00) | Microsoft Security | SC-200T00-A: Microsoft Security Operations Analyst | 威胁检测和响应 | | SC-300 | [Course SC-300T00-A](https://learn.microsoft.com/en-us/training/courses/sc-300t00) | Microsoft Security | SC-300T00-A: Microsoft Identity and Access Administrator | 管理 Azure AD | | SC-400 | [Course SC-400T00-A](https://learn.microsoft.com/en-us/training/courses/sc-400t00) | Microsoft Security | SC-400T00-A: Microsoft Information Protection Administrator | 管理数据保护策略 | | SC-900 | [Course SC-900T00-A](https://learn.microsoft.com/en-us/training/courses/sc-900t00) | Microsoft Security | SC-900T00-A: Microsoft Security, Compliance, and Identity Fundamentals | 基础级，介绍安全和身份管理 | * 文档 * [Microsoft Power Platform 文档](https://learn.microsoft.com/zh-cn/power-platform/) * [Microsoft Power Automate 文档](https://learn.microsoft.com/zh-cn/power-automate/) * [Microsoft Power Apps 文档](https://learn.microsoft.com/zh-cn/power-apps/) * [Power BI 文档](https://learn.microsoft.com/zh-cn/power-bi/) * [Microsoft Power Pages 文档](https://learn.microsoft.com/zh-cn/power-pages/) * [Microsoft Copilot Studio 文档](https://learn.microsoft.com/zh-cn/microsoft-copilot-studio/) * [Azure 文档](https://learn.microsoft.com/zh-cn/azure/) * [Microsoft 技术文档](https://learn.microsoft.com/zh-cn/docs/) * [浏览所有课程、学习路径和模块](https://learn.microsoft.com/zh-cn/training/browse/) * [Client API Reference for model-driven apps](https://learn.microsoft.com/zh-cn/power-apps/developer/model-driven-apps/clientapi/reference) * [Xrm.App (Client API reference)](https://learn.microsoft.com/zh-cn/power-apps/developer/model-driven-apps/clientapi/reference/xrm-app) * [Power Apps Component Framework 入门](https://learn.microsoft.com/zh-cn/training/modules/get-started-power-apps-component-framework/) * [构建 Power Apps 组件](https://learn.microsoft.com/zh-cn/training/modules/build-power-apps-component/) * [Power Fx](https://learn.microsoft.com/zh-cn/power-platform/power-fx/overview) * [pac使用](https://learn.microsoft.com/zh-cn/power-platform/developer/cli/reference/) * [FetchXml](https://learn.microsoft.com/zh-cn/power-apps/developer/data-platform/fetchxml/overview) * [OData](https://learn.microsoft.com/zh-cn/power-apps/developer/data-platform/webapi/query/overview) * [Business process flows](https://learn.microsoft.com/zh-cn/power-automate/business-process-flows-overview) * [AI Builder](https://learn.microsoft.com/zh-cn/ai-builder/overview) * 视频 * [微软Power Platform培训公开课——开启低码时代](https://www.bilibili.com/video/BV1nK411j7Qb/) * [微软工作账户怎么创建呢？](https://www.zhihu.com/question/388954459/answer/3238460972) * [creditcardrush](https://www.creditcardrush.com/visa-credit-card-generator/) * [Power Platform 入门教程 01 - 账户注册和画布应用创建](https://www.bilibili.com/video/BV1Ae4y1U7L7/) * [Power Platform 入门教程 02 - 使用 Dataverse 存储数据](https://www.bilibili.com/video/BV1se4y1i7j7/) * [Power Platform 入门教程 03 - 通过 Power Apps 将数据存储到 Dataverse](https://www.bilibili.com/video/BV1Re411V7tt) * [PowerPlatform 入门教程 04 - 初识 Power Automate](https://www.bilibili.com/video/BV1z14y1j7Bn/) * [Power Platform 入门教程 05 Dataverse for Teams](https://www.bilibili.com/video/BV1SN4y1w7Qk/) * [Power Platform 入门教程 06 Teams + Power Virtual Agents](https://www.bilibili.com/video/BV1hP411A7NF/) * [Power Platform 入门教程 07 - SharePoint 集成](https://www.bilibili.com/video/BV1Lt4y1u7Xt/) * [Power Platform 入门教程 08 - Power Apps 组件制作](https://www.bilibili.com/video/BV1yP4y1U7or/) * [Microsoft Azure 云服务的简单实验演示（合集）](https://www.bilibili.com/video/BV1PP4y1H72G/) * [Power Automate Desktop中文教程《微软RPA工具入门指南》12讲合集](https://www.bilibili.com/video/BV1au41167cR/) ## 目录 * [PowerApps](./PowerApps.md) * [PowerAutomate](./PowerAutomate.md) * [PowerPages](./PowerPages.md) * [PowerBI](./PowerBI.md) * [各功能门户入口](#各功能门户入口) * [PowerPlatform](#PowerPlatform) * [连接器](#连接器) * [office365连接器](#office365连接器) * [自定义连接器](#自定义连接器) * [日用场景](#日用场景) * [PowerPlatformCLI](#PowerPlatformCLI) * [XrmToolBox](#XrmToolBox) --- ## 各功能门户入口 * [Power Platform admin center](https://admin.powerplatform.microsoft.com/home) * [Power Pages](https://make.powerpages.microsoft.com/) * [Power Automate](https://make.powerautomate.com/) * [Microsoft Entra admin center](https://entra.microsoft.com/) * [Power Apps](https://make.powerapps.com/) * [Microsoft 365](https://www.microsoft365.com/) * [Microsoft Partner Center](https://partner.microsoft.com/) * [Visio](https://www.microsoft365.com/launch/visio) * [Azure](https://portal.azure.com/) * [Graph Explorer](https://developer.microsoft.com/en-us/graph/graph-explorer) ## PowerPlatform PowerPlatform是微软低代码平台，集成Office365、Dynamics365、Azure、企业传统业务应用 * 注册 https://signup.microsoft.com/get-started/signup?OfferId=6C1A80E7-CC3F-4E01-BAAF-385FBDA7CDFC&ali=1&ao=F31E46DE-FE53-4A3E-AE1D-D6FFDA791387&products=6C1A80E7-CC3F-4E01-BAAF-385FBDA7CDFC 工作组织域名：http://PHE059.onmicrosoft.com * Power BI：业务分析，数据建模，图像展现 * XMLA快速连接 * 支持SSMS访问 * 增量刷新 * 性能：优化模型、平衡工作区、扩容 * Power Apps：应用开发，app接口，低代码应用构建(类似ppt制作) * canvas画布应用：小移动端应用 * model模型驱动应用：管理面板 * portals门户：外面人员访问内部数据 * 组件框架PCF * 开发人员工具CLI * 自动诊断测试、CI/CD * Power Automate：工作流自动化，系统接口(类似钉钉/飞书) * flow流式处理审批/API调用等 * AI(表单+OCR+AI Builder)：文档、表单、发票、图片、审批 * API(连接器)：云服务、内部API * RPA(用户界面自动化桌面流)：web/windows应用 * 流程：触发器-操作-条件 * Power Virtual Agents：虚拟机器人，语言接口 * 公共能力基础： * Common Data Service(CDS)：(内部数据)跨应用数据对接和管理，连接到Azure、mssql，快速构造数据，安全控制(读写角色绑定)，实现原理：负载均衡+微服务封装各种服务，提供API给外部调用 * 数据连接器：(外部数据)数据调用 * AI Builder：AI识别 * 行动app-学习AI-自动化automate-分析BI ## 连接器 ### office365连接器 https://learn.microsoft.com/zh-cn/power-apps/maker/canvas-apps/connections-list https://learn.microsoft.com/zh-cn/connectors/office365/ API样例：Office365Outlook.V4CalendarPostItem(required1,required2,...,{option1:value1,option2:value2,...}) **部分API，power apps提示和文档对不上，考虑bing搜索后到github找样例，或找graphAPI样例，record里不知道填什么，可以考虑填写“{a:a}”，然后看报错内容** 在app里面调用flow去创建event更简单方便，如果你的app里面有需要ForAll去创建event的话，性能不太好 ``` https://learn.microsoft.com/en-us/connectors/office365groups/ https://learn.microsoft.com/en-us/connectors/office365/ Outlook Create event可根据日历id和相关信息创建事件，返回含事件id对象 Delete event可根据日历id和事件id删除事件 Get calendar view of events可根据日历id和筛选条件获取事件 Get calendars 可以获取自己的运行时日历id Get event可根据日历id和事件id获取事件 Get events可根据日历id和筛选条件获取事件 Respond to an event invite可根据事件id和字符串设置响应邀请 Update event可根据日历id和相关信息更新事件，返回含事件id对象 Flow When a new event is created When an event is added, updated or deleted When an event is modified When an upcoming event is starting soon Group Create a group event (V2) 可根据组id和相关信息创建事件，返回含事件id对象，注意时间传入值为UTC时间 Delete event通过组id和事件id删除事件，注意时间传入值为UTC时间 List group members根据组id和筛选条件获取成员信息(如userId，mail)，默认最多1000个，设置中可提升到3000个，更多需到power automate操作 List groups根据筛选条件获取组信息(组id等) List groups that I own and belong to返回符合条件的所有组 List my owned groups (V2) 返回符合条件的所有组 Update a group event可根据组id和相关信息更新事件，返回含事件id对象，注意时间传入值为UTC时间 Teams Create a Teams meeting可根据日历id和相关信息创建事件，返回含事件id对象，可通过outlook更新/删除事件 ``` ### 自定义连接器 https://learn.microsoft.com/zh-cn/connectors/custom-connectors/ Azure 逻辑应用、Microsoft Power Automate 和 Microsoft Power Apps 提供超过 1,000 个连接器以连接到 Microsoft 服务和经过验证的服务 1. 构建 API 自定义连接器是一个 REST API 包装器，允许逻辑应用、Power Automate 或 Power Apps 与 REST 或 SOAP API 通信。 这些 API 可以是： * 公共（在公共 Internet 上可见），如 Spotify、Slack、Rackspace 或您管理的 API。 * 专用（仅对您的网络可见）。 逻辑应用还支持 SOAP API。 2. 保护 API 使用这些标准身份验证方法之一（建议使用 Microsoft Entra ID）： * 通用 OAuth 2.0 * 适用于特定服务的 OAuth 2.0，包括 Microsoft Entra ID、Dropbox、GitHub 和 SalesForce * 基本身份验证 * API 键 3. 说明 API 并自定义连接器 以下方法均支持： * 一个 OpenAPI 定义（以前称为 Swagger 文件） * Postman 集合 * 使用自定义连接器门户从头开始（仅 Power Automate 和 Power Apps） 4. 在逻辑应用、Power Automate 或 Power Apps 应用中使用您的连接器 5. 共享连接器 6. 验证连接器 ## 日用场景 * 交付流程相关：Azure Devops/Work item/Sprint/Pipeline/授权操作 * citizen developer快速上手：项目文档/开发文档/标准化组件/Copilot生成/其它AI咨询 * 密钥管理：Azure Key Vault * 访问内网数据：Azure Virtual Network(网络拓扑/安全组/防火墙/监控) /Custom Connector * 容器服务：AKS * 防止意外的越权：Role/MFA多因素身份验证/活动日志审计于报警(Azure Monitor) * 自动化测试：Power Apps Test Studio录制脚本 * 性能监控/排查/安全性：Monitor/Analyzer/Solution Checker/Admin Center log/Azure Monitor ## PowerPlatformCLI 安装完成后能使用pac命令，附带可安装Nodejs/VScode/[Power Platform Tools](https://marketplace.visualstudio.com/items?itemName=microsoft-IsvExpTools.powerplatform-vscode) 可以依次输入 pac 和命令查看提供的选项 ``` > pac Microsoft PowerPlatform CLI Usage: pac [admin] [application] [auth] [canvas] [help] [org] [package] [paportal] [pcf] [plugin] [solution] [telemetry] admin Work with your PowerPlatform Admin Account application Commands for listing and installing available DataVerse applications from AppSource auth Manage how you authenticate to various services canvas Operating with Power Apps .msapp files help Show help for the Microsoft PowerPlatform CLI org Work with your Dataverse Organization package Commands for working with Dataverse package projects paportal Commands for working with PowerApps portal website pcf Commands for working with PowerApps component framework projects plugin Commands for working with Dataverse plugin class library solution Commands for working with Dataverse solution projects telemetry Manage telemetry settings ``` ``` > pac solution help Microsoft PowerApps CLI Usage: pac solution [init] [add-reference] [list] [delete] [online-version] [version] [import] [export] [clone] [publish] [upgrade] [add-license] [check] [create-settings] [pack] [unpack] init Initializes a directory with a new Dataverse solution project add-reference Adds a reference from the project in the current directory to the project at 'path' list List all Solutions from the current Dataverse Organization delete Delete Dataverse Solution from the current Dataverse Environment online-version Sets version for solution loaded in Dataverse environment. version Update build or revision version for solution import Import the Dataverse Solution into the current Dataverse Environment export Export a Dataverse Solution from the current Dataverse Environment clone Create a solution project based on an existing solution in your Organization publish Publishes all customizations upgrade Option to stage the Dataverse solution for upgrade add-license Add license and plan info to solution check Upload a Dataverse Solution project to run against the PowerApps Checker Service create-settings Create a settings file from solution zip or solution folder. pack Package solution components on local filesystem into solution.zip (SolutionPackager) unpack Extract solution components from solution.zip onto local filesystem (SolutionPackager) ``` ``` 从 CLI 建立连接并在系统提示时登录到测试环境 pac auth create --name Lab --url 显示环境和用户信息 pac org who 列出环境中的解决方案 pac solution list 初始化组件项目 pac pcf init --namespace lab --name FirstControl --template field ``` 安装应用 ``` 安装 Configuration Manager Tool pac tool cmt 安装 Package Deployer Tool pac tool pd 安装 Plug-in Registration Tool pac tool prt ``` ## XrmToolBox XrmToolBox我们可以把它理解为是Dynamics CRM的一个工具集， 里面有着各种各样的插件可以供我们安装使用 https://www.xrmtoolbox.com/ 常用登录方式：左下角-create new connection-microsoft login control-open microsoft login control-office 365-login * FetchXML Builder - 通过构建查询，来生成各种格式的查询语句(FetchXML, SQL Query, Power Automate Parameters, OData, QueryExpression...), 这个工具很好用~关键使用它可以查询很多高级查找没办法查到的数据 * SQL 4 CDS - 使用SQL语句来查询或者修改数据，可转化为xml query * Webresources Manager - 查询修改web rescource的利器，比进入系统中去修改web rescource好用太多了 * Ribbon Workbench - 控制模型驱动应用按钮与脚本绑定关系 * Dataverse Rest Builder - 类似postman，向自定义API发送请求 外网代理：下载Clash.for.Windows-0.20.39-win-CN * 配置yml ```yml mixed-port: 7890x allow-lan: false external-controller: '127.0xx.0xx.1xx:64472x' secret: '' proxies: - name: proxy1 type: socks5 server: 10x.2xx.13x.250 port: "1080" - name: proxy2 type: socks5 server: 10x.2xx.11x.250 port: "1080" - name: proxy3 type: socks5 server: 10x.2xx.11x.251 port: "1080" rules: - MATCH,DIRECT ``` * 测试并选一个可用的代理 * 常规中开启系统代理