6 steps Introduction: We will learn how to get the attachment control from a form. As of writing, there is no option to insert a single attachment control to the canvas. Therefore, we need to “steal” from a form. Step 1: Add a data source. It can be SharePoint, Dataverse, or any other. In this […]
Power Apps – Get an attachment control Read More »
7 steps Introduction: We will create a workaround where a vertical gallery has both a vertical and horizontal scroll. This is useful for table formats with many columns that cannot fit in a regular gallery. For this demo, we will create two columns but make the last one very long. Conclusion: To test, you can
Power Apps – Vertical Gallery with horizontal scroll Read More »
10 steps Introduction: We will set up a gallery to appear like a table with borders for each cell that adjusts based on the text content of each cell.. Conclusion: To test, view the app in play mode and you can see that your table cells automatically adjusts depending on the length of the text
Power Apps – Bordered auto-height row using gallery Read More »
3 steps Introduction: We will set up controls where we turn collection data into an HTML table using an HTML label control. This table is dynamic based on the number of rows in the collection. Conclusion: Test it by clicking the Button1 (“Add”). You will see that as you add rows to the collection, the
Power Apps- Collection data to HTML table Read More »
3 steps Introduction: We will build a set up on to add up text with the format HH:MM. The result will the total hours in HH:MM. Take note that the result is total time (e.g. 56:33) not a point in time (e.g. 12:45 AM) Conclusion: Test the formula out by putting hours and minutes separated
Power Apps – How to sum up hours and minutes in text format Read More »
6 steps Introduction: We will create a demo set up on how to re-arrange gallery items with a combo box. This can be an alternative solution because as of writing, there is no out-of-the-box drag and drop control. We will use a combo box instead of a dropdown because with a combo box, we can
Power Apps – Rearrange gallery items using dropdown Read More »
2 steps Introduction: Using a scrollable canvas can be useful for certain cases compared to a horizontal container. But it is not found in the “Insert” menu in Canvas apps. So you will have to “steal” it. Step 2: You may use this screen or copy and paste (“steal”) the Canvas1 control into your desired
Power Apps – How to get a scrollable screen / control Read More »
2 steps Introduction: As of writing; dropdowns, date pickers and combo boxes under classic and modern controls do not have a border radius property and therefore cannot have rounded edges out-of-the-box. But it is possible with a simple workaround. This tutorial will use a dropdown as an example. Step 2: Insert a dropdown inside the
Power Apps- Curved Dropdown and Date Picker Border Radius Read More »
6 steps Introduction: We will create a set up to demonstrate a working reference number where the serial number will reset based on change of either the day, month, or year. This tutorial uses a collection for demonstration purposes only. Step 2: Insert a date picker named DatePicker1 beside Dropdown1. Conclusion: To test it out,
Power Apps – How to do reference numbers with dates and serial number Read More »
5 steps Conclusion: To test it out, put any number with decimal values on TextInput1. The top labels (Label1 and Label2) will give you the whole number and the decimal with the leading zero and decimal point. The bottom labels (Label3 and Label4) will give you the whole number and the decimal values without the
Power Apps – Split Decimal and Whole Number Read More »