You’re offline. This is a read only version of the page.
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?
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.
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.
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?
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.
#1
WarrenBelz
146,518
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,756
Most Valuable Professional
Share
Report
All responses (
Answers (