Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

What is the maximum number of Dataverse column limit which can be added in Canvas PowerApps.

(1) ShareShare
ReportReport
Posted on by 2

Hi All,

 

I am having a requirement to build canvas app with Dataverse as a DataSource.

The Dataverse table needs to have 600 plus columns created and that columns need to be used in canvas app.

 

My query is it possible to have 600 plus columns used in single canvas app?

Has anyone created any applications with such similar requirements with large number columns used in single app?

 

Thanks

 

Categories:
  • developerAJ Profile Picture
    developerAJ 2,837 on at
    Re: What is the maximum number of Dataverse column limit which can be added in Canvas PowerApps.

    @Xen 

     

    there is a limitation or bug if you create column of same type more than 12 times than columns will not work properly it applied for persons,lookupcolumn .

    and also if you have 600 columns you would face lot of issues.

    I worked on list with nearly 250columns some previous developer developed and that's lot of pain.i have flows which takes 1 to 2 hrs to load because of huge number of columns. at the end i suggested the users that it will be good if you break into multiple list so than changed the architecture design and broke into different list.

     

    Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    You can connect with me on LinkedIn

  • Ami K Profile Picture
    Ami K 15,655 on at
    Re: What is the maximum number of Dataverse column limit which can be added in Canvas PowerApps.

    Hi @Xen - I do not believe this is documented anywhere, but given there is a recommended soft limit of 500 controls in an app, ostensibly 600 fields would degrade performance of your app significantly.

     

    I would seriously rethink your design if you need 600 fields.

     

    https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/performance-tips 

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

     

    there is a restriction, but if you need more than 600 columns in your Canvas App, I would 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard