Matthew Devaney

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…

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…