In this post, I’ll cover how to sort a gallery by a Dataverse Lookup column. The most straightforward approach is to use the Sort function but SortByColumns can also be used and this is a little more complex. However, be […]
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
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
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
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
The Power Apps Filter and StartsWith functions are very flexible and can be used to search single or multiple columns in a table In this article I’ll show how to give users the option to choose which columns to search Filter
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
There is a simple and very effective way to select multiple Records in a Gallery. The TemplateFill property of Galleries used with the tips below gives complete control so both individual and multiple Records within Galleries can be selected and
Records in Collections can be filtered before being displayed in Galleries. Dropdowns are a great way to do this and using a little configuration their use can be made intuitive, effective and user friendly Filter Galleries – 3 Great Tips
