I created a site column, because that has been my workaround for lookup columns to different sites, because nothing can ever be easy.
I tried to create a PowerApps form, but the site column does not show on the form.
Here's the structure:
Internal Site collection contains a list of Offices.
Site Column is lookup column for Offices.
Created list on Subsite of internal site collection.
I wanted to do this so I can maintain ONE list of Offices across the company if there are ever new offices or offices close.
For the love of god, why can't we just create lookup columns that span the entire site? Why might I have to buy some third party software to be able to accomplish this?
Solved! Go to Solution.
BTW: I tried to leverage a PowerAutomate flow to update the Site Column, just to see if that would be a good workaround. I was not surprised to see that PowerAutomate's SharePoint connector also cannot see the Site Column. I'm sure they are based on the same implementation, which would make sense.
User | Count |
---|---|
252 | |
126 | |
104 | |
50 | |
49 |