I wanted to create a Canvas App that took a list of Time Transactions and showed them in a matrix format by Task and Duration. I also wanted to edit the data. ✏️ If you want to see it in action in your Environment, download it at https://mattruma.com/wp-content/uploads/2024/09/TimesheetSolution_1_0_0_0.zip. Let’s breakdown what I have in my OnStart event in my Canvas App. I set gblStartDate to the date of… READ MORE
Article I: Unlocking the Power of Microsoft Dataverse: A Game-Changer for Power Platform Integration As a Software Engineer I have spent many hours managing different data sources such as spreadsheets, SQL databases and SharePoint lists and often face challenges integrating them properly. A year ago, I started using Microsoft Dataverse (formerly Common Data Service) and… READ MORE
I’ve been finding that many developers I meet are not familiar with all of the powerful functionality available when querying Dataverse. One of the features is the ability to aggregate data when fetching it using FetchXml. This can be particularly useful in situations when you want to reduce the logic needed inside your automation & offload the heavy… READ MORE
Do you build data models and custom apps with Dataverse in the background? Do you extend Dynamics 365 apps with custom columns, forms, views, and business logic? Do you automate tasks by setting up cloud flows, for more than personal use? Are you exploring creating your own agents with Copilot Studio? Do you create dual-write… READ MORE
💡 Challenge:Achieving a quick setup for dropdown menus or ComboBoxes in PowerApps, especially when under time constraints or in need of a temporary solution, often requires bypassing the more detailed setup processes associated with SharePoint or Dataverse. ✅ Solution:The “quick and dirty” approach involves leveraging Lookup and Choice columns in SharePoint or Dataverse to manage data sources… READ MORE
I was building some complex flows the other day and I was looking to simplify it the best I could. I started looking at outputs from previous steps and realised some of the data I needed was actually in the previous steps but not available natively in the dynamic content. This brings me back to… READ MORE
This is a very useful tip that makes working with JSON content in Power Automate much easier! I’ve discussed in previous posts how to understand and navigate a JSON structure, so if you need guidance with this, then check out the following: • Creating Clean JSON in Canvas Apps• Navigating a JSON Structure• Flattening a Nested JSON with… READ MORE
I’m going to share a simple tip that I’ve been finding very useful. Formula columns using PowerFX allow you to traverse the dataverse and pull information from several degrees of separation away. Often there are tools available in power platform that require the data to be directly available on a table or at most, one… READ MORE
One of the features currently in preview that I am #superexcited about is Dataverse low-code plug-ins. What are Dataverse low-code plug-ins? They allow you to build server-side business logic specifically for Dataverse. Plug-ins are not new technology. In the early versions of Dynamics (version 3 and before), there was the concept of call-outs, which allowed you… READ MORE
Once you work out how to wrangle with segments in the new ‘real-time marketing’ segment builder for in Dynamics 365 Marketing (Customer Insights – Journeys) you can build some seriously impressive and complex data queries for Leads or Contacts stored in Dynamics 365 Dataverse. Using Real-time Segments in Power Automate Why not just use FetchXML… READ MORE
