Patch Multi select Lookup Column

[niklasjegg]

Hello, i have 2 SPO Lists.

First named Contract_Partners second named Contract Database.

I am displaying the Title column of Contract_Partners as lookup in the Contract Database list. It can be multi selected.

How can i patch this type of column.

I have a Combobox: Item Property 

Contract_Partner

 and Display Fields is Title. Multiselect and Search are on.

I am useing collect function to get all selected Items from the combobox.

ForAll(Contr_Partner_Input_1.SelectedItems,
    Collect(ContractPartners,
        {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: ThisRecord.ID,
            Value: ThisRecord.Title
        }
    )
)

 in my Patch 

Patch(Contract_Database,
 Defaults(Contract_Database),
  {
    Lookup_Contract_Partner : ContractPartners
  }
)

i am getting the error message "The type of this argument "Lookup_Contract_Partners" does not match the expected type 'Record' found type 'Table'. What to i need to patch in this column?

Thanks a lot

[v-bofeng-msft · Accepted solution]

Hi @niklasjegg ,

Please check if the person column(Lookup_Contract_Partner) allow multiple selections:

And then please refresh the data source:

Best Regards,

Bof

[niklasjegg]

Hi @v-bofeng-msft ,

thanks i already checket that.

I closed all my Browser windows and reopened the app again. Working as expected with no changes made in sharepoint or the app....