Answered

RemoveIf does not remove collection item

(1) Share

Report

Posted on by CU23121026-0

Hey Everyone,

I recently got stuck with a Power Apps scenario. I have a SharePoint list in my Power Apps, which has a multi-person column. In my app I want to patch the current user in and out.
For adding the user into that column I have a logic which uses collections. Since normal patching would override the whole record, instead I'm creating a collection with the already existing people, then adding the current user in and then I patch it back to the list.

I wanted to follow the same logic when I want to remove the user from the list. But somehow I just can't remove the current user from the collection. Am I missing something?

This is how I tried:

ClearCollect(
    currentParticipants,
    LookUp(My_List, ID = ItemID).Members
);
RemoveIf(
    currentParticipants,
    Claims = "i:0#.f|membership|" & User().Email
);
 
Alternatively I tried doing this way too:
 
ClearCollect(
    currentParticipants,
    Filter(
        currentParticipants,
        Claims <> "i:0#.f|membership|" & User().Email
    )
);
 
None of them work.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

msoenmez 46 on at

Like (2)

Report

Equals operation inside Filter and RemoveIf is case sensitive. Since you are using User().Email and Claims objects, I suggest you check if they actually match, including uppercase and lowercase characters. e.g. Claims object can be "i:0#.f|membership|xyz(at)abc.com" and User().Email can be "XYZ(at)abc.com".

To make sure that equation is always correct you can use following logic :

ClearCollect(

currentParticipants,

LookUp(My_List, ID = ItemID).Members

);

RemoveIf(

currentParticipants,

Lower(Claims) = "i:0#.f|membership|" & Lower(User().Email)

);

-------

ClearCollect(

currentParticipants,

Filter(

currentParticipants,

Lower(Claims) <> "i:0#.f|membership|" & Lower(User().Email)

)

);

Was this reply helpful? Yes No
CU23121026-0 10 on at

Like (0)

Report

Thank you @msoenmez!
I completely overlooked on case sensitivity. The modified function works like a charm :)

Was this reply helpful? Yes No