Contact Initial consultation

Template for businesses

Performance Check for Power Apps.

Product language: German. An English edition is planned.

Review and rate your canvas apps and make targeted improvements to speed them up: 64 checkpoints in seven areas, an Excel workbook that automatically analyzes and prioritizes, a report template, and a handbook that explains every review step. This helps you identify where your app is losing time and use measurements to demonstrate what the optimization achieved.

Notify me when availableWhat's in the package
  • 58-page handbook
  • 64 checkpoints
  • 7 areas
  • €79 plus VAT
Performance-Check-Power-Apps_Arbeitsmappe.xlsx
Overall result72 %
Action required
Open actionsA 3B 5C 4
  • Platform & devices86 %
  • Data retrieval58 %
  • App structure & startup64 %
  • Formulas & variables71 %
  • SharePoint90 %
  • Dataverse, SQL & gatewaynot counted
  • Quality & operations75 %
StartFact sheetMeasurement logReviewAnalysisAction plan
Sample view of the workbook with sample data selected for illustration

01When the check pays off

Slow apps don't get used.

The Performance Check gives your team a clear method: measure, review, rate, improve, and document the result. No prior knowledge of performance optimization is required; the method draws on experience from many optimized apps.

The app is too slow

Startup takes a long time, lists load sluggishly, and the spinner keeps turning when saving. The check shows what is causing it and what helps most.

You have taken over an app

A service provider has changed, or the person who built the app is no longer there. The check quickly gives you an overview.

Before the big rollout

Your pilot team is expanding to hundreds of users. Check whether the app stays fast with more data and more users accessing it.

As a regular review

Data volumes grow, and the platform keeps evolving. With the same workbook, you review your apps on a fixed schedule.

02The package

Three files, one complete check.

You receive a ZIP package with all files, ready to use immediately and for any number of your own apps.

XLSX

Workbook (Excel)

App fact sheet, before-and-after measurement log, ratings for all checkpoints, automatic analysis with a traffic light status indicator, and an action plan sorted by priority.

DOCX

Report template (Word)

Structured template for the review report with a summary, results for each area, measurements, findings, and an action plan.

Cover page of the handbookPDF

Handbook (PDF)

Step-by-step procedure, using the Power Apps tools correctly, measuring correctly, and all checkpoints with review steps, criteria, actions, and examples.

The sheets of the workbook

  1. Fact sheetInformation about the app. The information on the data sources determines which checkpoints count
  2. Measurement logIndividual measurements, three times each, with median and metrics from Monitor and App checker, before and after
  3. ReviewAll 64 checkpoints with review steps, criterion, and action
  4. AnalysisResults for each area with a traffic light status indicator, a chart, and a top 10 list
  5. Action planAll outstanding items, automatically sorted by priority; completed items are removed

03How it works

In six steps to a result backed by data.

The workbook guides you from measurement to report. It automatically calculates results, traffic light statuses, and priorities.

  1. Prepare

    Fill in the app fact sheet, clarify access, and define the app's most important processes.

  2. Measure baseline values

    Measure startup, screen changes, search, and saving three times each, read metrics from Monitor for a fixed period and counts from Power Apps Studio at the time of measurement, and record everything in the measurement log.

  3. Review

    Go through the checkpoints area by area and rate each one as "Met," "Partially met," "Not met," or "Not relevant."

  4. Analyze

    The analysis shows results for each area with a traffic light status indicator, as well as the overall result.

  5. Plan and implement actions

    The action plan sorts all outstanding items by priority. Set responsibilities and deadlines, then carry out the actions.

  6. Remeasure and report

    Remeasure under the same conditions, record the result in the review report, and plan the next review.

04The checkpoints

64 checkpoints in seven areas.

From the platform through data retrieval, startup, and formulas to SharePoint, Dataverse, SQL Server, and operations. The workbook automatically excludes checkpoints for data sources your app does not use from the rating. Here are all questions at a glance; review steps, criteria, and actions are in the package.

01Platform & devicesData source, region, network, limits, devices, and browsers7
  1. P01Does the data source fit the number of users, data volume, and type of use?
  2. P02Is the Power Platform environment in the region of most users?
  3. P03Does the network allow all Power Apps service addresses without restriction?
  4. P04Are the licenses' request limits sufficient for actual usage?
  5. P05Does the app run in browsers that Microsoft supports for Power Apps?
  6. P06Does the app run without being slowed down by browser extensions?
  7. P07Has the app been tested on all device types actually used?
02Data retrievalColumns, delegation, query sizes, and targeted queries9
  1. P08Is explicit column selection turned on?
  2. P09Does the app retrieve only the columns it needs for display and logic?
  3. P10Are all queries on data sources that can grow beyond the data row limit delegable?
  4. P11Has the data row limit for non-delegable queries been chosen deliberately?
  5. P12Do the start screen, galleries, and tables load only small amounts of data by default?
  6. P13Do galleries avoid a separate query for each row (no LookUp or Filter in the gallery)?
  7. P14Does the app query each piece of information only as often as necessary?
  8. P15Does the data source handle joining, filtering, sorting, and grouping?
  9. P16Are large amounts of data loaded page by page instead of all at once?
03App structure & startupStartup, screens, controls, components, media, and publishing14
  1. P17Does App.OnStart contain only what is really needed for startup?
  2. P18Are values and data for the whole app defined as named formulas in App.Formulas?
  3. P19Is the start screen defined via App.StartScreen?
  4. P20Is the start screen lean (few controls, few queries)?
  5. P21Has app preloading been checked and deliberately configured?
  6. P22Do all screens have a manageable number of controls?
  7. P23Do formulas avoid references that unnecessarily load other screens?
  8. P24Are recurring building blocks built as components instead of copies?
  9. P25Do search fields delay input processing (DelayOutput or TriggerOutput)?
  10. P26Are images and media compressed and embedded in a suitable size?
  11. P27Have unused media, data sources, screens, and controls been removed?
  12. P28Is "Debug published app" turned off?
  13. P29Is the app republished regularly?
  14. P30Are very large apps sensibly split and formulas of manageable length?
04Formulas & variablesCollections, variables, saving, recalculations, and efficient functions12
  1. P31Do independent data retrievals run in parallel with Concurrent?
  2. P32Do collections contain only small amounts of frequently used data?
  3. P33Is cached data refreshed according to a plan?
  4. P34Does the app save many records in a batch instead of individually?
  5. P35Is ForAll inside Collect and not the other way around?
  6. P36Is the logic centralized in manageable formulas rather than copied and nested?
  7. P37Does the app avoid unnecessary timer queries and frequently triggered recalculations?
  8. P38Do galleries use AllItems only when needed, and is TemplateSize set appropriately?
  9. P39Are variables used selectively (few global variables, with context variables set together)?
  10. P40Does the app use efficient function patterns (ClearCollect, CountIf)?
  11. P41Does the user interface remain usable during long operations and provide feedback?
  12. P42With flows, does the app wait only for what it needs immediately?
05SharePointColumns, indexes, delegation, and large lists5
  1. P43Do the lists used contain only a few complex columns (lookup, person, calculated)?
  2. P44Are the lists lean, and are images and attachments loaded only selectively?
  3. P45Are the columns by which large lists are filtered and sorted indexed?
  4. P46Does the app avoid non-delegable searches and counts with SharePoint?
  5. P47Do queries remain fast and complete even on very large lists?
06Dataverse, SQL & gatewayViews, indexes, data types, bottlenecks, and the on-premises data gateway9
  1. P48With Dataverse, does the app query views or filtered data instead of entire tables?
  2. P49Do galleries display images from Dataverse as thumbnails?
  3. P50For offline-capable apps, is the offline profile limited and synchronization measured?
  4. P51With SQL Server, does the app search with StartsWith instead of the in operator?
  5. P52Do the indexes in SQL Server match the app's filters and sorting?
  6. P53Are SQL read queries lean, and are complex calculations handled in the database?
  7. P54Does the SQL database run without bottlenecks (locks, waits, memory, tempdb)?
  8. P55Are all nodes of the on-premises data gateway up to date and running without errors?
  9. P56Is the gateway close to the database and designed for the load?
07Quality & operationsMeasurement, App checker, errors, tests, and ongoing monitoring8
  1. P57Have baseline performance values been measured and documented?
  2. P58Have all App checker errors been resolved and all messages assessed?
  3. P59Do data requests run without frequent errors (throttling, permissions, network, flows)?
  4. P60Does the app catch errors during loading and saving and report them clearly?
  5. P61Are the app's performance metrics continuously recorded and reviewed?
  6. P62Are the most important processes tested after changes, automatically for large apps?
  7. P63Have the most important processes been checked with realistic data volumes, roles, and concurrent access?
  8. P64Is the performance review scheduled as a regular task?

05A look inside

This is how each checkpoint is structured.

Background, review steps using the Power Apps tools, a clear criterion, and a specific action, often with a formula example. Here is one complete checkpoint as it appears in the handbook.

P17

Does App.OnStart contain only what is really needed for startup?

High impactMedium effortAll apps

Complex formulas in App.OnStart delay startup and data loading. By default, OnStart does not block, so the first screen can already appear while OnStart is still running. The formulas on this screen may then access variables that OnStart has not yet set. A call to Navigate in OnStart (no longer supported by Microsoft), on the other hand, forces the app to process OnStart completely before the first screen appears.

How to check

  1. Select App in the tree view and read the formula in OnStart.
  2. In Live monitor, count the data calls before the first screen and read their duration.
  3. If available, read the start screen's "Time to interactive" value in Monitor.

Met if

OnStart does not load large amounts of data and contains only steps without which the app cannot start.

Action

Define the first screen with App.StartScreen, define constants as named formulas, and load data only on the screen that needs it, ideally directly from the filtered data source. Anything loaded in OnVisible runs again each time the screen opens, so load only limited amounts of data there. Use Concurrent to group independent data requests.

// Instead of loading all orders into a collection in App.OnStart:
// gallery on screen scrOrders, property Items
Filter(Orders, Status = "Open")
Table of contents of the handbookPage with checkpoints from the handbook"Rate and analyze" page from the handbook

Check before you buy whether the approach and depth fit your app. The sample includes the table of contents, the introduction, the six steps from measuring to reporting, and four complete checkpoints from the Data retrieval section, on original pages from the handbook (in German).

Open sample (PDF, German) 196 KB

06Price and license

Buy once, use with the whole team.

One license applies to your company, all employees, and any number of your own apps.

The license terms apply. System requirements: for the workbook, you need Microsoft Excel 2016 or later or Microsoft 365 on Windows or macOS, or Excel for the web. For the report template, you need Microsoft Word 2016 or later or Microsoft 365. You also need a program for reading PDF files.

Purchase via Digistore24

I will sell my products through Digistore24, a sales platform for digital products. Sales will start shortly; until then, you can ask to be notified by email.

  • Seller and contractual partner: Digistore24 GmbH in Hildesheim, Germany. It sells in its own name.
  • Payment and invoice: Via Digistore24; the invoice is sent by email.
  • Download: After payment, you receive the link to the ZIP package. It is valid for 30 days and allows up to 10 downloads.
  • Content and license: The product materials are created by me, and my license terms apply. For questions about payment and invoices, Digistore24 will help; for questions about the content, I will.

07License terms

Clear rules for use.

The same terms apply to all my products: powerbunch GmbH's license terms for digital products. With the purchase, your company receives the company license. Here you can see the key points at a glance, followed by all sections in detail.

Your license

Company license

For all employees and other persons acting on behalf of the purchasing company.

  • Use by all employees and other persons acting on behalf of the purchasing company for any number of that company's own projects
  • Affiliated companies need their own license; client projects require a consultant license unless the product description permits them without one
  • The company may adapt the templates and use them as its own documents, but may not pass them on or sell them as templates
  • The company may publish work products internally and provide them to third parties for its own purposes
  • The company may incorporate code and formulas into its own software, flows, and apps and may also distribute or sell them, including as open source
  • Offer for businesses only, no entitlement to updates, no training of AI models with the product

As of November 1, 2026 · Version 1.0. On request, the consultant license is available for use with clients, and the group license for affiliated companies. This offer is directed exclusively at businesses.

08Prefer to have it reviewed?

I take a look at your app.

Would you prefer not to carry out the review yourself, or would you like a second opinion? I analyze your app and create a comprehensive report with specific recommendations, ordered by impact and effort. You carry out the optimization yourself, or I do it for you.

Purchase price credited: If you commission the app analysis within six months of purchase, I deduct the purchase price you paid for the Performance Check (excluding VAT) from my quote. This applies once per company.

Book an initial consultation on app analysisMore about the app analysis

09Questions and answers

Frequently asked questions

What distinguishes the check from the free guide?
The guide "Power Apps Performance: 50 tips" explains what makes a canvas app fast. The Performance Check turns this into a review: 64 checkpoints with review steps and criteria, a workbook that weights and analyzes your rating and sorts the actions by impact and effort, a measurement log for before and after, and a report template.
Which apps is the check suitable for?
For Power Apps canvas apps with any data source, for example SharePoint, Dataverse, or SQL Server. Many checkpoints also apply to custom pages in model-driven apps.
What prior knowledge do I need?
You should know Power Apps Studio and be able to read formulas. Every review step is explained in the handbook. For some points, such as network, gateway, or database, your IT department can help.
How many apps may I review?
As many of your own apps as you like. The company license allows all employees and other persons acting on behalf of the purchasing company to use the product. Affiliated companies, such as subsidiaries, need their own license. For each app, simply create a copy of the workbook.
May service providers use the check with clients?
External service providers may use the check on behalf of a company that has purchased the license, provided they use it exclusively to review that company's own apps. If you want to use the check as a consulting firm with your clients, you need a consultant license. It is available on request; just contact me.
Which programs do I need?
For the workbook, you need Microsoft Excel 2016 or later or Microsoft 365 on Windows or macOS, or Excel for the web. For the report template, you need Microsoft Word 2016 or later or Microsoft 365. You also need a program for reading PDF files. The workbook sheets are protected without a password so that formulas are not accidentally overwritten.
How do I receive the files and an invoice?
You buy through my sales partner Digistore24 (Digistore24 GmbH, Hildesheim, Germany). Digistore24 is your contractual partner for the purchase, receives the payment, and sends you the invoice by email. The VAT treatment depends on your company's registered office and the details provided during checkout. Immediately after payment, you receive the link to download the ZIP package. It is valid for 30 days and allows up to 10 downloads, so please save the files right after your purchase. For questions about payment and invoices, Digistore24 support will help; for questions about the content, I will.
How up to date is the content?
All information has been checked against Microsoft's documentation (as of November 2026). Microsoft continuously develops the Power Platform. The version and the date are shown on the cover page of the handbook.
Are later updates and individual consulting included?
You acquire the version stated on this page. There is no entitlement to later updates. Personalized consulting and the review of your app are not included in the purchase price; I offer the app analysis for that. If the delivered version is defective, your statutory rights in the event of defects apply.

10Further reading

Related to this topic

Free guidePower Apps Performance50 tips for fast canvas apps ServicePower Apps developmentCanvas apps that people actually use every day

Questions about the Performance Check? Contact me.

Whether you need a license for your consulting firm, have questions about a checkpoint, or are interested in an app analysis, we clarify what you need in a free, no-obligation initial consultation via Microsoft Teams.

Book a free initial consultation Send an inquiry +49 160 125 01 75