I have a list that has about 15 people picker fields in it (including the default ones). I created a view that allows me to see the list data in chunks, but when I start to create an intake form for data entry, I'm running into issues. Based on what I've seen online, my thought process was to split the fields that need to be entered onto different screens. However, the form won't connect to the data because the list has too many lookup fields. Is there some "trick" to getting this to work, or is my goal untenable?
SharePoint enforces limits to optimize performance, and exceeding those limits can lead to errors or connectivity problems. SharePoint has a list view lookup threshold, which defaults to 12. This includes lookup fields, managed metadata fields, and people picker fields. When you exceed this threshold, operations like displaying data or connecting to Power Apps may fail.
User Power Automate
Create a Simplified Form in Power Apps:Use a form that does not directly connect to the list but collects data in variables or collections.
Submit Data via Power Automate: Trigger a Power Automate flow when the form is submitted. Use the flow to insert or update data in the SharePoint list.
pls try. thanks
Was this reply helpful?YesNo
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.
Share
Report
All responses (
Answers (
1,990
