How to Apply filter, Search and SortByColumn directly in Browse Gallery without a delegation warning in Power apps(data source: SharePoint list).

This post is to help you, how to get rid of delegation warnings in the Browse Gallery while filtering out the items from a SharePoint list without using any collection. 

There are multiple ways to overcome the 5000 records limit in power apps(will cover them in coming posts).

Script: use the below script in the Items action of  Browse Gallery.

SortByColumns( Filter( [@Test],Department="HR" Or Department="IT",

      StartsWith( Title, TextSearchBox1.Text ) ), "Title", If( SortDescending1,

      Descending, Ascending ) )



  For reference:



Dry Run:
  1. The SortByColumns () function is to sort records alphabetically. 

  2. Filter() this function is to retrieve only required items from an SP list.
    e.g. employees belong to IT or HR.

  3. After retrieving the required data, we are using the StartsWith() to Search records.



Final Result:



Use case Or Where I used it?

I'm working on a requirement, where I have a list with 5000+ records and in the power app, there is a limit of 2000 items at a time or we can fetch 2000 items in a single request.

There are multiple ways to deal with this scenario but for me, the quick hack was this, where I directly used the filter on columns and filtered out the required data without any delegation warning.

Hope this could help you, give it a try! 

Thank you!

FYI, will cover in the coming posts - the best ways to retrieve more than 5000 records from a SharePoint list.

Comments

Post a Comment

Popular posts from this blog

Effortlessly Import JSON Data into SharePoint with Power Automate Flow: A Step-by-Step Guide

Image
Effortlessly Import JSON Data into SharePoint with Power Automate Flow: A Step-by-Step Guide Importing data into SharePoint can be a time-consuming and complex task, but with Power Automate Flow, you can easily import JSON data into SharePoint with just a few clicks. In this post, we'll show you how to do just that with a step-by-step guide. Why Import JSON Data into SharePoint with Power Automate Flow? JSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy for humans to read and write and easy for machines to parse and generate. It's a popular format for exchanging data between different systems and applications, and it's often used to store and transfer data over the web. By importing JSON data into SharePoint, you can make this data easily accessible and manageable in SharePoint. How to Effortlessly Import JSON Data into SharePoint with Power Automate Flow Here's a step-by-step guide to effortlessly importing JSON data into SharePoin...
Read more

Generic Design Powerapps, Sharepoint and flow

  1. Backend: SharePoint You will use SharePoint to store all the data required for the event management system. Create the following SharePoint lists for different entities: Event List : Stores event details (e.g., Event Name, Date, Location, Description, Organizer, Capacity, Registration Deadline). Columns: Title, EventDate, Location, Description, Organizer, Capacity, RegistrationDeadline, etc. Attendees List : Tracks attendees for each event. Columns: AttendeeName, Email, Event (Lookup to Event List), RegisteredDate, Status (Registered, Waitlisted), etc. Feedback List : Captures feedback from attendees post-event. Columns: Event (Lookup), Attendee (Lookup), Rating, Comments, etc. Notification Settings List : Manages notification triggers and timing for automated emails. Columns: NotificationType (e.g., Reminder, Registration Confirmation), TimeBeforeEvent (in hours/days), EmailTemplate, etc. 2. Front End: Power Apps The Power Apps application will serve as the main interface for...
Read more