Welcome to the Power Apps Coding Standards For Canvas Apps. In this guide you will find 50+ pages of coding rules, guidelines and best practices I use everyday to create Power Apps Canvas apps. I have spent the last 3…
Table of ContentsLoad Multiple Datasets ConcurrentlyWrite Formulas That Use DelegationCache Data In Collections And VariablesLimit The Size Of Collections“Batch Patch” Multiple Changes To A Datasource Table At OnceReduce Code In The App’s OnStart PropertyMinimize Number Of Controls On A Single…
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…