The following limitations are found in modern forms due to performance reason and/or limitations of SharePoint API.
- Maximum number of items in lookup columns - due to performance reason, by default the maximum number of items to be displayed in a lookup column is 2,000. If you need to be able to use more values, use auto-complete mode of Connected lookup column and set the number of type-in character to more than 0. Users will need to type in characters and only values containing those characters will be returned.
In general, SharePoint imposes a limit on the number of lookup columns to ensure optimal list performance. The lookup column threshold restricts the number of lookup columns in a single view to 12, and exceeding this can significantly impact list performance. The number of lookup columns allowed in a single view is crucial to avoid performance degradation. Exceeding the lookup column threshold can also affect query performance, leading to errors and slow data retrieval. Understanding the limitations of a SharePoint list and SharePoint lists is essential for effective data management. Exceeding the lookup column threshold can negatively impact user experience by causing errors and slow performance.
- Events list are only partially supported. Specifically, there is no support for recurrence or All Day events.
- Managed metadata columns should never be renamed after creation.
- Forms work in browser only (desktop or mobile), you will not be able to use them in the SharePoint app for mobile devices.
- Users must have the necessary access to the list as well as additional lists that are used by lookups, associated items, document link columns. Read access to Site Assets and Site Pages (previous versions in SharePoint Online only) is required.
