-
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…
-
Constructing your first Power App – before you start
This might seem a bit of a strange subject title, but in the words of a great man of the past It is a bit like putting a roof on a house then wondering whether the foundations will hold it up – you need to construct your foundations to allow for the things you might want to do in the future. You have opened your new shiny new O365 box and had a look inside. You have purchased an E3 licence as you do not want the additional expense of premium features and are now wondering what you can do with what you have. The answer is quite a lot…
-
Power Apps Slide Show Into Screen
This image show can be used on any screen, but would be good as a company intro when the app is opened. The example above has three images, but as many as required can be loaded. What is going on is fairly simple. The three images are firstly loaded into the Power Apps Media Next there are three Timer controls in this one (which are hidden) – one for each image displayed. At App OnStart(or Screen OnVisibleif that suits), initialize the first Timer with a Variable Now the first Timer has the following settings AutoStart: true Duration: 4000 (4 seconds, but set to whatever you want) OnTimerEnd: Set(vTimer,”Start2″) starts the second Timer Start: vTimer=”Start1″ Repeat: false Reset: false The…
-
Using Office 365 Groups for Security/Control inside Power Apps
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. NOTE: The Office365Groups connector needs to be added to your data sources to implement the concept below. One important thing you need to do first is getting the id of the group…
-
Many to Many Filters
This article discusses the example of a multi-choice field in SharePoint with a multi-choice Combo Box in Power Apps filtering the possibility of ANY selected field in the Combo Box matching ANY stored value in the list which is stored in a Complex (Table) field. Many on Many queries can be done directly in a Filter, but are not Delegable. To do this, firstly a Table needs to be created using ForAll addressing each of the Combo Box selected items to see if any are contained in the multi-select Choice field The output of the Combo Box has been assumed as .Value. If it is based on a field name, change this. We are not…
-
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…