Forum Discussion

Iron Contributor

Jan 30, 2019

"Sorry, you don't have access" when trying to create a lookup column?

I'm working on a SharePoint Online site where I'm creating a content type. The content type requires a column where the user uses a lookup field to select from a list of projects. When I'm creati...

Document Library

SharePoint Online

gavmgaurav

Copper Contributor

Mar 20, 2019

Toby McDaid Hi I have also faced recently the same issue. The problem is that the user who is adding Site Lookup Column is not Admin/ Site Collection Admin on that Site although he is owner of that modern team site. To make him admin go to Admin center --> SharePoint --> Search for your site through preview option and then add him as Admin. The problem will be resolved.

LohnDjango

MVP

Apr 18, 2019

Come on guys!

Why should Full Control permission roles not be able to add Lookup columns (like already was possiblebefore)... being a Site Collection Admin to do this is crazy right?!

Koenti
Copper Contributor
Feb 18, 2020
Still today the problem occurs. Full Control = Full control but not in SPO...
Miguel Piñuel Peña
Copper Contributor
Sep 04, 2019
LohnDjango At least if you create the lookup type column at list level it's possible, allowing you to choose between the lists you have permissions.
It makes no sense that it cannot be done at the column site level...