2 Sharepoint list relation with lookup column and restrictions

Question

Hello guys,&nbsp;I have the following scenario im trying to make, i know you cant make column permison level on sharepoint list, but is it possible to make 2 lists where on the second list i only give acces to certain users?&nbsp;&nbsp;Example:List Contracts (public information)ID | CONTRACT | contract_duration | ID_COSTList Costs (Sensible information)ID | contract_cost | company&nbsp;&nbsp;And then i give access to most people to list of contracts only, but for the costs&nbsp;list since it is restricted information i only give acces to very few people i control.&nbsp;Thanks in advance and i hope my question was clear enough.

krunalrohit · Answer

It seems this can be achieved through Item Level permissions. You can find a really good info on the same here -

https://sharepointmaven.com/how-to-enable-item-level-permissions-in-sharepoint/
https://blog.netwrix.com/2019/03/07/how-to-use-sharepoint-item-level-permissions/
https://www.about365.nl/2018/07/30/how-to-properly-make-use-of-item-level-permissions-in-sharepoint/

vasuno1 · Answer

JCarballo&nbsp;- Just jumping in to say that in case you were trying to allow users to be able to use a lookup column from a list without giving them actual access to the list, I was able to achieve this quite easily insomuch that I am now baffled as to why no one online has this as a solution.&nbsp;What I did is create a new site permission (Gear Icon &gt; Site Permissions &gt; Advanced Permissions Settings&gt; Permission Levels). In my case I created a permisison called "For Lookup Only". As the below screenshot shows, I only gave the view permission and voila! I tested and found that the user does not have access to the source list for the lookup column even if they click the hyperlink in the column.&nbsp;

Forum Discussion

2 Sharepoint list relation with lookup column and restrictions