Trying to create a button that will take selected values from a combobox in one SP list, and add the equivalent number of new records to a second SP list (i.e. 2 items selected, 2 new records in the SP list). I have been searching for the answer and this was the only result I could get to work without any errors, but it takes all of the combobox values and lumps them together into one field/one record in the second SharePoint list instead of parsing them out. For some reason this doesn't seem to be happening in any of the other posts I've come across - everyone else is getting the right number of rows, haha.
Button OnSelect property:
ForAll(combobox.SelectedItems As alias,
Patch(SP_List, Defaults(SP_List),
{test_field: alias.Result}));Update property for the combobox datacard (I do want it to lump the selections into one field in the first SP list, so this is working as expected):
Concat(combobox.SelectedItems, Result & ";")
DefaultSelectedItems for combobox field (I don't know if this matters but it was the only way I could get the selections to retain in the Edit form):
{Result: ThisItem.columnName}
I have also tried creating a collection, but it still puts all of the PL4 IDs together in one field in the new list (alternative Button OnSelect property):
ForAll(combobox.SelectedItems,
Collect(colIDsToPatch,
{Value: ThisRecord.Result});
Patch(SP_List, Defaults(SP_List),
{test_field: ThisRecord.Result}));Sorry for the long post, I feel like there is an obvious answer here, hoping it is something simple that I'm missing.
