Delegation warning on gallery filter

[Tricky778]

I'm working with a SharePoint list (Named: SampleData2) containing 20,000 rows of data.

One column within the list is a single line of text column named 'Plant Name'.

I have a gallery within the PowerApp which is looking at the SharePoint list and carrying out a filter to return 1 x 'Plant Name' (in this example 'Berlin'.

This works fine. 

Items:            Filter(SampleData2,
                     'Plant Name' = "Berlin")

However, when I add a second filter criteria (to return both "Berlin" and "Stockholm") I then get a delegation warning and the blue underline of "Stockholm". 

So I gather you cannot filter on more than one criteria without stumbling into the delegation issue. Can anyone think of a workaround regarding this please? 

[gabibalaban]

Hi @Tricky778 ,

Try this formula instead:

Filter(SampleData2, 'Plant Name'="Berlin" || 'Plant Name'="Stockholm")

Hope it helps !

[WarrenBelz · Accepted solution]

Hi @Tricky778 ,

Try

Filter(
   SampleData2,
   'Plant Name' = "Berlin" ||
   'Plant Name' = "Stockholm"
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Tricky778]

Thank you @WarrenBelz & @gabibalaban , both worked perfectly. User error 🙂