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 […]
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
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
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
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
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
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
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
