Practical Power Apps

Blog Index Author: Warren Belz 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. To summarise the options, I will be covering three types of images Captured by the device camera using a Camera control Uploaded into a Add Picture control Drawn using a Pen Input There are then three options for storing these images An Attachment to the item Stored in a SharePoint Library Written to a Multi-line Text field Preparing the Image So let’s get started and look at the basic structure of an image that is contained in one of these categories. Before an image can be stored, it must be “prepared” into a format called Base64 Text for its journey to the destination. This is done with a Power Apps function called JSON , which converts the image into a large text string.

Blog Index Author: Warren Belz 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: - The With() statement is effectively creating a (very) temporary variable/collection within the statement which only “exists” for the life of the statement execution. It is not Delegable in itself, meaning that it cannot “hold” more than 500-2000 records depending on your settings (I will refer to 2,000 here). However, if you can isolate less than this number with Delegable filters, then any statement using the resulting data is Delegable . You can also use this on an entire list (no Filter) with less than 2,000 records for the purpose of removing the Delegation warning. NOTE: If your With() statement potentially produces more than the 2,000 records, you will not get a Delegation warning