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

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 14 on at

Like (0)

Report
This works for me:

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

Was this reply helpful? Yes No
Krentor 70 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 14 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
Krentor 70 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 14 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Krentor 70 on at

Like (0)

Report

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.

Was this reply helpful? Yes No