Alternative solution - query producing delegation warning

(0) Share

Report

Posted on by Kirah

Hello,

I have a query that is suppose to produce me list of items that isn't in the first 20 rows, sorted alphabetically.

Filter('Exclusion List',Not(Title in FirstN(Sort( 'Exclusion List', Title),20).Title))

Now this query gives me delegation warning, due to the "IN" clause. This is all too complex for me, I don't even know where to begin writing alternative solution for this filter. Can anyone advise on alternative approach please?

Regards

Kira

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,371 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kira-Daw ,

Syntax is below, but you have a field referring to itself - what are you looking for in the Title field?

With( { wList: Sort( 'Exclusion List', Title ) }, Filter( FirstN( wList, 20 ), !(Title in Title) //this is wrong - you are referring to a field equalling itself ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Kirah 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz

Thanks for your response. I really appreciate it. I'm yet to give it a go...and see how it goes 🙂

The reason why I was referring to the same table is... basically I'm trying to filter a list alphabetically (it's a simple list with title and description column).

> Once filtered I want it to ignore the first 20 items in the list and bring me back the rest of the items from the same list...This is why I was referring to the same column..

Please let me know why I shouldn't refer to the same title equaling itself.... should I have relied on the description column instead?

Please let me get your view so that I can get better.

Regards
Kira

Was this reply helpful? Yes No
WarrenBelz 156,371 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kira-Daw ,

If you refer a field value to itself, all records will be true in the filter

Was this reply helpful? Yes No
Kirah 72 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
So sorry, I'm not getting too far with this. 😞
Can you advise me how I can achieve my goal as explained before, which is:

> Get all items in a Sharepoint List, sort the items alphabetically
> Then display the items that are not in the first 20, in a gallery.

I would appreciate your direction on this please.

Regards
Kira

Was this reply helpful? Yes No
WarrenBelz 156,371 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kira-Daw ,

I will leave out the filter as it is not doing anything presently

With( { wList: Sort( 'Exclusion List', Title ) }, LastN( wList, CountRows(wList - 20) ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

Kirah 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
@WarrenBelz Thanks for your input..
I actually ended up with something like this in the end.

With(
{
wList:
FirstN(Sort('Nominal Risk Exclusion List', Title),32)
},
Filter(
wList, Not(Title in FirstN(Sort('Nominal Risk Exclusion List', Title),20).Title)
)
)

Was this reply helpful? Yes No