Add multiple selection people column to collection?

(1) Share

Report

Posted on by sudosaurus

1,597 Super User 2024 Season 1

Hello,

I am struggling with getting a multiple-selection people column into a collection in an app I'm working on.

I am using the OnChange property of a tab menu to Collect the data:

ClearCollect(
    colCIData,
    ForAll(
        If(
            tab_CI.Selected.Value = "Corporate Services", 'Continuous Improvement Tracker_2',
            tab_CI.Selected.Value = "Neighbourhoods", 'Continuous Improvement Tracker_1',
            tab_CI.Selected.Value = "Property Services", 'Continuous Improvement Tracker'
        ),
        {
            Title: ThisRecord.Title,
            Category: ThisRecord.Category0,
            Progress: ThisRecord.Progress,
            Priority: ThisRecord.Priority,
            StartDate: ThisRecord.StartDate,
            DueDate: ThisRecord.DueDate,
            AssignedTo0: ThisRecord.AssignedTo0
        }
    )
);

AssignedTo0 is the people column in SharePoint with the 'Allow Multiple Selections' option enabled.

I cannot figure out why it's not appearing in the colCIData collection. All the other data loads in there correctly which strikes me that it's the people column that is the issue.

Any ideas?

Categories:

General

All responses (7)

Answers (0)

DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (0)

Report

Add multiple selection people column to collection?

Maybe put the if statement outside the collection?

If(

!IsBlank(tab_CI.Selected.Value),

With(

{

dSource: Switch(

tab_CI.Selected.Value,

"Corporate Services", 'Continuous Improvement Tracker_2',

"Neighbourhoods", 'Continuous Improvement Tracker_1',

"Property Services", 'Continuous Improvement Tracker'

)

},

ClearCollect(

colCIData,

ForAll(

dSource,

{

Title: ThisRecord.Title,

Category: ThisRecord.Category0,

Progress: ThisRecord.Progress,

Priority: ThisRecord.Priority,

StartDate: ThisRecord.StartDate,

DueDate: ThisRecord.DueDate,

AssignedTo0: ThisRecord.AssignedTo0

}

)

)

),

Clear(colCIData)

);
sudosaurus 1,597 Super User 2024 Season 1 on at

Like (0)

Report
Add multiple selection people column to collection?

@DJ_Jamba

I have simplified things by just focusing on one list.

ClearCollect( colCIData, AddColumns( 'Continuous Improvement Tracker_2', 'AssignedToDisplayName', Concat(AssignedTo0, DisplayName, ", ") ) );

This is formatting correctly:

AssignedTo0 is now showing in the collection with the correct display name in the AssignedToDisplayName column.

However, when I try and add back in the other lists with the If statement, it then doesn't find the column.
DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (0)

Report
Add multiple selection people column to collection?

Then there's something wrong with your lists or your app.
To prove it, create a brand new list with a multi person column field and add a couple of rows.
Create a brand new app, add the new list data source, add a button to a screen and create a collection from your new list.

ClearCollect( colTemp, ForAll( NEW_SP_LIST, ThisRecord ) )
sudosaurus 1,597 Super User 2024 Season 1 on at

Like (0)

Report

Add multiple selection people column to collection?

@DJ_Jamba

I have just tried your suggestion, however AssignedTo0 is the only column which isn't displaying.

All other columns load correctly.
DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (0)

Report
Add multiple selection people column to collection?

OK. Could you try this test then look in the collection and see if the AssignedTo0 column is there?

(I had no problems pulling in a multi person column in my test)

ClearCollect( colCIData, ForAll( If( tab_CI.Selected.Value = "Corporate Services", 'Continuous Improvement Tracker_2', tab_CI.Selected.Value = "Neighbourhoods", 'Continuous Improvement Tracker_1', tab_CI.Selected.Value = "Property Services", 'Continuous Improvement Tracker' ), ThisRecord ) );
sudosaurus 1,597 Super User 2024 Season 1 on at

Like (0)

Report

Add multiple selection people column to collection?

@DJ_Jamba

Yes,

/PropertyServicesLeadershipTeam/_layouts/15/FldEditEx.aspx?List=%7B6FCCBE41-16AA-4C09-8D47-E46D030E81EB%7D&Field=AssignedTo0

/CorporateServices/_layouts/15/FldEditEx.aspx?List=%7B2E99B1C7-60D7-4823-8F85-3C22694D7B18%7D&Field=AssignedTo0

/Neighbourhoods/_layouts/15/FldEditEx.aspx?List=%7B58D0554B-459C-4075-82A2-16C56E651EEB%7D&Field=AssignedTo0
DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (0)

Report
Add multiple selection people column to collection?

For your 3 data sources

'Continuous Improvement Tracker_2' 'Continuous Improvement Tracker_1' 'Continuous Improvement Tracker'

Are you sure the people column in all sources is called AssignedTo0 and not AssignedTo or 'Assigned To'

You can test it out by throwing a test collection together e.g.

ClearCollect( col_Test, Filter( 'Continuous Improvement Tracker_2', Title = 'ONE_OF_THE_TITLES_IN_SOURCE' ) )

Repeat for each source, and check the spelling of the AssignedTo column name