Table of Contents Problem Statement Solution Overview Prerequisites Implementation Guide Step 1: Get Site and List IDs Step 2: Test with Graph Explorer Step 3: Initial Search Implementation Step 4: Handle Pagination Complete Code Examples Performance Considerations Conclusion Problem Statement After importing 10,000+ records into SharePoint using Power Automate bulk import techniques, we encountered Power Apps delegation limits that prevented effective searching and filtering of large datasets. There is the option of using Power Automate to get the results, however it adds more artefacts to a simple app designed for search.

Introduction I had to display SharePoint site owners withinin Power Apps for the selected SharePoint site for the end users who to reach out for any questions on the site. It was not possible using the Office365Groups which allows to interact with Ms Graph. I could not use the solution from https://reshmeeauckloo.com/posts/powerapps-list-owners-m365groups/ to help. I had to resort to Power Automate (Flow) with an HTTP request to SharePoint, parse the results, and return the owners to Power Apps to achieve the solution.

Introduction When building Power Apps with SharePoint lists, you may encounter delegation warnings especially when using the Search function on large datasets. This post explains why delegation matters, how it affects your app, and practical workarounds to enable effective searching. The Delegation Problem By default, if you create an app using the built-in template connected to a SharePoint list, the gallery’s Items property might be set to: Search([@FolderMappingDetails], SearchInput1.Text, Title, Title) This triggers a delegation warning because the Search function is not fully delegable to SharePoint.

Introduction Dropdown controls are essential for filtering and navigation in Power Apps. A common requirement is to display only distinct values from a data source (like a SharePoint list) and include a default ‘All’ option for easy selection. This post shows how to build a Power Apps dropdown with unique values and a default ‘All’ using PowerFx. Scenario Suppose you have a SharePoint list called FolderMappingDetails with a column named Database.

Introduction Filtering and searching data in a Power Apps gallery is a common requirement for building user-friendly business apps. This post shows how to combine a dropdown filter (with an ‘All’ option) and a search box to create a flexible, responsive gallery experience. Scenario Suppose you have a collection called colFolderMapping with a field named Database and a gallery displaying items. You want users to: Select a database from a dropdown (or ‘All’ to show everything) Search for items by title using a search box See results update instantly in the gallery PowerFx Formula Here’s the formula for the gallery’s Items property:

Introduction Listing members of Microsoft 365 Groups directly in Power Apps is a powerful way to build dynamic, user-aware business apps. This post shows how to use the Office365Groups connector and PowerFx to retrieve group members and display them in your app. Scenario Suppose you want to: Find a specific M365 Group by name (e.g., “Legal Team”) List all members of that group in Power Apps Use the results for permissions, notifications, or reporting PowerFx Formula Here’s how to get the group ID and list its members:

Introduction Listing owners of Microsoft 365 Groups in Power Apps is a powerful way to build dynamic, admin-aware business apps. This post shows how to use the Office365Groups connector and MS Graph API to retrieve group owners and display them in your app. Scenario Suppose you want to: Find a specific M365 Group by name (e.g., “Legal Team”) List all owners of that group in Power Apps Use the results for permissions, notifications, or reporting PowerFx Formula Here’s how to get the group ID, list its members, and extract owners:

Power Apps list forms deployment with help of solution Power Apps List forms are be default hidden from the list of apps from https://make.powerapps.com/. Deployment of list forms remains a challenge. This is my brief attempt to try to streamline the process using a solution. A solution within Power Platform makes it dataverse friendly. Let’s say you already have a list form tied to a list. In the background it is a hidden list.

Building a Quiz App with OpenAI GPT in PowerApps Discover how to create your very own quiz app in Power Apps using the OpenAI GPT (Independent Publisher). This app was inspired by Robin Rosengrün from his demo on Add OpenAI Capabilities to your Power Platform solutions . Prerequisites API Key Before integrating ChatGPT into PowerShell, you’ll need an OpenAI API key. You can obtain one by visiting OpenAI’s API key page and creating a new secret key.