Data
-
Filters – combining multiple criteria
Filters use various criteria to “dissect” a data source returning the records required, generally for a gallery, collection or other data gathering exercise.Simple Filters will generally refer to a Control (drop-down/combo box) where the selected value needs to match a field in the data source. In this exercise, the model below is based on a simple data source (a list of PC Devices) with two combo box controls and a text input. All affect the output in the gallery below. The list is sorted by Model Name and completely unfiltered looks like this The first Combo Box is from another list of Manufacturers, with the maker’s name also contained in…
-
Power Apps Controls and their References
Contents General When you start your Power Apps journey and start working with controls and their inputs and output references, there is a lot of confusion and misunderstanding that can be quite easily alleviated, saving you both time and potential errors. Initially, you had probably “left them alone” with the settings Power Apps provides when they were created, used SubmitForm() to save the data and all worked exactly as you expected. Now you are needing to refer to them in code and possibly change the settings in the control itself to meet your needs. All of this should not be overwhelming if you take a little time to understand a…
-
Constructing your first Power App – before you start
This might seem a bit of a strange subject title, but in the words of a great man of the past It is a bit like putting a roof on a house then wondering whether the foundations will hold it up – you need to construct your foundations to allow for the things you might want to do in the future. You have opened your new shiny new O365 box and had a look inside. You have purchased an E3 licence as you do not want the additional expense of premium features and are now wondering what you can do with what you have. The answer is quite a lot…
-
Many to Many Filters
This article discusses the example of a multi-choice field in SharePoint with a multi-choice Combo Box in Power Apps filtering the possibility of ANY selected field in the Combo Box matching ANY stored value in the list which is stored in a Complex (Table) field. Many on Many queries can be done directly in a Filter, but are not Delegable. To do this, firstly a Table needs to be created using ForAll addressing each of the Combo Box selected items to see if any are contained in the multi-select Choice field The output of the Combo Box has been assumed as .Value. If it is based on a field name, change this. We are not…