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. […]

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

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

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

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

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

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

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

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

With this neat little technique you can identify the user who invoked a flow from a Power App or other trigger Flow User The user’s name, email or GUID can be identified and captured, and it’s as simple as initialising
Scroll to Top