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