I have a gallery that based on the selected items patches the records to sharepoint. The two comboboxes, company and privileges values are from other lists in sharepoint and I want to convert these ones into text during the patch.
The record title is created but the company and privileges are not been patched, if I only check one record, for example BPCS. If I select more than one, the first one patches correctly but the last one selected is missing the company selected and privileges.
My gallery:
//OnCheck checkbox6:
ClearCollect(
TempSpecialAccountsCol,
Filter(
ASSpecialAccountsGallery.AllItems,
Checkbox6.Value = true
))
//Patch in bold the two fields with issues
/*Special Accounts */
ForAll(TempSpecialAccountsCol,
Patch('NewHire Requests',Defaults('NewHire Requests'),
{
Title:ThisRecord.Title,
NewHireID:VarNewHireSandboxID,
RequestStatus:{Value:"Not Started"},
Request_x0020_Subtype:Concat(ThisRecord.cmbSubType.SelectedItems,Subtype , ","),
RequestClass:Concat(ThisRecord.cmbClass.SelectedItems,Title , ","),
UserGroup:Label55.Text,
SupportTeam:LookUp(UserGroups,Title=Label55.Text,UserList)
}));
//SharePoint List showing record after patch, Request SubType and RequestClass are missing
Strange that if more than one option is selected it patches all correctly with company and permissions except the last one selected from the gallery.
I have spent so much time on this and can't find the problem.
Hope someone has an idea on the issue.
Thanks
