Lookups with filters not working for certain users: Forms 2013


Badge +3

I have a form where any lookup with a filter on it is not working for certain users (lookup controls and calculated values using lookup functions). The account that created the form and the SharePoint service accounts work fine but not anyone else. The account that created the form was in the owners group and everyone else was in members so I moved the working account to members and it still works. I moved another person from members to owners and they still do not work. Cache was cleared and browser restarted for each test. There are no special permissions throughout the site (except for on the style library and image library), all others are inherited from the site. Lookups without filters (on the same lists) work fine for everyone.

Another thing I noticed which might not be related is if I edit the form as a member (even the person who created the form) then I cannot save changes to any controls (no error it just acts like I'm not clicking save) but I can publish the form. Change it back to an owner and I can save ok.


2 replies

Badge +3

I just found that it works if the user is in the local administrators group on the web front end? I guess it could be a claims issue but the web app is claims and if I look at the users in the site permissions they are showing claims accounts. I opened a support case.

Badge +3

I found that admins have different list view thresholds than everyone else with the default out of box settings settings. I had to increase it for non admins (can't think of any alternative).

Reply