Answered

Filter multiple condition

Like (0) Share

Report

Posted on 3 Aug 2018 07:56:13 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

All responses (3)

Answers (1)

gamos 8 on 29 May 2024 at 18:46:50

Like (1)

Report

Re: Filter multiple condition

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.
Verified answer

v-monli-msft on 06 Aug 2018 at 07:46:01

Like (6)

Report
Re: Filter multiple condition

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
RusselThomas 4,012 on 03 Aug 2018 at 10:27:12

Like (10)

Report
Re: Filter multiple condition

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