question

johnjohn-0472 avatar image
0 Votes"
johnjohn-0472 asked JulieWang-MSFT commented

Why the Lookup field which reference a list inside the root SharePoint site did not get mapped inside the subsite power app's form Fields

I have a site collection with this url /sites/t/ , and it has a list called CostCenter:-


133282-root-site123.png


and inside the /sites/t/ site collection >> i created a site column of type Lookup which reference the CostCenter list named CostCenterLookup, as follow:-


133291-costcenter.png



now i have a sub site at this url /t/en-ca/forms/ , which contains 2 lists; Devices + MobileSubmissions:-


133236-level2.png



now inside the MobileSubmissions lists i have defined 2 lookup fields:-


1) First lookup is the one defined on the root site and which reference the CostCenter list (as described above).

2) While the second Lookup is a list column (not site column) which reference the Devices list found on the /t/en-ca/forms/ subsite.


Now i created a new Canvas PowerApp, and i added the MobileSubmissions + Devices + CostCenter lists as the datasource >> then i added a new form and i defined the MobileSubmissions as the Data source >> where i get all the fields inside the form (Title + Lookup to the Devices list), But i did not get a field for the lookup column to the CostCenter, as follow:-


133283-datadata.png


Can anyone advice on this please? is it limitation in power app for showing lookup fields which reference a list from another site? if the answer is Yes, then is there any workaround?


Thanks


office-sharepoint-online
root-site123.png (15.7 KiB)
costcenter.png (39.7 KiB)
level2.png (28.3 KiB)
datadata.png (43.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JulieWang-MSFT avatar image
0 Votes"
JulieWang-MSFT answered JulieWang-MSFT commented

@johnjohn-0472,

Per my test and research, this is the known issue in PowerApps that lookup site column from a SharePoint parent site added to a list in a subsite do not show up in the list of available fields in the PowerApps data.

Though we can add a custom card and connected the parent site list, this field will not be able to address the visibility of associated lookup fields on the referencing list's list view.

In this way we suggest you use list column instead of site column from another site.

Simialr issue for your reference:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Lookup-Site-Columns-from-a-SharePoint-parent-site-added-to-a/idi-p/259375


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@johnjohn-0472,

Is there any progress on this issue?

Please feel free to reply.

0 Votes 0 ·