Delegation warning on gallery filter

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tricky778 ,

Try this formula instead:
Filter(SampleData2, 'Plant Name'="Berlin" || 'Plant Name'="Stockholm")

Hope it helps !
Verified answer

WarrenBelz 156,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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 90 on at

Like
a
(0)

Report
Copy link

Link copied!

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