Introductory Guide to Using & Maximizing Microsoft Power Apps
Image Source:
Power Apps
Sep 19, 2023 1:00 PM

Introductory Guide to Using & Maximizing Microsoft Power Apps

by HubSite 365 about Timo Pertilä (Forward Forever) [MVP]

Power Platform Consultant, Microsoft Business Applications MVP

Citizen DeveloperPower AppsLearning Selection

Improve your Microsoft Power Apps with expert advice: maximize efficiency, improve maintainability, and use specific techniques for smarter results.

Summarized Blog Content

The blog post by Timo Pertilä is an insightful discussion about some common patterns seen in first and second Power Apps made by developers. These are tips and tricks one learns from examining others' work, often revealing new methods, and strategies of accomplishing tasks better in Power Apps.

  • The author talks about the misuse of LookUp commands, where developers often unnecessarily repeat the LookUp function giving redundancy in the code.

  • Next, he discusses the redundant use of variables to check whether a line on the form is being viewed, edited or created. The form status can be directly checked from the form itself.

  • The article then moves on to the topic of variables in Power Apps, highlighting the differences and use-cases of global and local variables. Global variables, while easy to use, are performance-heavy and should be used only when necessary.

  • You shouldn't group controls due to the problems that it can cause when trying to modify them. Instead, Pertilä recommends using containers for easier management.

  • Another discussed issue is the repetition of control, especially in navigation. Navigation is best implemented as a gallery, and if used on several screens, should be implemented as a component.

  • The author then talks about redundancies in code due to duplications in multiple places without a significant reason.

  • Lastly, the blog post discussed the issues with dependencies between screens, which can complicate optimization and potentially causing unusual situations.

Main Takeaways

Understanding the potential pitfalls and inefficient design choices is crucial in creating high-quality Power Apps. Efficient use of LookUp commands, smart management of variables, effective usage of groups and containers, reducing repetition of controls and unnecessary code, and cautious management of dependencies between screens are the key areas to focus on. More efficient, maintainable and elegant solutions lie in the adoption of recommended practices, contributing to a better user experience and performance of the apps.


Read the full article That very first Power Apps

Learn about That very first Power Apps

The blog reviews the usage of Power Apps, focusing on the frequent implementation mistakes identified in many beginner's first and second Power Apps. These common errors are not due to stupidity but inefficiency, which could be rectified to make Power Apps usage more effective and elegant.

One such inefficiency highlighted is the unnecessary use of LookUp commands. Developers often use the LookUp function to fetch already available customer data, which is inefficient and quite redundant. Instead of using a formula such as LookUp(Accounts, 'Account Name' = galAccounts.Selected.'Account Name').'Account Number', the author recommends using simpler references like galAccounts.Selected.'Account Number'.

  • The author suggests that developers need to understand that all the data in the gallery row is easily referenced, and repeated fetching of the same is wasteful. Problems occur when a gallery or variable doesn’t have a value for all fields in the row, leading developers to fetch the data again.
  • The reason why there may be missing values in the rows is usually the optimization performed by the platform. It reads that the field, not required, is thus not included while fetching information. In such cases, the advisable action would be to adjust optimization settings so that all fields are always included in the result set.
  • In addition to this, the author points out that unnecessary LookUp functions can also be eliminated using the With function. This function can streamline data requests by reducing redundant lookups.

To learn more about this topic, readers are advised to explore more Power Apps exercises and practice projects to fully understand common mistakes and the most efficient solutions.


More links on about That very first Power Apps

First, FirstN, Index, Last, and LastN functions in Power Apps
Feb 22, 2023 — The FirstN function returns the first set of records of a table; the second argument specifies the number of records to return. The Last ...
PowerApps Tutorial: How to build your first Power App
Mar 18, 2021 — So firstly open and signup in PowerApps studio as depicted in below screen. Click on the new menu. Here you can select the layout template and ...
PowerApps First, FirstN, Last, and LastN function with ...
Mar 16, 2021 — PowerApps FirstN is a function that helps to return the first set of records of a table whereas the second argument defines the number of ...


Microsoft specialist, Microsoft certified professional, Microsoft certified expert, Microsoft solutions expert, Microsoft technology expert