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 …
January 2024 Update – Microsoft has improved the table navigation. Read about the lastest functionality: Navigating Dataverse Tables. In the previous post, I showed how to navigate Dataverse relationships. In this post, I’ll demo a simple technique to save Dataverse …
January 2024 Update – Microsoft has improved the table navigation. Read about the lastest functionality: Navigating Dataverse Tables. Dataverse makes building Power Apps a much more rewarding experience. In this post, I’ll show how to use the dot.notation to navigate …
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 …
A Short post playing around with embedded tables in collections Contents Create an Single Column Embedded Table within a Collection ClearCollect( colA, { Month: [ “Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun” ] } ) Extract the Contents of the Table …
Using the With function it’s possible to create something very similar to a variable that just exists within the With statement in which it is created. I call this a ‘Control Variable‘. It isn’t an offical Power Apps variable and you …
A Power Apps expanding Gallery is a fantastic way to allow users to drill down to a greater level of detail without overloading their screens. They can also be used as a menu for navigation. The key is to use …
The With function is a great way to simplify formulas, reduce the query load on Data Sources and therefore improve performance So when I say create ‘Control Variables using the With function’, what exactly do I mean? Well, it’s not …
