Unanswered

Cross Site Lookup Column in Sharepoint

(0) Share

Report

Posted on by jgunter3786

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
jgunter3786 6 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@jgunter3786

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.

Was this reply helpful? Yes No
jgunter3786 6 on at

Like (0)

Report

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.

Was this reply helpful? Yes No