Lookup Columns in Dataverse When creating or modifying records in Dataverse with power Automate, a frequent challenge is formatting lookup columns correctly. Since a lookup column refers to a record in a related table, the format is slightly different to […]
Update a Dataverse Lookup Column Using Power Automate Read More »
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
JSON: A Recipe For Success Read More »
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
Automated Bluesky Links And Hashtags Read More »
Posting On Bluesky If you’ve been following the buzz in the social media world, you’ve probably heard about Bluesky. Bluesky is the decentralized platform that looks and feels very much like Twitter (erm… I mean X). Posting on Bluesky is
Automated Posting on Bluesky Read More »
Objects And Arrays What denotes a JSON array and what constitutes a single object? Why when I create an ‘Add a new row’ to Dataverse action does Power Automate sometimes automatically create an ‘Apply to each’ loop, even though I
JSON: Objects And Arrays Read More »
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
Specifying Required JSON Data Read More »
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
Handling Empty JSON Strings Read More »
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
Handling Incomplete JSON Data Read More »
While reviewing the flows in an environment using the Power Automate Admin Center (PPAC) analytics, it was clear that a small number of flow runs were generating a vast number of API calls! It’s likely that a single errant flow
Power Automate Analytics Trouble Shooting Read More »
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.
Power Automate: Combine Related Table Data Read More »
The ‘List Rows’ action in Power Automate retrieves multiple records from a Dataverse table. Frquently you’ll want to filter on a Dataverse lookup column. In this post, I’ll describe 2 ways you can do this and show you how to filter
Power Automate: Filter on a Dataverse Lookup Column Read More »
This post is a drill down into Connection References, what they are and how to use them most effectively with Power Automate What are Connection References? Connection references act as a link between actions in Power Automate and the actual
Connection References Read More »
