Specifying Required JSON Data
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 …
Handling Empty JSON Strings
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 Incomplete JSON Data
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 …
Simplify JSON Content Before Parsing!
This is a very useful tip that makes working with JSON content in Power Automate much easier! I’ve discussed in previous posts how to understand and navigate a JSON structure, so if you need guidance with this, then check out …
Importing a Managed Solution. Upgrade or Update?
Upgrades and Updates When importing a managed solution, a decision is required to either upgrade or update the existing solution. Upgrades are intended for deploying significant changes, like new features, structural changes, or adding new tables. The ‘Stage for Upgrade’ …
Importing a Managed Solution. Upgrade or Update? Read More »
Solution Version Numbering
Power Platform solutions are version numbered using the format: <Major>.<Minor>.<Build>.<Revision> For example, when a solution is created in a development environment, it will initially have the version 1.0.0.0. Revision Number The first time the solution is exported, the Revision is …
Power Automate Analytics Trouble Shooting
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 …
Sharing Power Apps: Security Groups V. Microsoft 365 Groups
Sharing Power Apps When using a group to share a Power App, both security groups and Microsoft 365 (M365) groups are options. Each type of group has its own benefits and limitations, depending on your needs. In this post, we’ll …
Sharing Power Apps: Security Groups V. Microsoft 365 Groups Read More »
Power Automate: Combine Related Table Data
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: Filter on a Dataverse Lookup Column
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 »
Environment Administration Mode
What Is Administration Mode? Administration mode is an environment config setting that allows admins to restrict access to a particular environment preventing users from creating, changing or deleting any data. This is enforced because administration mode blocks access to Dataverse for …
Connection References
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 …