Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Filter gallery condition Power apps

I have a concern with my gallery Power apps.
Let me explain: I have a List that I named "Article" and another that I named "ArticleEntite".
in the "ArticleEntite" list, I have the list of Articles that belong to an Entity (Company).


The code below therefore allows me to display the articles by entity:

Filter(Article, Actif=true, Nom in ShowColumns(AddColumns(Filter(ArticleEntite, EntiteId.Value=First(activeRole.display1).EntiteId.Value, Actif=true),"NomArticle",ArticleId.Value),"NomArticle") )

It works perfectly but shows me an error (Warring) that I cannot correct.
Thank you for your help!

Community Champion
Community Champion

Show us the warning.

I m guessing that the warning is a delegation error that says that the filter may be worst on large data sets.

The only ting you can do is filter y a unique value. 


If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!


Here is the warning please


yet it works perfectly but these warring that worries me

The error is on "In"... the only problem is if you have to much data... I will do a little bit of research and tell you..


Great, thank you

Community Champion
Community Champion

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,761)