posts
Power Apps: Get SharePoint Site Owners with Power Automate
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.
posts
Power Apps: Overcoming Delegation Warnings When Searching Title field in SharePoint Lists
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.
posts
Power Apps Drop Down with Distinct Values and 'All' Option
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.