The Joy and Frustration of JSON Over the past few weeks and months, I’ve posted quite a few blog posts about working with JSON files, particularly in Power Automate, and interacting with APIs. The content has come from what I’ve […]

Enhancing Your Power Automate Bluesky Posts In my previous blog Automate Posting on Bluesky, I discussed how to use Power Automate to post on Bluesky using their API. Today, we’re taking it a step further by adding links and hashtags

The Power Platform provides immense flexibility in connecting apps and automating workflows with APIs. A common scenario is using a Canvas App to trigger a Power Automate flow, which in turn, uses the HTTP connector to interact with external APIs.

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

In this post, I’ll cover how to sort a gallery by a Dataverse Lookup column.  The most straightforward approach is to use the Sort function but SortByColumns can also be used and this is a little more complex.  However, be

Have you ever had difficulty sorting a Power Apps gallery?  Using the Switch function is the usually the best way to do this.  In this post, I’ll demo how to allow your users to sort a Power App gallery by

January 2024 Update – Microsoft has improved the table navigation. Read about the lastest functionality: Navigating Dataverse Tables. In this post, I’ll show how the Filter function can be used to identify Dataverse relations, including Child and Grandchild rows and

Need to sort a Dataverse Choice column in a Canvas app?  It seems like it should be straightforward to do, but unfortunately it’s not!  Read on to see the possible options To sort a Dataverse Choice column, your first thought

Using the With function it’s possible to create something very similar to a variable that just exists within the With statement in which it is created.  I call this a ‘Control Variable‘.  It isn’t an offical Power Apps variable and you

A Power Apps expanding Gallery is a fantastic way to allow users to drill down to a greater level of detail without overloading their screens.  They can also be used as a menu for navigation.  The key is to use

The With function is a great way to simplify formulas, reduce the query load on Data Sources and therefore improve performance So when I say create ‘Control Variables using the With function’, what exactly do I mean? Well, it’s not

Scroll to Top
Scroll to Top