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

john john 946 Reputation points
2021-09-17T13:15:03.097+00:00

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

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,700 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. JoyZ 18,041 Reputation points
    2021-09-20T09:29:45.36+00:00

    @john john ,

    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.