Default Record By default, when a screen containing a Gallery is loaded, the first item in the Gallery is automatically selected. Sometimes this is helpful and sometimes not If you prefer to not have any record selected when the screen […]
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
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
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
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 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
In this article I’ll show how to display scraped web data in Power Apps. For this exercise we’ll use the Premier League Table from the BBC Sport website. You’ll see how straightforward it is to use Power Automate Desktop to
In the last post I set myself the challenge of creating an dynamic Power Apps Dropdown box that shows the number of records in a table that match the Dropdown selection criteria. The requirement was to not have hardcoding so
Power Apps Dropdowns don’t need to be dull! There are many cool features you can add to Dropdowns. In this post I’ll demonstrate 3 techniques to save time and improve usability Power Apps Dropdowns Dropdown 1: Here I’ve taken 2
Aligning data from multiple tables can be achieved in several ways. Cascading Power Apps Galleries, creating virtual tables using AddColumns, even simply using the humble Label. These techniques can be combined together to deliver the best solution Galleries and Relational Data
Even more tips on using Galleries to find a specific records in a data table! In this article, I’ll explain how to search across multiple columns. Once we have a reduced set of data, SortByColumns can be used to dynamically sort Galleries Table