Cloud Flow Exception and Response Handling Part 1
This post explores how Power Automate child flows return structured responses to parent flows using a standard output contract.
Other Posts
Connect Power BI Desktop to Azure SQL Edge or SQL Server 2019 on Docker
Connect Power BI Desktop to Azure SQL Edge or SQL Server 2019 on Docker
On a Windows 11 machine, I recently connected Power BI Desktop to both Azure SQL Edge and SQL Server 2019, hosted on Docker. By running these servers locally, you avoid connecting to the cloud and certain Azure hosting subscription charges, e.g. Pay-AS-You-Go, when...
The Attempted operation is prohibited because it exceeds the SharePoint List View threshold
The Attempted operation is prohibited because it exceeds the SharePoint List View threshold
If you are building Canvas Apps with screens that browse SharePoint Online Lists containing over 5000 items; you should be mindful of how you configure these Lists and the impact on Filter, Search, LookUp , Sort ( single columns only) and SortByColumns functions....
Restart or re-enable your flows with PowerShell and Microsoft 365 CLI
Restart or re-enable your flows with PowerShell and Microsoft 365 CLI
There are occasions, when you want to restart failed flow (Power Automate) runs or enabling (turning on) flows, after a solution deployment. You can do either of these tasks manually in the web browser or better still create repeatable scripts, combining PowerShell...
Use a JSON Formatter to view Power Automate Action Outputs.
Use a JSON Formatter to view Power Automate Action Outputs.
Want a better way to view the output in a Power Atomate trigger action such as SharePoint: when an item is created and easily determine a property value? This post will show how you can have nicely formatted JSON output with a simple extension in Edge Chromium. In...
Power Apps Survival Guide: Naming Standards
Power Apps Survival Guide: Naming Standards
This post covers a suggested naming standard that will help to aid consistency and maintainablity when working on Power Apps. If you adopt the suggested three character prefix, you limit how much you need to type but still be able to distingish each control. You...
Power APP: How to fix the BAD SOURCE Connector Exception
Power APP: How to fix the BAD SOURCE Connector Exception
A short post covering how to resolve the {"Status": 400, "message":Bad Data Source.\r\n inner exception: Not a valid data source...} , should encouter this in a Power App connected to a backend SQL Server Express 2017 virtual machine (VM), using a shared SQL Server...
Set Up App-Only Access To Your Tenant to solve (401) Unathorized Errors
Set Up App-Only Access To Your Tenant to solve (401) Unathorized Errors
Setting up an App-only principal in SharePoint Online is documented in Grant Access using SharePoint App-Only This post highlights how this approach can resolve: "Unauthorized (401) errors", running tenant level PnPComandlets such as Set-PnPStorageEntity , under an...
Enable MFA for Users with Office 365 E3 and E5 Licenses
Enable MFA for Users with Office 365 E3 and E5 Licenses
It is a good idea to enable multi-factor authentication (MFA) for all users on your Office 365 tenant. The good news is there are a number of available versions of Azure multi-factor authentication depending on your requirements and available budget. This post...
Cycle Live Nottingham 2019: 75 Miles
Cycle Live Nottingham 2019: 75 Miles
[ngg src="galleries" ids="13"...
The Random Read
The blog post lottery, discover something new today with a random post from any category
Cloud Flow Exception and Response Handling Part 1
This post explores how Power Automate child flows return structured responses to parent flows using a standard output contract.
Get in touch to discuss how I could help your business.
