Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Filter large SP list by Select Multiple Claims or string

(0) ShareShare
ReportReport
Posted on by
  • I have a large SP list (>5000 items).
  • My SP list has two columns: A select multiple Claims field and a comma separated single-line text field.
  • I am filtering by the logged in user.
  • I have two values that calculate on app start: Set(varUserEmail, User().Email);Set(varUserName, User().FullName);

I need to filter my gallery by this field, but have been unable to do so. I did find this, which had an example that didn't return a delegation warning, but still no luck. Is there a good way to do this using either of these fields?

 

This is what I have right now. I assume this doesn't work due to delegation issues:

ABureaux_0-1710455913889.png

 

Categories:
  • WarrenBelz Profile Picture
    WarrenBelz 145,508 on at
    Re: Filter large SP list by Select Multiple Claims or string

    Hi @ABureaux ,

    You are correct in that the in filter is not Delegable in SharePoint and you need it to filter inside a multi-value field.

    Is there any other Delegable filter that you can use to get the data down to under 2,000 items ? I assume you have indexed that column in SharePoint as this is needed over 5,000 items. Also can you please post your full code in text.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard