Practical Power Apps

Author: Warren Belz  Practical Power Apps has been designed as a guide for users venturing along their Power Apps Journey. The following topics are discussed Power Apps Delegation (SharePoint)  A general guide to challenges a user may encounter managing Delegation Using the With() statement to manage Delegation issues Some workarounds to lessen the burden Power Apps SharePoint Images Storage and viewing of various type of images Power Apps Slide show A nice visual addition to your app Dynamically expanding two-level menus Get the look and feel of windows menus in Power Apps Office365 Groups for user control inside Power Apps Do more than simply control access Many to Many Filter Explore multi-level filters from a Combo Box

Blog Index Author: Warren Belz As users have become accustomed in many applications, top menus with context-sensitive sub-menus are the norm, but are not part of the standard Power Apps “suite”, so creating this type of function is a useful enhancement to user experience using a “look and feel” familiar to them. Firstly, the App and the Excel file (which is already imported) can be  downloaded here.   I will start this a bit backwards, showing the end result of a three-level menu based on a list as below and then discuss what needs to be done to accomplish this. These are galleries with one field in each: - galManDevice  shows the PC manufacturer list. galTypeDevice  is for all device types belonging to the manufacturer. galModelDevice   shows all models of the type from the manufacturer. To the right of these, there is a picture of the chosen device and the specifications. So what is happening here? There are some things that need to be done to the galleries and panels to control the

Blog Index Author: Warren Belz Office 365Groups have many uses, particularly when Security Enabled, for controlling user authorities to access individual Power Apps while also allowing the same group to control access to the data source ("all in one place"). However, you can also use the user’s membership of any group (not necessarily having access to the app and not needing security enablement) to control what they can do and see once the app is opened. This blog discusses the options for enabling the functionality. One important thing you need to do first is getting the  id  of the group or groups you want to work with. You can use the  DisplayName  (also as shown below), but if this is changed, the process will not function whereas the  id  will always remain the same. Fortunately, getting the  id  of the group is easy, with the simplest way being to put a gallery (I called it  galGroups  below) on the screen with the Items Office365Groups.ListOwnedGroups().value   and in