-
Delegation Management – Multi-Choice Combo Boxes
This article looks at some degree of Delegation Management where a Multi-select Combo Box is used to filter a Data Source for any matching values in either a Text or Single Choice field. The output is a Table and can be used as the Items of either a Gallery or a subsequent cascading value Combo Box. In the below, I have a list of Devices and a field (Text) called DeviceType. I have a Combo Box (cbType) containing a Distinct list of the DeviceType (see this blog on how to do that in a Delegable manner). I have also used the Len() function below as it covers both Blank and empty string “”.So firstly, the normal approach would be which of course is not Delegable and will get the appropriate warning (and will…
-
Distinct values for a large list field in Combo Box Items
This idea is an extension of a workaround in Combo Boxes dealing with large lists and the Delegation issues surrounding these and the Distinct function. I have tested this on a large list (30k items) and it works perfectly. Two caveats here – the number of items displayed in your combo box and the number of filtered items subject to the Distinct function (after the leading letters are entered) will both be subject to your Delegation Limit, but these should not generally be an issue. This example is using a big list Aircraft with a field Airline. The idea is to start typing the Airline name and all Distinct values starting with the input will then be avalable for selection in…
-
Show size of attachment or uploaded file
Have you ever wanted to show or use the size of an uploaded file – the process is below Attachment Firstly, you need a hidden image control with the Image Then on the OnAddFile (and OnRemoveFile if you want) Then the Label below has the Text Uploaded file A similar, but less complex process – on the OnChange of the AddMediaButton and the Label below All attachments on a record An expansion on #1 above – make a Gallery (called galAttach below) with the Items Now put an Image control in the Gallery (called imAttach below) with the Image You can now hide the gallery You will need to trigger the next piece, so a button with “Size” or…
-
Saving and displaying multi-choice Combo Box in a Text field
It is well documented how to save the contents of a multi-select combo box to a Single Line of Text field, but not so how to successfully get the content back into the DefaultSelectedItems of the control. I will do two examples here (both related) – one on a Choice field and the other on a list of items. Items referenced as follows Choice field Items Update of Data Card DefaultSelectedItems List Field Next is a list based on a field from another List) – I will refer to the elements as follows Items Update of Data Card DefaultSelectedItems and that is about the extent of the process. I hope this is useful to you.
-
Emailing files from an Add Picture control directly from Power Apps (and include attachments)
Have you ever wanted to upload files in Power Apps using the Add Picture control and attach these to an email without using a Flow? It is actually not all that complex once the structure of the data Outlook expects is understood. Emailing uploaded file Firstly, starting with emailing the item uploaded – put an Add Picture control on the screen – I will call the Image Control in it imgAttachEmail and the Add Media Button ambFileAttach here for reference. Now down to business – the code on your send button/icon simply needs to grab the file content and name of the file uploaded and give them specific field names. and that is the extent of it. Your uploaded file…
-
Enter Time directly instead of drop-downs
Have you ever wanted to throw away the drop-downs that Power Apps supplies for time fields and simply have the user enter a valid time. For this you would also want to display the time currently stored in the data source and do both in an hh:mm format. It is not as difficult or complex as you may think and can also all be done within a SubmitForm() action using the Update property of the data card. Here are the steps required. Unlock the card and delete the two drop-downs for hour and minute and the separator and add a Text Control (I will call it TxtTime1 here and will use DateValue1 as the Date Picker name). Set the DelayOutput of…
-
Excel Data – Paste and Patch
Have you ever want to grab a block of Excel data, paste it and display in Power Apps, then patch it to your data source as new records? The process involves a bit of user discipline grabbing the correct columns, but it works. The first bit requires two controls – a Text Input set to multi-line and expanded appropriately and a HTML Text box for displaying the result in a structured manner. Below is an Excel sheet that has simply has the content copied and then pasted into the Text Input The top section is the Text Input and the bottom a HTML Text box with the HtmlText of This displays the data in a structured column manner…
-
Send selected attachments on an email directly from Power Apps
Have you ever wanted to send only some of the attachments on your record via email to someone? The solution is actually quite straightforward, but requires a bit of trickery not evident in the picture below. The attachment control is a standard item in a form displaying the attachments on a record (I called this one acEmail ) – there are no modifications to it. The check boxes shown however are in a gallery placed “on top” of the attachment control – I called it galAttach here. You may have to adjust the TemplateHeight to get it to “line up” properly with the attachment control. The Items of this gallery are essentially a copy of the data in the attachment control. Two labels…
-
Dynamically filtered multi-select check boxes
Firstly, my thanks for the inspiration for this to Reza Dorrani in his great video. Please refer to it if necessary for the checkbox gallery insertion process. I am now taking this a couple of stages further with: – A short example of it working is below Firstly, if the code seems a little over-complex, it is due to some refreshing issues I had in testing and the below seems to work as intended. It is based off a test list of PC devices, but can be applied to any similar structure. As I mentioned, the primary radio control is stored in a Text field. For the secondary filtered item, create a Choice type column (as…
-
Search and autofill in text box based on List values
We are all used to web searches giving suggestions of possible values you want and Combo Boxes have a Search function, but Text inputs do not have anything built-in for this, so it should be useful to have this function as well. In the example below, the user starts typing and all matching values come up below. At any time they can press Enter and have the first (or only) matching value populate automatically in the Text Box. The process involves only three things – changes to the OnChange and Default of the Text box and a Label below. This example is from a test list I have, but will work on any list subject to size Delegation…