We will learn to improve & optimize performance in Power Apps. Before we start, make sure to subscribe to CRM Crate so that you can stay up to date in the field of Power Platform.
Steps for improving performance in Power App
Optimize Dataverse Data Model
1. Take a close look at your applications’ data model and fine-tune it by removing any fields and entities that you don’t really need.
2. Review and optimize your data model to eliminate unnecessary fields and entities.
3. Remove obsolete or unused data records.
4. Put a limit on custom entities and fields and only include the components which are essential for the solution. Remove all the unused components with help of ‘Dependency Checker’ capability.
Bulk CRUD Jobs and Automation
1. Use asynchronous processes and batch processing for long-running CRUD (Create-Read-Update-Delete) operations .
2. Schedule resource-intensive jobs during low-usage periods.
Query Optimization & Data Indexing
1. Utilize advanced find queries and fetchXML with efficient filters.
2. Try to use ‘Linked-Entities’ as much as possible to retrieve hierarchical data.
3. Avoid complex dataverse queries that pull in excessive data.
4. Utilize paging feature to page dedicated number of records / rows per page.
Custom Configuration Optimization
1. Review and optimize business rules and workflows for efficiency. Try to configure majority of workflow processes as ‘Background Workflows’.
2. Make sure that the JavaScript / TypeScript form script are using less asynchronous calls in their source code.
3. Limit real-time workflows and plugins, as they can impact performance.
4. Introduce ‘Depth” in plugin to avoid infinite loop threat in application.
Data Import & Export
1. Schedule data imports during off-peak hours.
2. When importing data, use data import templates and consider bulk data load strategies.
3. Disable the environment plugins whenever possible as it may lead to chaining effect in terms of application endpoint limit.
Integration Optimization
1. Implement integrations in asynchronous fashion wherever possible.
2. Optimize data integration processes and minimize data movement.
3. Use OOTB or 3rd party connectors which are already present in AppSource to minimize failure time.
Perform Regressive Performance Testing
1. Regularly perform load and performance testing to identify bottlenecks and areas for improvement.
2. Measure the application loading time every time you deploy / built a new major feature.
Keep application up to date
1. Always update your Model Driven App with the latest release rolled out by Microsoft.
2. Update your custom plugin Nuget Packages / reference Dlls in a timely manner to avoid vulnerability and for accessing new features.
Thus, we learned to improve & optimize Dynamics 365 / Power Apps performance using healthy application maintainece practices.
