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 …
Sorting a Dataverse Lookup Column
In this post, I’ll cover how to sort a gallery by a Dataverse Lookup column. The most straightforward approach is to use the Sort function but SortByColumns can also be used and this is a little more complex. However, be …
Sorting A Power Apps Gallery
Have you ever had difficulty sorting a Power Apps gallery? Using the Switch function is the usually the best way to do this. In this post, I’ll demo how to allow your users to sort a Power App gallery by …
Streamline Canvas App Formulas With Dataverse Views!
Dataverse Views are a great way to simplify formulas and save time! When working with Dataverse in a Canvas App, often you find yourself using similar Filter formulas many times. If that’s the case, then a Dataverse view is just what …
Streamline Canvas App Formulas With Dataverse Views! Read More »
Dataverse Relations. Identifying Children, Grandchildren & Great-Grandchildren
January 2024 Update – Microsoft has improved the table navigation. Read about the lastest functionality: Navigating Dataverse Tables. In this post, I’ll show how the Filter function can be used to identify Dataverse relations, including Child and Grandchild rows and …
Dataverse Relations. Identifying Children, Grandchildren & Great-Grandchildren Read More »