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 …
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 …
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 …
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 …
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 …
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 …
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 »
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 »
January 2024 Update – Microsoft has improved the table navigation. Read about the lastest functionality: Navigating Dataverse Tables. Recently, I wrote about how saving a Dataverse row to a variable can help Dataverse navigation. In that post, I used a series …
Dataverse Navigation. Identifying Related Child, Parent & Grandparent Rows Read More »
A frequent requirement with canvas apps and Dataverse is to filter the contents of a table by a particular column within that table. Depending on the complexity of the filtering, that can be very straightforward or if you want to …
Dataverse Choice columns are quick to create and are straightforward for Makers to incorporate into their app, however, they are very limited. A more flexible alternative is to host the data in a separate table and access that table using …
Filtering Dataverse tables is usually intuitive and fairly straightforward. Occasionally though, you get hit with a curved ball and what appears to be the obvious solution doesn’t work and you need an alternative – Dataverse Views! The Importance of Delegation …
