Join JSON Arrays
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 …
Identifying the Flow User
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 …
Canvas App Naming Conventions for Screens and Controls
In this post I’ll explain the Canvas App naming conventions I use for screens and controls. This follows on from the previous post in which I discussed how and why I name variables and collections Clear and consistent naming conventions ensure …
Canvas App Naming Conventions for Screens and Controls Read More »
Canvas App Naming Conventions for Variables and Collections
Good canvas app naming conventions for variables and collections ensure their purpose is clear and understood. A consistent and recognised format both helps the App Maker and assists other developers conducting a peer review or handover The PowerApps Canvas App …
Canvas App Naming Conventions for Variables and Collections Read More »
Emojis in Canvas Apps
Do you want to add emojis in canvas apps or add a special Unicode character to draw attention to a particular section of content? If so, read on to find out how this can be easily done An emoji is …
Business Logic In Dataverse
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 …
Manage Security Groups from within a Power App
Have you ever needed to give a super-user the ability to easily add or remove users of a Power App? Here’s how to do that from within an app without needing to directly access Azure Active Directory Security Groups Security …
Everything About The Power Apps Camera And Add Picture Controls
The capability to take a photo within a Power App is easy to get up and running. However the relative merits of the Camera control versus the Add Picture control can be hard to weigh up as there are so …
Everything About The Power Apps Camera And Add Picture Controls Read More »
Power Apps Delegation
Power Apps delegation is the processing of a query within the data source itself rather than by Power Apps. Delegable queries are far more efficient because the query is executed quickly on the server and the full set of results …
Dataverse Many to Many Relationship
There are 2 ways to create a many to many relationship between tables in Dataverse, either directly or with a custom intersect table Let’s consider the user case of assigning engineers to projects. This is a typical many-to-many relationship because …
Dataverse Table Self-Joins
Recently I’ve posted quite a bit on how to navigate around Dataverse to identify related rows in different tables. With self-joins, rows can be related to other rows in the same table Consider the example of an organisation that has …
Dataverse Queries With FetchXML
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 …