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 Contents: • Load Multiple Datasets Concurrently • Write Formulas That Use Delegation • Cache Data In Collections And Variables • Limit The Size Of Collections • “Batch Patch” Multiple Changes To A Datasource Table At Once • Reduce…
Table Of Contents: • Design Empty States • Refresh Gallery To Show Current Data • Reset The Gallery Scroll Position • Filter Large Datasets In A Gallery • Define The Gallery Sort Order • Require A Button Press To Update…
Table Of Contents: • Restrict Text Input Values • Validate Form Data • Implement Error Handling • Protect Against Loss Of Unsaved Data • Use A Single Form To Create, Edit & Display Records Restrict Text Input Values When a…
Table Of Contents: • App Checker • Power Apps Code Review Tool • Source Code Review • Functional Testing & User Acceptance Testing App Checker App checker identifies potential issues within a canvas app. A red dot will appear when…
Table Of Contents: • Screen Names • Control Names • Variable Names • Collection Names • Datasource 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…
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} ) ) ) Here’s how it…
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)); Here’s how it works: The Distinct function returns a one-column table of unique values for a field. But…