Answered

Filter multiple condition

(0) Share

Report

Posted on by benniwoessner

Hey im trying to filter Data by two conditions but i dont get it... i only want to filter if both conditions are right...

SortByColumns(Filter(Projektideen;StartsWith(Title;Suche_1.Text));"Title";If(SortDescending1;Ascending; Descending))

Thats the actual Code and i try to add the second condition with filters only the Data in which Business Contact = User().Fullname is. I hope you could help me! Thanks!

Update: Im filtering out of a sharepoint list

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

RusselThomas 4,014 on at

Like (10)

Report
Copy link

Link copied!
Hi benniwoessner,

You should be able to add conditions based on AND/OR (&& / II) logic as follows;

Filter(Projektideen;StartsWith(Title;Suche_1.Text) && condition && condition)
where condition would be further operations such as "Business Contact" = User().Fullname

Hope this helps,

RT

Was this reply helpful? Yes No
Verified answer

v-monli-msft Microsoft Employee on at

Like (6)

Report
Copy link

Link copied!
Hi @benniwoessner,

If the column name of the person column is "Business Contact", then the formula should be:

SortByColumns(Filter(Projektideen;StartsWith(Title;Suche_1.Text) && User().Email in Business_x0020_Contact.Email );"Title";If(SortDescending1;Ascending; Descending))

Notice that I used the email field, because that in my case it seems that DisplayName in person and group column and FullName in PowerApps user account do not match.

Regards,

Mona

Was this reply helpful? Yes No
gamos 8 on at

Like (1)

Report
Copy link

Link copied!

Thank you! I can't believe I had to search for this long to determine that && is AND and || is OR in Power Apps. Microsoft Power Platform really sucks in that sometimes you use a function (OR() works in Power BI) and in other parts of the platform, the same operation uses a different function or characters altogether . Microsoft, get your sh_t together.

Was this reply helpful? Yes No