Announcements
My company is starting to use PowerApps and Power Automate but many of the existing Sharepoint lists use cross-site lookup columns that don't play nice with Apps and Flow. I'm trying to find a way to move or copy the values in the lookup columns to new columns that will be managed via PowerApps but haven't found a good method. Any suggestions?
@jgunter3786
Add the list from any SharePoint site as a table in your app. You will need to have the URL of the SharePoint site so copy it before you add the list. You should be able to add the lists from any SharePoint site that you have permission to access.
Yes, I can connect to the list just fine in PowerApps and Power Automate. The problem is the cross-site lookup columns do NOT show up as available fields for galleries and forms. All my research is telling me I can't connect to them so I need to move the data to a new column and control the lookup property via PowerApps. Make sense?
If you are referring to using a Lookup type field in a list, you are probably correct. However, I never use that type of field. I will import the list directly into my app and add the ID from the table directly. So, for example, if I have an Orders table and I want to add a lookup to a Product list, I put a number field in my orders table called ProductID and save the ID from the Products list in my Order table. It doesn't matter where the Product list comes from and it could even be an Excel table or a SQL table.
The lookup type column in SharePoint creates all kinds of difficulties in PowerApps. One of the best features in PowerApps is the ability to access data not only from different SharePoint lists in various sites, but from many different kinds of connectors.
Exactly! But my company didn't set their lists up that way when they first started using Sharepoint so now I need to figure out a way to fix it.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
