Here is a simple trick to get around one of the limitations of dropdown controls, the fact that they can’t display data from related tables. In a dropdown control, only data in columns native to the table specified in the […]
By default, in Power Apps, the data in a choice column is displayed in the order in which the choice options are entered in Dataverse However, choice columns can be filtered and sorted when displayed in a Canvas app. How
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
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
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
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
No need to restrict a Power Apps Gallery search to a single method, multiple search options are possible. This approach uses either cascading Dropdown Boxes to refine a search, or if you already know what you are looking for, type
Dropdown boxes are really useful when used in conjunction with a Gallery to drill down and reduce a large data set to a much smaller one, so specific Records can be identified The best way to construct Dropdown boxes is