Power Platform Community Forum Thread Details

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?

Categories:

Building Power Apps

Hi CU10011822-0,

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