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 »
In this post, I’ll show how the Filter function can be used to identify Dataverse relations, including Child and Grandchild rows and even more distant descendants Using the simple table structure below, I’m going to navigate downwards from the Continent …
Dataverse Relations. Identifying Children, Grandchildren & Great-Grandchildren Read More »
Recently, I wrote about how saving a Dataverse row to a variable can help Dataverse navigation. In that post, I used a series of cascading galleries to assign rows to variables for Dataverse navigation. In this post, I’ll demo an alternative …
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 …
In the previous post, I showed how to navigate Dataverse relationships. In this post, I’ll demo a simple technique to save Dataverse records to variables and explain why this is incredibly useful! Table Structure First, a reminder of the simple …
Dataverse makes building Power Apps a much more rewarding experience. In this post, I’ll show how to use the dot.notation to navigate Dataverse relationships. I’ll also explain the limitations of working with Dataverse relationships and when you’ll need to revert …
Need to sort a Dataverse Choice column in a Canvas app? It seems like it should be straightforward to do, but unfortunately it’s not! Read on to see the possible options To sort a Dataverse Choice column, your first thought …
Setting a Default Dataverse LookUp value in Canvas Apps can give a slick user experience. I’ll demonstrate using the example of a simple Asset Tracking app. The app has just 2 screens fronting two tables. The Location table has a one-to-many relationship …
