-
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…
-
Prevent the use of Special Characters in a Text input
This process prevents a user from saving a range of Special Characters if entered in a Text Input. This may have other application as well as the Text Box example. A working example is shown below So how does this work? Firstly do a Collection of all special characters (you can do this at Screen OnVisible) by using their ASCII value ranges. This puts 31 Special Characters into the collection under the field FieldNo.Below is a gallery (with wrap at 4) showing the characters Note you may want to allow some such as Underscore _ (95) and will have to adjust the above to suit.Now put this on the OnChange of the Text Box…
-
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…