Answered

Submitform Network error when using Patch function: The requested operation is invalid.

(0) Share

Report

Posted on by ScottRMeredith

141

I have a large number of fields in my SharePoint list so I made a tabbed form based on Reza Dorrani's video. I made all my fields not required and made a whole bunch of conditions for required in the PowerApp. I have checked the update property on every field in my form, I have moved the PowerApps authoring version back a version then back to current, testing in between each change. I verified every datacard on my form has a value in the update property. I do have 69 custom fields, plus the 5 default fields. I have 11 Lookup type fields and 3 person fields ( plus created & modified by, so 5) in my list. My submit button action is

SubmitForm(SB2EntryForm)

I did notice after going to my SP list the records are being created, but there is an error so it does not perform the on success functions. When I try to view my SP list with all columns displayed it gives me an error "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold." This is the only thing I can think of that may be the source of my problem.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

SebS 4,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @ScottRMeredith

Yes, indeed maximum lookup columns in the list are limitate to 12 and that includes Person Column.

See if that helps

https://natechamberlain.com/2018/09/04/how-to-increase-lookup-column-limit-in-sharepoint-lists/

P.S. This is very old and You need to look for something similar as SharePoint UI changed

Was this reply helpful? Yes No
Verified answer

SebS 4,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@ScottRMeredith

I will suggest managing lookups inside of power apps. Rather than lookup columns, make it single text and match data between Lists in the side of power apps using the Lookup() Function or filters that will take the problem away.

Was this reply helpful? Yes No
ScottRMeredith 141 on at

Like (1)

Report
Copy link

Link copied!

Yeah, I was originally going to use my lookup lists and load them into collections and then change the control sources to the collections, but I forget why I didn't do that. I have my SP admin going to see if he can change the setting in SP Online. If he can, that is the easy answer. If not, I have more work to do. Thanks. I will advise what ends up happening.

Was this reply helpful? Yes No
ScottRMeredith 141 on at

Like (0)

Report
Copy link

Link copied!

I changed all my lookups to be managed within the app itself. This I think also overall improved performance.

Was this reply helpful? Yes No
rbarpas 35 on at

Like (0)

Report
Copy link

Link copied!

I have the same problem with a list with a lot of search fields, I think is the same problem.

I'm rookie in PowerApps so maybe you can help me with the solution. I know de LookUp function but I dont't understand how make the change. If I change the serach field for a text field, how works the lookup function there if thers not a dropdown or data source? how you did it?

Thanks in advance!

Was this reply helpful? Yes No