USE POWERAPPS TO PATCH MULTISELECT LOOKUP IN SHAREPOINT

I’ve observed a couple situations where a user needs to repair a multi-select lookup using PowerApps. Patch the lookup is different than the basic data type in general because Lookup is a complicated type.

Solution

Because ComboBoxSelectedItems is a table, we must loop through the chosen items.

Patching Command

{ Title: TitleInput.Text, Event: ForAll( EventComboBox.SelectedItems, { ‘@odata.type’: “#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”, Id: Id, Value: Value } ) }

• Event – The column name in SharePoint EventComboBox
• Displays a list of all events from the SP List