I have a combo box that is working fine for adding new people (one or more) to a SP list - the data is stored in the SP List as a single line of string.
Now my struggle is editing the item. I'm not doing a "Form". It's an independent combo box
In my SP List you see this... (nice - 2 names in this case)
Now, my struggle is to show these people as the defaults in the combo box. As I want the person to be able to edit (add/delete) then I need to render in this case Richard and Karen as people fields in the combo box so the person can edit them.
I have done a single person combo box before but only ever in true Forms and now I've confused myself completely. What surprised is that the
I figure I need to split the string by the delimeter and then build a person object... but I'm not sure how I do the split and the build at the same time.
For the defaultedSelectedItems I did this...
RenameColumns(Split(varItem.'Marketing Team', ","), "Result", "Value")
Which displayed the 2 people's names in the combo box BUT here's where I think they are truly not treated as "people fields" so when I write on the path I do this...
'Marketing Team': Concat(CmbIFCContact.SelectedItems,DisplayName,", ")
and it ignores them because they are not people fields just regular text strings for each person. I know somehow I need to build the people fields but not sure how to do that with multiple people...(like this - but not exactly this).
Set(sample,{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: Concatenate(
"i:0#.f|membership|",
Lower(varUser.Email)
),
Department: "",
DisplayName: varUser.FullName,
Email: varUser.Email,
JobTitle: "",
Picture: ""
})

Report
All responses (
Answers (