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