Using a combobox to select several values from a lookup field, pointing to another list

(0) Share

Report

Posted on by SP_Ontwikkelaar

I have a lookup field Team in a Projects-SPO List. The field Team is linked to an another SPO-List Colleagues.

The lookup field Team can contain several Colleagues.

I use a combobox in a gallery pointing to a record in Projects to select Colleagues (items:Colleagues and DefaultItemsSelected:thisitem.Team)

When I update, only new selected Colleagues are written to the Projects-list. Existings Colleagues are gone!

Patch(Projects;LookUp(Projects;Code="TEST");

{Team: ForAll(ComboBox.SelectedItems; {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";

Id:ID;Value:ID})})

The instruction below gives an error (Table expected, but other schema)

Patch(Projects;LookUp(Projects;Code="TEST");

{Team:ComboBox.SelectedItems})

With dropdown (single values) linked to an other list, it works fine

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@SP_Ontwikkelaar
Inside your ForAll, why are you using Value:ID? Does Value:Value work?

Was this reply helpful? Yes No
SP_Ontwikkelaar 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Value:ID or Value;"abc" doesn't matter, Value:Value doesn't work

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@SP_Ontwikkelaar
To test your code, I setup a ComboBox (multi select) linked to another SP list.

Items = Choices(myList.myColumnName) --> note this is different to your setup

Patch code
Patch ( myList, LookUp(myList, ID = 1), // I used ID = 1 for testing purposes { myColumnName: ForAll( ComboBox1.SelectedItems,{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: Id, Value: Value }) } )
This code works because of the way I have setup my Items property of the ComboBox.

To write the code with your setup, you need to use a LookUp() for your Value and Id, eg
Id: LookUp( Choices(Projects.Team), Value = Colleague, Id)
Value: LookUp( Choices(Projects.Team), Value = Colleague, Colleague)

I couldn't get the above LookUps to work properly (due to work constraints) but this is the concept you need to get it working. The easiest way is to use the code above that and adjusting your ComboBox Items property to something like

Items = Choices(Projects.Team)

Was this reply helpful? Yes No
SP_Ontwikkelaar 20 on at

Like
a
(1)

Report
Copy link

Link copied!

This is a great solution! Choices of the lookup field instead of the external list. Thanks a lot!

Was this reply helpful? Yes No