web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Apps Editor Extr...
Power Apps
Suggested Answer

Power Apps Editor Extreme Lag

(2) ShareShare
ReportReport
Posted on by 34

Issue: The challenge I'm facing is that as I add more columns to the Power Apps editor, it becomes progressively slower, with each modification taking several minutes. I'm looking for recommendations on how to address this issue.

Background: I have a SharePoint Online (SPO) list designed as a Tech Project Tracker. The list currently contains around 150 columns, which I understand is extensive for a single list. However, these columns are crucial for collecting the data needed for various Power BI reports. Reducing the number of columns isn't an option, and the list may even expand as additional tracking requirements are identified. The out-of-the-box SharePoint form, even when formatted with JSON, lacks the functionality and visual appeal that Power Apps offers.

Goal: My aim is to integrate the SPO form with Power Apps because it provides a more aesthetically pleasing interface and supports logical expressions that enhance form control and functionality, thereby improving the overall user experience.

My Attempts: I tried creating multiple screens and forms and then patching them, but I encountered many issues with SPO integration, particularly with viewing and editing. I also searched for ways to optimize the Power Apps form but was unsuccessful.

Note: I do not have permissions to use Data Verse.

 

SS of one page of my SPO integrated power app.

Categories:
I have the same question (0)
  • Suggested answer
    KeithAtherton Profile Picture
    3,705 Most Valuable Professional on at
    Hey. Your attempt at splitting it into multiple screens and forms would be my first choice, not sure what the SPO integration issues were as I would expect that to work ok.
     
    Another approach would be to split the table into multiple, manageable tables which relate to each other. For example, a table for each tab such as Project Details, Project Contacts, Change Request, etc.
  • abc 123 Profile Picture
    784 Moderator on at
    I assume that you're not using collections to hold the data, and as such, not using them as the Items property of the Gallery.  PowercrApps is horrible when it comes to i/o, so the less you do, the more performance. Well, there is no better performance, only less degradation.
     
    The picture appears to show a detail form. How does the user get there? We have grid view, and the user picks the item to display in the screen. We write the item to a record variable, and that becomes the basis for the detail screen. If the user presses the Cancel button, then it's an easy throwaway. If they click save, then the patch uses the record variable for writing back to the actual SPO list.
     
    All of our drop-downs are based on collections, to facilitate proper sorting.
     
    If you want to get really radical, you can use a list that holds the datatype as one of the columns. Then, add code in the gallery to dynamically render the control with the data. (So, rather than having a detail screen, you have a gallery screen, and all of your list columns now become list rows, instead. (Transpose all the columns into rows.) 
     
    On an aesthetic note, change the display column names in the SPO List, such that you don't have ugly labels like "CMTLInk". Change it to "CMT Link" in the list, and that will self-propagate throughout the App. Notice that "CR Status" is non-conforming to every other label.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard