Helpful hints
-
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 the normal base64ToBinary in the Flow
-
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…
-
A guide to posting on the Power Apps Community forums
This site is often used as a reference tool for user’s posts on the Power Apps Community Forum.The below is some guidance of the things that users should consider when engaging with the responders, who are giving their time and best efforts to assist with their Power Apps journey and is designed as general guidance to the facilitation of a quick and accurate solution for your issue. This guidance is broken into four important sections Before you start When you post When you receive a response When the issue is solved Before you start Before you start constructing your post – please consider the following: – The responders on this…