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
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