Using the With function it’s possible to create something very similar to a variable that just exists within the With statement in which it is created. I call this a ‘Control Variable‘. It isn’t an offical Power Apps variable and you …
A Power Apps expanding Gallery is a fantastic way to allow users to drill down to a greater level of detail without overloading their screens. They can also be used as a menu for navigation. The key is to use …
The With function is a great way to simplify formulas, reduce the query load on Data Sources and therefore improve performance So when I say create ‘Control Variables using the With function’, what exactly do I mean? Well, it’s not …
The Reset function is really useful to clear any unsaved changes in a field and return the existing stored data. Using Galleries, sometimes you want to reset a specific record. Other times it’s useful to clear unsaved changes for all …
The Table function is used in Power Apps to manually create a Table within a Power App control rather than retrieving data from a networked data source (such as SharePoint) or a Collection. But what is it used for and …
In this short post on Power Apps Variables, I’ll summarise how values and single records are assigned and updated. I’ll also cover what can’t be done with variables, so time isn’t wasted trying – something that has caught me out …
Here are the tips I use to optimise Power Apps performance. Because Power Apps is so flexible and often has several ways of achieving the same result, I know from experience that it’s easy to inadvertantly slip into bad coding …
25 Great Tips to Optimise Power Apps Performance Read More »
Do you want to retain user settings or preferences when an app is closed, but not have to write back to a data source? Power Apps SaveData and LoadData functions allow you to save data locally to a mobile device …
Microsoft released their new AI Invoice Processing capability in preview last month. I took it for a test run using Power Apps and Power Automate. How do I rate it? Read on to find out! AI Invoice Processing I’ve been …
In this article I’ll show how to display scraped web data in Power Apps. For this exercise we’ll use the Premier League Table from the BBC Sport website. You’ll see how straightforward it is to use Power Automate Desktop to …
Have you ever wanted to extract data that isn’t available using Connectors? In this post, I’ll explain web scraping with Power Automate and give you some great pointers on the best approach Web Scraping with Power Automate Connectors Vs Desktop …
In the last post I set myself the challenge of creating an dynamic Power Apps Dropdown box that shows the number of records in a table that match the Dropdown selection criteria. The requirement was to not have hardcoding so …
Power Apps Dropdowns don’t need to be dull! There are many cool features you can add to Dropdowns. In this post I’ll demonstrate 3 techniques to save time and improve usability Power Apps Dropdowns Dropdown 1: Here I’ve taken 2 …
Aligning data from multiple tables can be achieved in several ways. Cascading Power Apps Galleries, creating virtual tables using AddColumns, even simply using the humble Label. These techniques can be combined together to deliver the best solution Galleries and Relational Data …
Even more tips on using Galleries to find a specific records in a data table! In this article, I’ll explain how to search across multiple columns. Once we have a reduced set of data, SortByColumns can be used to dynamically sort Galleries Table …
The Power Apps Filter and StartsWith functions are very flexible and can be used to search single or multiple columns in a table In this article I’ll show how to give users the option to choose which columns to search Filter …
No need to restrict a Power Apps Gallery search to a single method, multiple search options are possible. This approach uses either cascading Dropdown Boxes to refine a search, or if you already know what you are looking for, type …
Dropdown boxes are really useful when used in conjunction with a Gallery to drill down and reduce a large data set to a much smaller one, so specific Records can be identified The best way to construct Dropdown boxes is …
There are many sites to help with your UI/UX for Power Apps development, but here are my favourite online resources. As well as giving you some great ideas they’ll also save lots of time with pre-written code! Online Resources UI/UX …
SVGs can be used dynamically in Power Apps such as to change their color or to create animation. This article explains a couple of examples of how using dynamic SVGs in Power Apps can be very helpful to users. The …
