JSON Arrays ,When working with JSON arrrays in Power Automate, the Apply to Each loop is often assumed to be necessary when transforming or manipulating arrays. However, loops are not always the best option and they can lead to performance […]
Required JSON Data Recently, I’ve discussed how you can build flexibility into your flows if the JSON data returned by an API contains a null or an empty string. Today I’ll look at how you can validate that the API
Empty JSON Strings When APIs have no data, generally either a null value or an empty string is returned. Last week in my post Handling Incomplete JSON Data, I discussed how to handle null values. Today I’ll explain how to
Incomplete JSON Data Another day on my JSON journey. Today I’ll explain how you can build flexibility into your flows by improving the format of a JSON schema to handle incomplete data, in particular when an API returns a null
Dataverse ‘Expand Query’ Feature When working with Power Automate and Dataverse, querying data across related tables is a common requirement. One of the most powerful features to handle this is the ‘Expand query’ option in the Dataverse ‘List rows’ action.
Here is a simple trick to get around one of the limitations of dropdown controls, the fact that they can’t display data from related tables. In a dropdown control, only data in columns native to the table specified in the
Navigating Dataverse – 2024 Update In 2021, I wrote a series of blog posts on how to navigate up and down a chain of Dataverse tables At the time, finding the related parent or child records was straightforward using dot
Filtering on Date Fields – I’ve always found working with Dataverse date columns in Power Apps temperamental. I’ve always found a solution that works, but the nagging doubt has remained that I wasn’t completely clear why there was a problem
There’s a Chinese proverb that says “A journey of a thousand miles begins with a single step” and that equally applies to coding complex formulas in Power FX I was asked about a previous post Filter Based on Child Data, and
Filter based on Child Data – Here’s a quick demo on how to get a filtered list of records from a parent Dataverse table based on data in a child table In my user case, I have a simple Dataverse structure
Lookup Columns – In this post I’ll show how to use Power Automate to access lookup columns and change multiple child records in Dataverse based on the parent table’s record value Boxes & Files In my example, I have a
Dataverse Many to Many Relationships It can be a little tricky to work out how to navigate the many to many relationships between Dataverse tables Let’s look at the many-to-many relationship between the Teams and User tables. A Team can
