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 …
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 …
The Reset function is really useful to clear any unsaved changes in a field and return the existing stored data. Using Galleries, sometimes you want to reset a specific record. Other times it’s useful to clear unsaved changes for all …
The Table function is used in Power Apps to manually create a Table within a Power App control rather than retrieving data from a networked data source (such as SharePoint) or a Collection. But what is it used for and …
In this short post on Power Apps Variables, I’ll summarise how values and single records are assigned and updated. I’ll also cover what can’t be done with variables, so time isn’t wasted trying – something that has caught me out …
Here are the tips I use to optimise Power Apps performance. Because Power Apps is so flexible and often has several ways of achieving the same result, I know from experience that it’s easy to inadvertantly slip into bad coding …
25 Great Tips to Optimise Power Apps Performance Read More »
