Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Answered

Is it possible to increase the number of records (default = 25?) displayed in a dropdown when editing data in the data table?

(0) ShareShare
ReportReport
Posted on by 338

In the example shown below, there are 50 records in the Category table but the dropdown is only displaying 25.  If I can't increase the number of records displayed, it makes this functionality unusable.  Any suggestions?

 

MJWhite_0-1671267717732.png

 

 

Categories:
  • Verified answer
    oliver.rodrigues Profile Picture
    9,315 Most Valuable Professional on at
    Re: Is it possible to increase the number of records (default = 25?) displayed in a dropdown when editing data in the data table?

    Alright I see where it is now. However as far as I know, no we can't change that setting 😢

    The good thing about that component is that it autocompletes/searches as you type, and if you are using a model-driven form you have the option to open the lookup modal as well 

  • MJWhite Profile Picture
    338 on at
    Re: Is it possible to increase the number of records (default = 25?) displayed in a dropdown when editing data in the data table?

    Thanks Oliver

    It isn't the number of records in the data table.

    It is the number of records displayed in a dropdown field in the data table.  I've put a red border on the dropdown in the screenshot below to make it clearer.  It appears to have a default of 25 which is no use if the related table has >25 records, but I can't see how to change the default.

     

    MJWhite_0-1671701562820.png

     

     

  • oliver.rodrigues Profile Picture
    9,315 Most Valuable Professional on at
    Re: Is it possible to increase the number of records (default = 25?) displayed in a dropdown when editing data in the data table?

    Apologies when I said you could do at the Dataverse level, I probably got mixed up with other settings, as per @felipebarbosas the number of records per view page it's user level defined and you can use XrmToolbox to apply to other users

     

    At the dataverse maker table view, can you see the "additional rows" link? This should bring you to more records

    OliverRodrigues_0-1671700856279.png

     

  • MJWhite Profile Picture
    338 on at
    Re: Is it possible to increase the number of records (default = 25?) displayed in a dropdown when editing data in the data table?

    Thanks.  The reason for navigating to the system settings is that Oliver also wrote: If you want to apply this to all users, you can define at the dataverse level: Manage Microsoft Dataverse settings - Power Platform | Microsoft Learn

    and that link directs you to the system settings.

    I would like to apply the setting to all users, if possible.

    The setting is question is not the number of records on a page, nor is it the number of records displayed in a filter.  It is the number of records displayed in a dropdown when editing data in the data table, as described in the screenshot of my original post.

  • Fubar Profile Picture
    7,960 Super User 2025 Season 1 on at
    Re: Is it possible to increase the number of records (default = 25?) displayed in a dropdown when editing data in the data table?

    The Setting that Oliver was suggesting is under the Dataverse/Dynamcis 365 Users personal settings (option highlighted in Olivers screen shot), you have navigated to the System settings. 

    However, I don't think the suggested setting will give you what you are after as it is a setting for the number of records displayed on a Page (default is 50, but can be increased to 250) - but what you appear to be after is the number of records displayed in the filter.

  • Felipe Silva Profile Picture
    23 on at
    Re: Is it possible to increase the number of records (default = 25?) displayed in a dropdown when editing data in the data table?

    Hello MJWhite,

    That is a personal setting that you cannot change using the general settings of the platform. 
    However, you can use an XrmToolBox tool to modify this option for multiple users in a single action.

    felipebarbosas_0-1671534057283.png

    felipebarbosas_1-1671534126956.png

    I hope it helps.

     

    Felipe,

  • MJWhite Profile Picture
    338 on at
    Re: Is it possible to increase the number of records (default = 25?) displayed in a dropdown when editing data in the data table?

    Thanks Oliver.  I have looked where you suggest to apply to all users, but I can't find it.  Any tips where within the Settings page (below) I can find it?

     

    MJWhite_0-1671470594053.png

     

     

  • oliver.rodrigues Profile Picture
    9,315 Most Valuable Professional on at
    Re: Is it possible to increase the number of records (default = 25?) displayed in a dropdown when editing data in the data table?

    Hi, in your model-driven app, you can set this in your personal settings from the right-top corner:

    OliverRodrigues_0-1671452090092.png

     

    if you want to apply this to all users, you can define at the dataverse level: Manage Microsoft Dataverse settings - Power Platform | Microsoft Learn

     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 69 Super User 2025 Season 1

#2
oliver.rodrigues Profile Picture

oliver.rodrigues 49 Most Valuable Professional

#3
Jon Unzueta Profile Picture

Jon Unzueta 43