-
PowerApps SharePoint Images – Storing and viewing
Content In this blog, I have tried to put together the various options for storing and viewing images in Power Apps, using SharePoint as a data source. How you will do it in your app will depend on your business needs and the way you want your users to interact with these images. Back to top Power Apps V2 Trigger The introduction of the Power Apps V2 Flow trigger has simplified the handling of images of all types in both Power Apps and Power Automate. The format to send the content and file name is Examples Add Picture Control Camera Control Attachment Control Pen Input The Flow is much simplified…
-
Dynamic expanding multi-level menus
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: – To the right of these, there is a picture of…
-
With() Statement managing Delegation
Content In this blog, I will discuss a method that will allow the combining of non-Delegable filters with Delegable items in a way that will remove Delegation warnings and combine the process into one statement. There are some important things to remember in this: – So how does this work? With() can contain a single Value, a Record or a Table equally well. In this case, it is filtering a Table with a smaller Table being the output. If you look at the syntax, it is almost identical to UpdateContext(). Back to top Pre-filtering As an example, if my list was 10,000 records, but if after Filtering to show only the Status values Planned and In Progress, the result was always less than…
-
Power Apps Delegation – SharePoint
Content In this blog, the content is focused on users who have decided to use SharePoint as the data source for their Power Apps suite (generally for licensing costs). Other factors also to be considered, include whether any direct SharePoint direct editing control will be given to users and if so, if any of this needs data sheet “quick edit” access. This discussion assumes SharePoint datasheet editing is not needed and any interaction will be on Power Apps integrated forms. I mention this specifically as some field types (Choice, Lookup) require different controls in SharePoint datasheets for user input.I have also assumed that the Data row limit for non-delegable queries in Advanced settings has been set…