Power Apps: Search SharePoint Content

Key insights

• Canvas App workshop overview:
  summary of a 4-hour live, hands-on session that builds a multi-screen Canvas App from scratch using SharePoint Lists as the data source. The session focuses on a real business scenario and practical, production-ready techniques.
• Search approaches:
  Power Apps uses two main ways to find SharePoint content — delegated searches against lists for structured records, and the historical Microsoft Search connector for broader file searches; plan new solutions around Microsoft’s current connector guidance because the older connector is documented as deprecated.
• Delegation and Power Fx:
  Delegation lets SharePoint do filtering and sorting so apps avoid downloading large lists. Use StartsWith for delegated text searches; functions like Search and In may not delegate and can force local-only searches.
• App patterns and business search:
  Build focused interfaces (help-desk lookup, contract search, inventory, compliance portals) that filter by status, date, choice, or person and use reusable Power Fx patterns for consistency and scale.
• Security and scope:
  Search results remain security-trimmed by SharePoint and OneDrive, and you can restrict searches to specific sites or paths to limit results to approved libraries or compliance areas.
• AI and MCP Server:
  The new Canvas Apps MCP Server plus AI skills can speed development and improve the authoring experience, helping teams deliver scalable, production-ready apps faster.

Reza Dorrani recently published a detailed YouTube workshop that demonstrates how to build a production-ready multi-screen Canvas app using Power Apps and SharePoint Lists. In this live, hands-on session, he walks viewers through a real business scenario over four hours, focusing on practical techniques rather than a feature-by-feature tour. Consequently, the video serves both as a step-by-step build and as a primer on advanced app patterns that makers can reuse. For newsroom readers, the session highlights how modern low-code practices pair with AI to speed development.

Workshop scope and learning goals

The workshop aims to teach viewers how to design and build a complete multi-screen Canvas app while using SharePoint Lists as the backend. Dorrani emphasizes modern data entry patterns, advanced search and filtering, and reusable Power Fx techniques that support scalable applications. In addition, he introduces the new Canvas Apps MCP Server alongside AI skills, showing how these tools can accelerate authoring and reduce repetitive work.

Importantly, Dorrani frames the session for makers and developers at Level 200–300, meaning attendees are expected to have basic familiarity with the Power Platform. Therefore, the workshop focuses on deeper topics such as delegation, performance tradeoffs, and production-ready architecture instead of introductory setup steps. As a result, viewers can apply the lessons directly to enterprise scenarios.

Technical approach and key techniques

At the heart of the demo is the connection between Canvas apps and SharePoint Lists, where a gallery displays filtered and sorted records using Power Fx formulas. For example, Dorrani shows how functions like StartsWith can remain delegated to SharePoint to avoid retrieving entire lists. Meanwhile, he contrasts delegated functions with non-delegable expressions such as Search or In, which can force client-side operations and limit scalability.

Moreover, the workshop covers how to use the Microsoft Lists integration to create apps directly from a list and how to structure galleries for common scenarios like help-desk lookups and inventory searches. Dorrani also demonstrates reusable patterns—components and formulas—that make maintenance easier and speed future builds. Finally, he explores how the deprecated status of the Microsoft Search connector affects broader file search strategies across SharePoint and OneDrive.

Advantages and tradeoffs

One clear advantage Dorrani highlights is the ability to reuse existing SharePoint content and permissions, which avoids costly duplication of data. Consequently, organizations can keep metadata, libraries, and security intact while providing a tailored interface in Power Apps. Furthermore, delegation enables efficient queries on large lists by letting the data source do the heavy lifting.

However, tradeoffs exist. For example, delegable functions restrict the kinds of searches you can run directly against SharePoint, which forces makers to balance user expectations with technical limits. In addition, reliance on connectors and platform features means your solution must adapt if Microsoft changes or deprecates connectors. Therefore, Dorrani recommends designing flexible data models and implementing fallbacks for non-delegable scenarios.

Challenges and recommended best practices

Dorrani points out several practical challenges, such as handling very large lists, ensuring permission-aware results, and building responsive layouts for mobile users. To mitigate these issues, he advises creating indexed columns, filtering early in the query chain, and limiting returned columns to improve performance. In addition, he stresses testing with real user accounts so that security trimming behaves as expected.

When dealing with enterprise file search, he notes the Microsoft Search connector can filter by site or path but may be deprecated, which adds risk to long-term reliance. Thus, he proposes hybrid approaches that combine list-based data with selective file indexing or alternate connectors where needed. Overall, the best practice is to document tradeoffs and choose patterns that balance performance, maintainability, and future platform changes.

Audience and practical takeaways

The video is aimed at Power Apps makers, Power Platform developers, and solution architects who want hands-on guidance for building scalable apps. It benefits teams that use SharePoint as a content store and want to improve search, data entry, and app performance without moving data into separate databases. Consequently, viewers can leave with concrete patterns for galleries, filters, and reusable Power Fx formulas.

To summarize, Reza Dorrani’s workshop provides a pragmatic roadmap for building production Canvas apps with SharePoint, while also addressing the tradeoffs between delegation, connector strategy, and future-proofing. In short, the session balances practical coding examples and architectural guidance, making it a useful resource for anyone moving toward enterprise-ready low-code solutions.

Who should watch

• Power Apps makers seeking advanced, reusable patterns
• Developers and solution architects focused on SharePoint integration
• Teams that need to balance search capabilities with platform limits

Keywords

Power Apps SharePoint search, Search SharePoint in Power Apps, Search SharePoint lists Power Apps, Search SharePoint documents Power Apps, Power Apps delegation SharePoint search, Power Apps search gallery SharePoint, Filter SharePoint list Power Apps, Lookup SharePoint items Power Apps