Filter gallery condition Power apps

[Hardy299]

Hi,
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!

[Nogueira1306]

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)!

[Hardy299]

@Nogueira1306 

Here is the warning please

[Hardy299]

yet it works perfectly but these warring that worries me

[Nogueira1306]

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

[Hardy299]

@Nogueira1306 

Great, thank you

[Nogueira1306]

https://powerusers.microsoft.com/t5/Building-Power-Apps/Issue-with-quot-in-quot-operator-inside-quot...