Category: Dynamics 365

  • Using Python with Dataverse – How to Execute Custom Python Code for Dataverse

    This post discusses leveraging Python with Dataverse, highlighting its advantages for analytics, reporting, and automation in Dynamics 365. It presents a real-world example of a C-level dashboard generated from Dataverse data, showcasing how to efficiently aggregate data, create custom visualisations, and send notifications using Python scripting and the PowerPlatform-DataverseClient-Python SDK.

  • How to Build and Use a Dynamics 365 MCP Server

    I developed a Dynamics 365 MCP Server for an agentic engineering project, aimed at integrating AI agents with Dynamics 365 operations. Key focus areas included server design, tool registration, and validation of workflows. This MCP framework enhances consistency and supports robust workflows for enterprise applications. Resources for building your own…

  • Elastic Tables in Dynamics 365 and PowerApps

    This post explains elastic tables in Dataverse, highlighting their structure, creation process, and key considerations. Unlike standard tables, elastic tables, backed by Azure Cosmos DB, support high volumes of semi-structured data and automatic scaling. They are ideal for unstructured data but lack transactional integrity typical of relational databases.

  • Code-First Architecture in Dynamics 365: Why Less Technology Is More

    The post highlights the challenges of tech sprawl in Dynamics 365 projects, where business logic gets fragmented across multiple tools, complicating debugging and maintenance. It advocates for a streamlined architecture using one technology per concern, emphasising plugins for server-side logic, TypeScript web resources for UI, and Power Automate for approvals,…

  • The Importance of Automated Testing in Dynamics 365 Projects and How to Set Up CI/CD

    Today I want to talk about something that transforms how you deliver Dynamics 365 projects. Automated testing combined with CI/CD pipelines. If you are still manually testing every change and deploying solutions by hand, you are spending too much time on repetitive work and taking unnecessary risks. I recently implemented…

  • The Importance of Integration Testing in Dynamics 365 Plugin Projects

    Today I want to talk about something that can save you from painful production issues. If you are writing plugins for Dynamics 365, unit tests are great, but they are not enough. You need integration testing. I have seen countless projects where plugins pass all unit tests with flying colors,…