cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple value lookup Sharepoint

To improve integration of Powerapps (O365) with Sharepoint online (also O365) it is a necessity to allow for viewing and editing multivalued lookups through a Powerapps app. Lookup columns with multiple values enabled are a very common and widely used feature in Sharepoint.

 

As stated on this page currently multivalued lookups in Sharepoint are not supported.

 

Thanks.

 

 

Status: Completed
Comments
Level 10

BTW - thanks for adding this!  I've already started to use it, and from what I've done so far, it works very well.  

Level: Powered On
This still errors when creating a powerapp form on a list on lookup field.
 

With a site column based lookup field on the item title column (no link to item etc), even without multiselect, I get this error:

 

{
"status": 400,
"message": "The required field \"Business Unit\" data type is not supported\r\nclientRequestId: 0947e2db-60a7-4e97-b189-4cb46cbeb222\r\nserviceRequestId: abf1529e-2027-5000-6d6a-60c804d03444",
"source": "***urlRedacted***sharepoint.com/sites/staffForms/Parking/_api/SP.APIHubConnector.GetTableMetadata(listName='f623845f-94ee-471d-8668-5b3b72c31432')",
"errors": [
"-1",
"Microsoft.SharePoint.SPConnectorException"
]
}
Stack: Core.ApplicationError: {
"status": 400,
"message": "The required field \"Business Unit\" data type is not supported\r\nclientRequestId: 0947e2db-60a7-4e97-b189-4cb46cbeb222\r\nserviceRequestId: abf1529e-2027-5000-6d6a-60c804d03444",
"source": "***urlRedacted***sharepoint.com/sites/staffForms/Parking/_api/SP.APIHubConnector.GetTableMetadata(listName='f623845f-94ee-471d-8668-5b3b72c31432')",
"errors": [
"-1",
"Microsoft.SharePoint.SPConnectorException"
]
}
at r.t [as constructor] (https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/js/Core.js?v=2.0.820.69781359:1:677)
at r.t [as constructor] (https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/js/Core.js?v=2.0.820.69781359:1:957)
at new r (https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/js/Core.Services.js?v=2.0.820.6978135...)
at Function.r.createServiceError (https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/js/Core.Services.js?v=2.0.820.6978135...)
at https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/js/AppMagic.Runtime.Client.js?v=2.0.8...
at Object.q [as _notify] (https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/openSource/modified/winjs/js/base.js?...)
at Object.enter (https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/openSource/modified/winjs/js/base.js?...)
at c.Class.derive._creator._run (https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/openSource/modified/winjs/js/base.js?...)
at c.Class.derive._creator._chainedError (https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/openSource/modified/winjs/js/base.js?...)
at c (https://cdn-paaprodseau.azureedge.net/v2.0.820.69781359/studio/openSource/modified/winjs/js/base.js?...)

Session ID: eb349cdd-9f70-4053-8b06-10f444b26b29