Hello,
I am looking for assistance patching multiple list box selections to individual rows in a SharePoint list. I was previously able to concatenate the entries into a single row, but can't seem to be able to undo my concatenation to have the multiple entries each assigned their own row in the SharePoint list. My current patching function is below:
ClearCollect(UpdateRecord,NewClinicListBox.SelectedItemsText.Value);
Set(varRecord,
Patch(
'Rounding Inputs',
Defaults('Rounding Inputs'),
{
Observer: NameInput_1.Text,
Date: DatePick_1.SelectedDate,
Hours: HoursInput_1.Text,
ServiceArea: ddServiceArea.SelectedText.Value,
BuildingName: BuildingComboBox.Selected.Value,
RoundingType:ddRoundingType_1.SelectedText.Value,
ClinicNames: Concat(NewClinicListBox.SelectedItemsText.Value, Concatenate(Text(Value),";"))
}
));
If(!IsBlank(varRecord),
Notify("Your request has been submitted!", NotificationType.Success),
Notify("Your request was not submitted", NotificationType.Error)
);
Reset(NewClinicListBox);
Reset(NameInput_1);
Reset(BuildingComboBox);
Reset(DatePick_1);
Reset(HoursInput_1);
Reset(ddRoundingType_1);
Reset(ddServiceArea);
Any guidance you may be able to provide would be much appreciated. Thank you!

Report
All responses (
Answers (