Forum Discussion
Unable to add lookup column referencing a shared list with full control permissions
You should be able to do that using Power Apps. https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-drop-down
You could also look at using the content type hub. It's a site collection where you can create site columns and content types, and share them out with other site collections. https://docs.microsoft.com/en-us/microsoft-365/contentunderstanding/push-content-type-to-hub
mrodriguez_levi They need to be on the same site for them to show up. Any chance you are working in different places? You can look at the URL. Below are examples to check to URLs.
SharePoint URL - if everything is in SharePoint, make sure the sites are the same
https://[tenant].sharepoint.com/sites/[sitename]/Lists/[listname]/AllItems.aspx
Personal list - if it was created using Lists app, the URL will contain https://[tenant]-my.sharepoint.com
PamDeGraffenreid Thanks for the reply! We are for sure on our own personal lists. It felt just strange to me that they have full access permissions where they can add, edit, and configure the list I created but there is no way for them to use the data in the list. The reason we are hesitant to use a site is that there are times where users may not want a list visible to the owner of the site but still would like to still leverage the information in the other lists. I guess that is the core of our problem. Is there a way to share certain synchronized information which we can all reference in a lookup in our personal lists?
You should be able to do that using Power Apps. https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-drop-down
You could also look at using the content type hub. It's a site collection where you can create site columns and content types, and share them out with other site collections. https://docs.microsoft.com/en-us/microsoft-365/contentunderstanding/push-content-type-to-hub