Recently I was investigating removing a component in a production environment, that stubbornly remained. It had me thinking for longer than it should, but after first diving down a couple of rabbit holes, I realised what the issue was. The […]
Beware of Components in Multiple Solutions! Read More »
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.
Creating Clean JSON in Canvas Apps Read More »
Working with large or complex JSONs can be intimidating, The key is to understand the JSON structure you are working with. If you’re struggling trying to extract data from a JSON, then this post is for you! JSON Structure The
Navigating a JSON Structure Read More »
Canvas App Size A canvas app runs in a client browser as a single web page and the larger the canvas app size, the greater the device memory that can be required for the app to run If an app
Canvas App Size & Performance Read More »
If an action in a Power Automate cloud flow runs as expected, a HTTP 200 response is received together with any data requested. However, if the action doesn’t complete due to an ‘intermittent failure’ then one of the following status
From time-to-time, things don’t work out exactly as expected, in flows as in life! Using error handling, you can specify an action to run only after the failure of the previous action Error Handling In this example, I want to
Flow Error Handling Read More »
When retrieving rows using Power Automate, by default the number of rows returned is limited to a maximum of 5000 for Dataverse and 100 for SharePoint Dataverse To increase the limit for Dataverse, turn on the pagination feature from Settings
Power Automate Row Limits for Dataverse & SharePoint Read More »
As flows grow in complexity, managing a flow’s structure becomes important for fixing issues & testing The Scope action can be used to help make a flow manageable. Scope is an action that groups other actions within it. Its purpose
Power Automate Scope Action Read More »
In the previous post, I explained how to delete a file based on a change to a column in Dataverse. I used an automated flow to delete a file stored in a Dataverse column which triggered every time the status
Dataverse storage costs can be expensive. If you want to automatically delete a file stored in a Dataverse file column that is no longer required, here’s how to do it In this example, whenever the status of a row in
Automatically Delete a Dataverse File Read More »
Do you need to pass a JSON array to a child flow? Here are 2 simple flows. The parent creates a simple JSON array that I want to pass to the child flow The difficulty is that a child flow requires
Pass a JSON Array to a Child Flow Read More »
Join JSON Arrays This is how to join two JSON arrays with Power Automate. The first array is generated from Dataverse. The ‘List rows’ step extracts the first 5 rows from a table, in this case the Counties of England
