Unanswered

Issue with Patching Combobox

(0) Share

Report

Posted on by Harris021

181

Hi all,

I am trying to patch a Combobox back to my SharePoint list. Since I allowed multiple selections, I started getting the error message
My list name is "Harris Document Testing 5000 records", and the Combobox name is ComboBox2.

Patch(
 'Harris Document Testing 5000 records',
 {
 Title: ComboBox2.Selected.Title,

 Lookup: {
 '@odata.type': "#Microsoft.Azure.Connector.SharePoint.SPListExpanded.Reference",
 Id: LookUp(LookUpFieldResponse, ComboBox2.Selected.Title).Id,
 Value: LookUp(LookUpFieldResponse, ComboBox2.Selected.ID)
 } 
 }
);

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (0)

cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report
Should just be able to use lookup: combobox2.selecteditems unless the drop down isn't connected to the column choices then you'll have to use a for all.

Was this reply helpful? Yes No
Harris021 181 on at

Like (0)

Report

@cwebb365 thanks for ur message, can please kindly let me know your solution to my scenario.

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

Gave you the solution. Use choices(test 5000 list,lookup) for items of the combobox2 and use combobox2.selecteditems in your patch. Make sure you have allow multiples set on the lookup column on the share point list as well. Should all just work.

Was this reply helpful? Yes No
Harris021 181 on at

Like (0)

Report

the moment I turn the Allow multiple selection on in SharePoint i get the this error message.

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

Then you need to change your combo box to also use multi selection.

Was this reply helpful? Yes No
Harris021 181 on at

Like (0)

Report

I have done that. 😞 and still the same issue

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

Well your items coming in is from a totally different data source so you’ll have to patch in with a forall. I’ll go pull one of my examples here after I get my kid to bed

Was this reply helpful? Yes No
Harris021 181 on at

Like (0)

Report

@cwebb365 Thanks mate, its working if I just select a single record, its just I cant make it working with selecting multiple items

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

Should be something like this in the Patch for Lookup: .

Lookup: ForAll(
ComboBox2.SelectedItems,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: ID,
Value: Title
}

Your Default should be blank, and your DefaultSelectedItems something like this:

ForAll(ThisItem.Lookup,{
ID:Id,
Title:Value})

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

You might have to use your logic for the ID and Value vs. what I have thou, but that's basically the format, you just want to pull in ForAll( Combobox2.SelectedItems which loops through the ones in the combobox and writes them for the lookup. And then the Loop in defaultselected is the same way but pulling all the items in the lookup and selecting them in the combobox.

Was this reply helpful? Yes No