Using a subsite with unique permissions, I have created a form that has a cascading dropdown. Based off selection 1 (location), it pulls a list of supervisors for selection 2. Users would ALWAYS receive "Error getting list entries" despite having full permissions to the subsite and all required lists. All lists being used in the form are housed on the SUBSITE.
Troubleshot issue by myself and found that the form queries the ROOT site for permissions, even though all data is housed on the SUBSITE. I had to create a dummy group on the root site to bypass this issue, and add all the members. However, this is a large issue, as these users should not have access to this site. It is basically a shadow group, as I have not informed them that they have access.
Does anyone have a solution to this problem?
Having subsites with unique permissions is fairly common in SharePoint, it seems pretty ridiculous that the List Lookup field would query the root site for permissions. Although my current solution works, it is not a permanent one.
I know this is posted a year ago, hopefully you found a solution or fix because I am getting this as well. I have a subsite with 2 lists (List1 and List2). The subsite has unique permissions. The form in List1 cannot lookup List2, and I also get the "Error getting list entries" message. Giving the user permissions to the site collection resolves this error, but I have to make sure the user cannot see anything important at the site collection level. Frustrating!