Patch a multi-select combo box to a nested table within a collection

Like (0) Share

Report

Posted on 12 Feb 2025 22:30:18 by TerriyakiIR

I'm pulling my hair out for 2 days now and I have no idea if what I am wanting to do is feasible.

I have a collection that grabs data from a SP list called Skills. One of the columns called Workgroup will be used to store values from a multi-select combo box. So I created it as a table.

This is what I did

ClearCollect(colSkillsFoH, AddColumns(ShowColumns(Filter(Skills, Portfolio.Value = "Front of House"), ID, Title, Portfolio), Workgroup, Table({Value: ""})));

I have then added a multi-select combo box into my gallery. On the OnSelect property of the combo box I need to be able to patch or update the selected items from the combo box back to the Workgroup table column that I have created in my collection but to no avail.

Patch(colSkillsFoH, LookUp(colSkillsFoH, Title = ThisItem.Title),
    {Workgroup:{Value: ThisItem.Value}})

It is failing because it expects that the Workgroup column contains a table but is seeing a Record (which makes sense).

I also tried it this way but it's failing on Value. It's also saying that it's expecting a Table value but of a different schema.

Patch(colSkillsFoH, LookUp(colSkillsFoH, Title = ThisItem.Title),
    {Workgroup: Collect(LookUp(colSkillsFoH, Title = ThisItem.Title).Workgroup, {Value: ThisItem.Value})})

How do I get those values to be stored in a table? Is it possible?

My plan is once those values are patched. I will then patch the entire collection to another SP list where the Workgroup column is a multi-select choice column.

Seriously, I can do this with one value but dealing with multi-select values is driving me nuts!

Categories:

Using Apps Using Formulas

General Questions

All responses (3)

Answers (1)

WarrenBelz 146,883 Most Valuable Professional on 13 Feb 2025 at 05:09:36

Like (1)

Report
Patch a multi-select combo box to a nested table within a collection

Hi @TerriyakiIR,

If you are triggering the Patch OnChange of the Combo Box, you can do this.
Patch( colSkillsFoH, LookUp( colSkillsFoH, Title = ThisItem.Title ), {Workgroup: Self.SelectedItems} )
TerriyakiIR 4 on 13 Feb 2025 at 04:28:06

Like (0)

Report
Patch a multi-select combo box to a nested table within a collection

Thanks so much! That helped. I was trying this bit out
{Workgroup: ComboBoxName.SelectedItems}
yesterday and for some reason it wouldn't work. There could be a combo of factors as I was trying out too many stuff to the point my app kept crashing lol. I removed my brackets for [ThisItem.Workgroup] in the DefaultSelectedItems property which was causing it to fail (thanks for point that out). And I have to make sure that I put the patch command on the OnChange property as well.
Verified answer

WarrenBelz 146,883 Most Valuable Professional on 12 Feb 2025 at 23:03:22

Like (0)

Report
Patch a multi-select combo box to a nested table within a collection

H i @TerriyakiIR,

If you have this in your Patch, assuming the output of your Combo Box is .Value, you are running this from an icon/button inside the gallery and using your Combo Box name
Patch( colSkillsFoH, LookUp( colSkillsFoH, Title = ThisItem.Title ), {Workgroup: ComboBoxName.SelectedItems} )

you can also have the DefaultSelectedItems of your Combo Box
ThisItem.Workgroup

and see the result as soon as it is Patched

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee