Share
ReportHi
How many fields can I add in a Dynamics 365 form? For example, Account, Lead, Opportunity...
You’re offline. This is a read only version of the page.
76
Hi
How many fields can I add in a Dynamics 365 form? For example, Account, Lead, Opportunity...
For Refresh Forms, Main forms on Mobile devices have a limitation of 5 tabs or 75 fields and 10 subgrids. This is to optimize performance.
Unified Interface allows a common form but has other limitations as of now.
250
Hi Carmen,
You can add as many fields as available (though there is a limit as mentioned above)for the entity to add it to the form.
However this is not recommended due to performance issues.
Hope this helps.
Hi,
It depends on the Maximum Capacity Specifications for SQL Server.
The SQL server tables limit is 1024 columns. This is the limit to the SQL Server views also.
When you create a new filed in a CRM entity the CRM add this field in the respective table and in the respective Filtered View. Depending on the field type the number of columns added in the Filtered view is different.
Example:
• If you add a text field in the Entity, the CRM will add 1 column in the Filtered View.
• If you add an Option Set field in the Entity, the CRM will add 2 columns in the Filtered View; 1 for the Value and 1 for the Label.
• If you add a Lookup field in the Entity, the CRM will add 3 columns in the Filtered View; 1 for the ID, 1 for the referenced Entity Logical Name, 1 for the Record Name.
So depending on the types of fields you have in the entity you can reach the 1024 limit at a different moment as the limit of the fields you can create in an Entity should be calculated as follows:
X *3 + Y*2 + Z*1 <= 1024
Where:
• X is the number of Lookup Fields
• Y is the number of Option Set / Boolean / Money fields
• Z is the number of fields from other type
Theoretically you can reach the limit at around 340 fields if you have a lot of Lookup fields in your entity: 340 *3 = 1020.
Hope it helps.
BR,
Judy
At some point of time there was a hard limit of 400 fields total on an entity. That number may have changed.
My recommendation would be to not have too many fields on any entity as this may cause performance issues if there are too many fields on the entity form.
In addition one has to be cognizant of the # of fields that can be shown on mobile devices if mobile is going to be part of the user experience.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (