Filter collection if it contains string

(0) Share

Report

Posted on by Krentor

Hello,

i need a help to construct syntax which would help me to gather collection with name which is not contains "Ext."

I tried something like this:

Filter(colMemberCollection, !IsMatch(displayName, " Ext.",MatchOptions.Contains));

ForAll(colMemberCollection,RemoveIf(IsMatch(displayName, " Ext.",MatchOptions.Contains)));

But none of it actually works.

Thank you.

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

Martin Dráb 14 on at

Like
a
(0)

Report
Copy link

Link copied!
This works for me:

Filter(colMemberCollection, !IsMatch(displayName, "Ext.", MatchOptions.Contains))
Krentor 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
thank you for your answer. I tried that but same result in my collection. I still have in collection in this format "Name, Surname Ext." which i need to exclude.
Martin Dráb 14 on at

Like
a
(0)

Report
Copy link

Link copied!
It does the job for me even if I use the same value. Can you please test with the same collection as I did?
ClearCollect(colMemberCollection, { displayName: "abcd" }, { displayName: "Name, Surname Ext." }, { displayName: "xyz" })
If it works, we'll know that the problems is somewhere else than the formula.
Krentor 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure if it helps but the way i create collection is:
ClearCollect(colMemberCollection,Office365Users.DirectReportsV2(varPrihlasenyUzivatel).value);

From this collection i need to remove employees who have Ext. in their display name.
Martin Dráb 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, it doesn't really help, because know neither what data you have in colMemberCollection nor what value you're using as the pattern.

What will help is if you test the formula with known parameters, as I suggested. If it works, you'll know that the formula is correct and there is no point in trying to fix it, because the problem lies somewhere else.

Either the data isn't what you think (checking value is the first thing I would do), or you aren't using the formula correctly.
Krentor 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
sorry for late response as i was busy. However i tried your code:
ClearCollect(colMemberCollection, { displayName: "abcd" }, { displayName: "Name, Surname Ext." }, { displayName: "xyz" });
Filter(colMemberCollection, !IsMatch(displayName, "Ext.", MatchOptions.Contains));

and in collection colMemberCollection i can still see all three records, including one with Ext. Per my understanding, it should be working, but ist not. Im using this function in OnStart property.