Hi All,
The form submits to a SharePoint list ("Requests") which includes a Lookup column named Sub_Application. This column has the following properties set:
- Get information from: Ref_Sub_Applications
- In this column: Title
- Allow multiple values: TRUE
The initial screen contains a multi-select ComboBox control (cboPasaReqSubApp) that pulls values from the "Ref_Sub_Applications" list, with the Title column as the Display Value.
If the user selects multiple values from this ComboBox, all of those values should be listed in the aforementioned Lookup column (Sub_Application) once the form has been submitted.
The problem I'm running into is that regardless of the # of selections made from this ComboBox, the Sub_Application Lookup column is only reflecting the last selection that was made upon submission of the form.
When the user proceeds to the next (and final) screen, I'm using the below to create a collection for the selected records from the ComboBox:
ForAll(
cboPasaReqSubApp.SelectedItems,
Collect(
colSelectedSubApps,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: cboPasaReqSubApp.Selected.ID,
Value: cboPasaReqSubApp.Selected.Title
}
)
)
When I view the collection (colSelectedSubApps), it's essentially showing duplicate values. For example, if the user selects two records from the ComboBox whose respective "Id" values are 4 and 7, the collection shows two records - but both records have the same Id and Value (representing whichever item was selected last from the ComboBox).
I'm not entirely sure where I'm going astray, so any help would be appreciated 😞
Thanks!
