Patch Multiselect Lookup in SharePoint using PowerApps

A few times I have seen the user has requirements to patch multi Select Lookup using PowerApps. In general, patch the lookup is different than the simple data type since Lookup is a complex type.

Solution

ComboBoxSelectedItems is a table, So we need to loop through the selected items

Patch Command

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

  • Event – Name of the Column in SharePoint
  • EventComboBox – Lists all events from the SP List

Demo

 

 

Leave a Reply

Your email address will not be published.