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