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

Power Apps June 2023 Updates (Canvas App Focused)

Power Apps June 2023 Updates Power Apps June 2023 Updates Enhanced Component Properties Enhanced component properties are a new feature for Microsoft Power Apps that provide clearer and simpler concepts for properties. They are now divided into four types: Data properties: Simple properties that provide input or output data. Function properties: Properties that can accept arguments and return a value, but do not support data flow yet. Events and Actions: Behavior properties that can change the state of the app, such as updating a variable or manipulating a data source. The feature aims to make properties more intuitive and flexible, and to support more scenarios and behaviors. The team has updated the experimental feature and added support for SetFocus() and Select() in the existing. Read more: Enhanced Component Properties Blog Introducing an Easier Than Ever Experience to Import Data from Excel The document announces
Read more

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

Unleash the Power of Power Apps: Retrieve Over 2000 Records from a SharePoint List Effortlessly Without Delegates

Image
Unleash the Power of Power Apps: Retrieve Over 2000 Records from a SharePoint List Effortlessly Without Delegates Working with large data sets can be a challenge, especially when it comes to retrieving data from a SharePoint list using Power Apps. The traditional method of retrieving data from a SharePoint list is by using delegates, which can be time-consuming and may even limit the amount of data you can retrieve. But what if we told you there's a better way to do it? In this tutorial, we'll show you how to retrieve over 2000 records from a SharePoint list using Power Apps without delegates. That's right, you can easily retrieve a large number of records in just a few simple steps. To get started, watch our step-by-step video guide on how to do it: https://youtu.be/R2wHybiwDNQ In this video, we'll show you how to create a Power App that retrieves data from a SharePoint list and displays it in a gallery. We'll also show you how to apply a filter to the data so that
Read more