Hi, I am writing here hoping someone can help me or reference to some documentation.
I am trying to recreate my site from a: SharePoint 2019 and Nintex 2019 → SharePoint Online and Nintex Automated Cloud.
We have a lot of users +300 and many items in our list, +150 000 items. And we do not want users to see or be able to edit other items. But it is ok if they can see and edit other items from users from the same company.
So, to avoid unique permission limit of 5000 items, we created one folder with unique permission for each company with contribute permission and set the list permission to read. This makes it so users can only see one folder and not able to add new item at root level. They click their folder and then the new item is available. and they can now add items and edit any item from their company.
And we have a Nintex 2019 form for easier form design and functionality and so on.
Now to SharePoint Online and Nintex Automated Cloud. I recreated the list with read permission and added the folders with contribute permission for each company. and tested it. Worked perfect user can only see their folder and not able to add items outside their folder.
Then i created the Nintex List Form, and i did nothing in the form just published it. And now users get Permission denied. If i delete the Nintex form, it works again. So, it works with SharePoint default form but not Nintex forms.
I tested around and if i add so users can add items in root list, then they can open the Nintex list form. But i do not want them to be able to create items outside their folder. then everyone can see and edit other items, which is not good when we have so many items and users.
So, my findings are that the New Nintex Automated Cloud List forms don't work with lower permissions on list and higher on folder. I am trying all kinds of things. But cannot find a good solution.
I am now stuck between have less then 5000 items and unique item permissions.
or
Have no Nintex list form at all.
I think Nintex has thought of this somehow, how we can make items only available for a group of users. and have large list >5000. I just cannot figure it out.
I would really appreciate any kind of help :)
Best regards Tommy