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
Business Logic What are the options to implement server-side business logic in Dataverse? In this post I’ll discuss when to use a cloud flow vs a plugin. Dataverse has some basic built in business logic capability. For example, mathematical calculations
If you need to identify Dataverse rows and you are working with tables containing lots of data, FetchXML is a way to get those rows without any delegation issues! Recently I’ve been working on a Canvas Apps project that required
Microsoft released their new AI Invoice Processing capability in preview last month. I took it for a test run using Power Apps and Power Automate. How do I rate it? Read on to find out! AI Invoice Processing I’ve been
