Power Platform Community Forum Thread Details

I want to patch into a multi choice column, but keep the items already selected there.

Patch(
'My Table',
TheItem,
{
Years: DrpYear.SelectedItems
}
)

This would add the years selected, but remove the ones already present.

I was thinking perhaps

Years: Table(DrpYear.SelectedItems, TheItem.Years) but I guess I would need some kind of spread operator here.

Since these are tables this is just about joining two tables of same data into one right. Guess I would have to worry about distinct as well.

Categories:

Patch new Choices into Multi Choice Column