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 […]
Sorting A Power Apps Gallery Read More »
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
Filter Dataverse Lookup Column Read More »
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
Dataverse Choice vs Reference Table Read More »
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
Filter using Dataverse Views Read More »
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
Assigning Dataverse Records to Variables Read More »
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
Dataverse Relationships Read More »
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
Sort a Dataverse Choice Column Read More »
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
Default Dataverse Lookup Value Read More »
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
Embedded Tables in Collections Read More »
