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
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
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
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
