Matthew Devaney

Table of ContentsDesign Empty StatesRefresh Gallery To Show Current DataReset The Gallery Scroll PositionFilter Large Datasets In A GalleryDefine The Gallery Sort OrderRequire A Button Press To Update Search ResultsAvoid Nested GalleriesUse Flexible Height Galleries Design Empty States Include an…

Table of ContentsRestrict Text Input ValuesValidate Form DataImplement Error HandlingProtect Against Loss Of Unsaved DataUse A Single Form To Create, Edit & Display Records Restrict Text Input Values When a text input should only contain a number, change the default…

Table of ContentsApp CheckerPower Apps Code Review ToolSource Code ReviewFunctional Testing & User Acceptance Testing App Checker App checker identifies potential issues within a canvas app.  A red dot will appear when there are formula errors or runtime errors to…

Table of ContentsScreen NamesControl NamesVariable NamesCollection NamesDatasource Table Names Screen Names A screen name should clearly describe its purpose in 2-3 words ending with word “Screen.”  Use proper-case.   A screen-reader will speak the screen name to visually-impaired users when the…

Generate row numbers for a Power Apps collection with this formula. Copy and paste this code into your own app. // Generate row number code ClearCollect( colSolution, ForAll( Sequence(CountRows(colMyCollection)), Patch( Last(FirstN(colMyCollection, Value)), {RowNumber: Value} ) ) )Code language: JavaScript (javascript)…

Hide the Power Apps navigation bar in play mode by adding hidenavbar=true to the end of the app’s URL. I recommend you do this when providing users with a link to any canvas app so it displays as large as…

This strange hack makes it possible to quickly update the style of all DataCardKeys and DataCardValues in a Power Apps form. Normally its simple to update multiple controls at once. Just select a group of controls then change the desired…

Remove the duplicate rows from any Power Apps collection with this 1 line of code. //Duplicate removal code ClearCollect(colSolution, ForAll(Distinct(yourCollectionName, ThisRecord), Result));Code language: JavaScript (javascript) Here’s how it works: The Distinct function returns a one-column table of unique values for…

Using a Power Platform service principal account is an awesome way to securely run your Power Automate flows. Service principals have system the administrator role and stay logged permanently stay logged in with a special type of permanent password called…

You, my fellow human, are about to become better at writing Power Apps code.By following a coding standard you can make your apps easier to maintain and have less bugs. High-quality code is simple to read. It follows a consistent…