-
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…
-
Group Membership Management App
This App presents an easy way of managing groups and their memberships. It allows: – Adding members to groups (which also lists members of the chosen group) Deleting members from a Group Lising groups that a user is a member of Download the file here NOTE: The zip file is an exported (Legacy) package, not a Solution. I hope it is useful to you.
-
Displaying and saving time in 12 hour AM/PM format
When Power Apps sets up a Date/Time field, the hours are in 24 hour format. Have you ever wanted to work with a 12 hour AM/PM choice and display for the user ? Here is how Add another drop-down at the right with Items and the Default of this drop-down Then you need to change the Items of the Hour drop-down to and the Default of the Hour drop-down Now the Update of the Data Card for the Hour dropdown This all should now allow you to perform this function
-
Displaying Days, Hours and Minutes between two Date/Time values
Have you ever wanted to see exactly how many hours, minutes and seconds are between two selected date/time values. The formula below assumes that the user has selected from two Date Pickers with the Hour and Minute value from drop-down controls (as are provided by a standard Power Apps Date and Time field controls). To explain briefly the logic
-
Locking down SharePoint so only Integrated App can be used
This is an issue that has been the subject of many questions and below is the series of processes which I believe adequately addresses the structure needed. Firstly, the three initial things to do (which I will not go into any depth with) are: – However, there are a number of inbuilt SharePoint functions that allow a reasonably knowledgeable user to circumvent these controls and do/see things they should not be able to do. The first thing to do is stop users from creating a Personal View to their liking. Firstly, go to Site Permissions > Permission Levels Personal Views Select Contribute and then at the bottom select Copy Permission Level A name is…
-
Allowing a user to add a non-listed value to a multi-value field
I have used cbData for the Combo Box and MultiField for the field name in these examples. It is easy enough to allow a user to add a custom value to a single select Combo Box with a Data Card Update of so it simply uses the SeachText if entered and nothing is selected from it (or uses the selection as normal). But what about multi-select columns ? One fundamental issue here is that the SearchText is only accessible/visible when there are no other items selected, but we want to retain what is there presently and add the new item, so one compromise is the user needs to delete existing items that come up with the DefaultSelectedItems, but we can still retain…
-
Shift numbered items in a gallery by more than one row
There are many posts on reordering a gallery with up/down buttons, but what if you want to shift an item a large number of places and re-order everything in between in one action ? The assumption here is that the gallery contains a sequential numeric field, is sorted by this field and the user wants to change a row item to another position with the result that the gallery will then be sorted in the new order.Firstly, there are two possibilities on the number shift – it could be larger or smaller than its original position, so that needs to be dealt with separately. I have also allowed for there…
-
Detecting mobile device app operation
There is a generally simple method of detecting a mobile device where being true will detect a mobile device (as opposed to a PC), but we now have “cross-over” devices with these sensors being used as office PCs – so how do we detect them? What we really need to know is if the app is being run in a browser or on the Mobile App.One method I have tested which works is this – try to save a file with SaveData – at App OnStart, run this and then test gblDevice for the value.NOTE: This will only work properly on a PC / browser if this setting is switched off in the App.
-
Email PDF of screen without (and with) a Flow
The need to send a screenshot (it could be a form, invoice or anything else) as an email attachment straight from Power Apps is highly useful.The process actually is very simple using the PDF() function. Firstly, a temporary variable needs to be created with the file content and that used to form the email attachment. This one is to the user, but could be to any address. Note also you can send the same content to a Flow, but need to convert it to Base64. then do a base64ToBinary conversion in the Flow. I have also added an action to create anew file in a SharePoint Library at the bottom.
-
Choices columns – manage in SharePoint by Admin, but use Text field for Power Apps
If you have read some of this site’s blogs, you may deduce that I have an aversion to complex column types for data fields in Power Apps unless there is a good and necessary reason to use them. On the lesser end of this scale, Choice columns cannot be used to Sort by in a Delegable manner and still in general add a level of complexity that may not be needed if you are only using single choices.You can of course “hard code” them in Power Apps Drop-down /Combo Box controls, but any changes require design privileges in Power Apps, not something you always want. So how do you write back to the desirable…