cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niklasjegg
Helper V
Helper V

Patch Multi select Lookup Column

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @niklasjegg ,

 

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

vbofengmsft_0-1650519189899.png

And then please refresh the data source:

vbofengmsft_1-1650519267328.png

 

Best Regards,

Bof

 

 

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @niklasjegg ,

 

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

vbofengmsft_0-1650519189899.png

And then please refresh the data source:

vbofengmsft_1-1650519267328.png

 

Best Regards,

Bof

 

 

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....

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,598)