I recently discovered the new Power Apps comments feature. I love them. Comments are used to collaborate with other developers and give feedback on an app. They are also an excellent code review tool. Developers can discuss an issue in…
My name is Matthew Devaney, and I quit my 6-figure job as a certified professional accountant to become a Power Platform developer. I am self-taught developer who began learning the Power Platform at 32 years old. I did not go…
Power Apps new ParseJSON function can turn a text string into a record or table. It is especially useful when app is used to trigger a Power Automate flow and returns a value to the app. Power Automate only allows…
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)…