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…
Power Automate can populate a word document template with values and convert the document to PDF. Updating single text fields in a PDF is easy but implementing a repeating section requires different code. Repeating sections are typically used to display…
Power Apps find & replace tool is a powerful new feature. You can use it to quickly rename all occurrences of a variable or collection in your app. It is no longer necessary to change variable names one-by-one or download…
Power Apps can be used to collect data and display the results on a PDF document with the help of Power Automate. Populating text fields in a PDF is easy but figuring out how to add an image is not…