Design
-
Horizontal scrolling of a gallery
This is a method of giving effective horizontal scrolling on a gallery using nothing but a slider and some dynamic positioning and visibility of the fields displayed. It is not perfect, particularly if you have large width differences between the labels (so the gallery width would need to reflect the largest combination of visible labels), but it works. I will give an example using 6 labels in the gallery, where 3 fit across and another 3 are “hidden” to the right. I have called the Labels Label_X for ease of reference. First, put in a Slider with the Min of 0 and the Max of the number of hidden labels (in this case 3). Your Labels X needs to reflect the position…
-
Simple effective editable Gallery
The following is a guide to constructing an editable gallery with the user able edit in-line records and save back to the data source. It has functionality to ensure only one record can be chosen and no others selected unless the target is saved or cancelled.NOTE: This example uses Classic controls you will need on some Modern controls to change to the equivalent references. Also the example uses SharePoint. Firstly, but this at Screen OnVisible Insert a blank Vertical Gallery and use a SharePoint List (or collection based on a SharePoint List) as the Items. Any normal filters can also be used. If ShowColumns are used, ensure that the ID…
-
Enter time using a single drop-down with intervals (like Outlook)
Have you ever wanted to replace the two Hour & Minute drop-downs with a single drop-down showing set intervals (example here is 15 minute like Outlook).This is quite easy to do using a Date Picker and a single drop-down as below The Date Picker is a standard item (you can leave the one that Power Apps creates when a Date/Time field is added) and there are three settings you need to know (two on the drop-down – you can use the one provided for Hours if you want to and delete the Minute item) – the Items and Default and also the Update of the Data Card. Firstly the Items of the drop-down (in this case) reflects 15…
-
Form control – add vertical multiple controls and single control on same line
A question often asked is why multiple different height data cards cannot fit on the same line – essentially “stack” one column with multiple Cards. Have you ever had a Form looking like this And you want it to look like this There is a really simple way of doing this (which seems obvious when you see it), using a standard Form and SubmitForm and moving a couple of controls. Firstly (in the example above) with a Columns setting of 2, So what is happening here? Essentially when you cut and paste (moved) the Text Input from the Type Data Card, it still retained its Update property linked to the Text Input you just moved to the Device Data Card, so it…
-
Changing the Authoring Version of an App
There are times unfortunately that Power Apps releases a new Authoring Version in the Design Studio that does not always perform as expected. Any app last saved in this new version may be affected by whatever the deficiency is and an updated version of an app with minor changes may suddenly develop unwanted characteristics. The easiest way to see if it is the version that is causing these issues is to re-publish the app on an earlier version, the best being the last one (before the most recent) it was saved in and was working properly. This is quite a straight-forward process, but can be a little confusing if you…
-
Alternate shading in Galleries
One of the things that improves the presentation of an app and the readability of a gallery is if “every other” line was able to be shaded. There is no built-in function for this in Power Apps, but it can be done quote easily. The first thing you need to do is “number” the entries of the gallery. As you also may be sorting and filtering the gallery during the operation of app, this numbering needs to be dynamic to the gallery contents as it changes. The following is an example of a gallery with two filters based on a list, however it could be any sort and/or filtered gallery.…
-
Using Variables when you change the standard design
You do not like the color scheme, font and sizes that Power Apps provides as “standard”. The Themes also do not exactly meet your needs. If you are going to make changes to the design, I recommend you go the extra effort and capture all of this at App OnStart in Variables. To explain, I generally use a colour scheme around a base colour (generally a dark one) with various shades of ColorFade on different elements. If you set this base color as a Variable (as well as the more commonly used lighter ones), you simply refer to these in the elements of all the controls. So for example (this is a really dark blue) Sets the base,…
-
The rogue wrap-around
When you are designing a (particularly larger) form with a lot of fields and have many card widths different to the standard “equal width” automatically set by Power Apps, you get a long way in, change a card width and suddenly the whole screen of cards rearranges itself to something quite different than the items per line you planned? Sometimes this is a nightmare to fix (you fix one line and another breaks). So how do you avoid (or more accurately) mitigate the effect? Firstly, frequently you will have a need for different numbers of cards per line and within this naturally different card widths. You may also have a…
-
Duplicating a Canvas App Form into SharePoint Integration
You have just finished your Canvas app and now you would like users to also have the facility directly from the SharePoint list. You already have the form in the Canvas App set out the way you want, and now need to duplicate this on SharePoint You may also have moved your SharePoint List and want to duplicate the existing Form to the new one. This is a perceived barrier that really is not one. A lot of people envisage having to maintain two apps or go for the integration option and have to manage the limitations this brings. Any screen or form created in a Canvas App or on…
-
Roster Calendar App
This is a simple one-screen Roster Calendar, which could be used for Annual or SIck/Personal Leave (we have four/two weeks per year of those in Australia) or any other days you may want to track staff availability. This is the link to download the zip package of the app – it is a (Legacy) Zip package and needs to to imported as such. There will also be an error initially as there is no data source attached. Create a SharePoint List called RosterList with three columns and connect it. The app has two filters at the top for year and month and the calendar is a week per line with Sunday to…