Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages - General Discussions / Add multiple selection...
Power Pages - General Discussions
Unanswered

Add multiple selection people column to collection?

(1) ShareShare
ReportReport
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
  • DJ_Jamba Profile Picture
    DJ_Jamba 2,623 Super User 2025 Season 1 on at
    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 Profile Picture
    sudosaurus 1,597 Super User 2024 Season 1 on at
    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 Profile Picture
    DJ_Jamba 2,623 Super User 2025 Season 1 on at
    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 Profile Picture
    sudosaurus 1,597 Super User 2024 Season 1 on at
    Add multiple selection people column to collection?
     
    I have just tried your suggestion, however AssignedTo0 is the only column which isn't displaying.
     
    All other columns load correctly. 
  • DJ_Jamba Profile Picture
    DJ_Jamba 2,623 Super User 2025 Season 1 on at
    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 Profile Picture
    sudosaurus 1,597 Super User 2024 Season 1 on at
    Add multiple selection people column to collection?
     
    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 Profile Picture
    DJ_Jamba 2,623 Super User 2025 Season 1 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,518 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,692 Most Valuable Professional

Leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Product updates

Microsoft Power Platform Community release plans