You know that annoying error you get when trying to populate a lookup field in Power Automate with the Current Environment connector? And you might have found blog posts that the solution is to set the EntitySetName before the dynamic data? Good so far - but how the hell do you find the EntitySetName? Let... Continue Reading →
Get App ID with List Records in Power Automate
The new UCI and the ability to have several model driven apps changed the playground a lot for us ol' dynamics folks. It brought shiny new capabilities and flexibility but it also brought a tiny bit of more complexity to the game. Suddenly when you want to send an e-mail with a record URL you... Continue Reading →
How to Avoid the “Get Record” Action to Retrieve Related Data in Power Automate
In a previous blog post I wrote about how to use FetchXML to List Records from CDS in Power Automate. But what if a column you defined in your FetchXML doesn't show up in the Dynamic content because it is a column from a related record? Defining the FetchXML Let's start with using the most... Continue Reading →
No-Code Hack – Use Calculated Fields for Event Age Validation
This past weekend I was at Dynamics Power Saturday in Amsterdam an delivered a session I call "No-Code Hacks". One of my hacks was to show how you can solve a requirement for age limit at event by only using customization, a requirement usually solved with JavaScript. What is a Hack? To start with I... Continue Reading →
Assign User Security Roles in a CDS Model Driven App
Being able to build model-driven apps on the Power Platform with out actually having it base it on a Dynamics CE first party app opens up a world of possibilities, but also a few new experiences for a former Dynamics-gal like myself. For instance when I was going to assign my Users their Security Roles... Continue Reading →
Get Fields From Related Records Using Actions
Have you ever had that requirement where you know you can solve most of it with a workflow but the information you are after is one relationship too far away? For example:I have a custom entity called Event Registration that is related to Contact but the discount information is placed on Account. This article will... Continue Reading →