Power Platform Community Forum Thread Details

I've been stuck for a while trying to think of a logic for my use case.

So what I want to happen is during edit, I have a combo box that has multi select enabled.
For example this multi select has 2 person with the name Winter and Snow

now after I want to edit it I change it to Winter and Casper.
in the list I want to remove only Snow ideally and then add in Casper.

What I am thinking of is

ForAll(
    colExistingParticipant as ExistingParticipant, 
    If(
        Not(ExistingParticipant.Participant.DisplayName in ForAll(ReviewParticipants_Edit.SelectedItems, DisplayName)),
        RemoveIf(
            AttachmentParticipants,
            cID = ExistingParticipant.cID && (LOGIC HERE?)
            {
                *how do I remove a single person in a column type???*
            }
        )    
    )
)

Categories:

Using Apps Using Formulas

Hi,

Seems like you post this again today as another question:

https://community.powerplatform.com/forums/thread/details/?threadid=c9e50c1b-8393-ef11-8a69-7c1e5246e2b5

I'm going to reply with the same answer. I think you are over complicating things.

You don't need to so much "remove" users as just set the field to the users you want. You already said if the user is not selected then you want them removed. This essentially means you want to set the field to what the user selected.

First you need to build a collection of the Selected Users:

ClearCollect(
    colSelectedUsers,
    ForAll(
        ComboBoxUsers.SelectedItems,
        {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
            Claims: "i:0#.f|membership|" & Lower(Email),
            DisplayName: DisplayName,
            Email: Email
        }
    )
);

Then Patch your list with the collection:

Patch(
    'YourSharePointList',
    Lookup('YourSharePointList', ID = locCurrentRecord.ID),
    {
        MultiSelectPersonField: colSelectedUsers
    }
);

Take a look at this article by Matthew Devaney which provides more examples and detail:

PATCH A SharePoint Person Column With Multiple People In Power Apps - Matthew Devaney

If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a Like.

Thanks
-Mark