web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps Sharepoint delegation ...

Power Apps

Unanswered

Sharepoint delegation warning on filter function

(0) Share

Report

Report

Posted on by Nao_

121

Hello everyone,

In a Sharepoint integrated powerapp, i want to have a gallery filtered with my SharepointIntegration item.

I did this formula :

Filter('My List', LookupCol.Value = SharePointIntegration.Selected.Reference)

But i have a delegation warning. My Source list will be over 2k items, so I have to avoid it.

Does anybody know how to avoid delegation warning in this case?

I would prefer to keep my "Reference" column as a lookup rather than the ID

Thanks !

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like (1)

Report
Re: Sharepoint delegation warning on filter function

Hello @Nao_ ,
Its Ideal to use Id ,
But still you can try below formula for avoiding Delegation:

Filter(AddColumns('My List', "CustomValue",LookupCol.Value),CustomValue = SharePointIntegration.Selected.Reference)

Was this reply helpful? Yes No
Nao_ 121 on at

Like (0)

Report
Re: Sharepoint delegation warning on filter function

Thank you, this is exactly what I wanted !

And for those who wants to remove the extra column after the formula :

DropColumns(Filter(AddColumns('My List', "CustomValue",LookupCol.Value),CustomValue = SharePointIntegration.Selected.Reference), "CustomValue")

Was this reply helpful? Yes No

Join the conversation