cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niklasjegg
Super User
Super User

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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,237)