Study guide

2.1 Dataverse Search, Quick Find & Relevance Indexing

Microsoft Power Platform Functional Consultant PL-200

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Dataverse Tables, Relationships & Core Columns

1.1 Dataverse Table Types, Properties & Ownership 1.2 Table Relationships & Cascading Rules 1.3 Column Types, Formats, Primary Keys & Alternate Keys 1.4 Rollup, Calculated & Formula Columns with Power Fx

2 Chapter 2: Dataverse Data Management & Governance

2.1 Dataverse Search, Quick Find & Relevance Indexing 2.2 Auditing Configuration & Log Management 2.3 Duplicate Detection Rules & Settings 2.4 Bulk Record Operations, Data Import, Export & Templates

3 Chapter 3: Dataverse Security Model & Access Control

3.1 Business Units, Ownership Models & Modern BU Matrix 3.2 Security Roles, Privileges & Depth Levels 3.3 Teams Architecture: Owner, Access, and Microsoft Entra (AAD) Group Teams 3.4 Column-Level Security & Hierarchy Security Models

4 Chapter 4: Model-Driven App Fundamentals & Information Architecture

4.1 Model-Driven App Design, Site Map Navigation & Modern App Designer 4.2 Form Types: Main, Quick Create, Quick View & Card Forms 4.3 View Configuration, System Views, Personal Views & Filters

5 Chapter 5: Advanced Model-Driven App Components & Custom Pages

5.1 Custom Pages & Modern Commanding with Power Fx 5.2 Form Component Controls & Specialized UX Elements 5.3 Embedding Canvas Apps in Model-Driven Forms 5.4 Embedding Power BI Reports, Dashboards & Tiles

6 Chapter 6: Canvas Apps Structure, Formulas & Data Operations

6.1 Canvas App Architecture, Screens, Containers & Controls 6.2 Power Fx Formulas, Delegation & Data Source Limits 6.3 Variables (Context, Global), Collections & State Management 6.4 Triggering Power Automate Cloud Flows from Canvas Apps

7 Chapter 7: Power Pages Site Design, Navigation & Content

7.1 Power Pages Design Studio & Site Structure 7.2 Power Pages Templates, Styling & Responsive Layouts 7.3 Web Pages, Navigation Menus & Content Snippets

8 Chapter 8: Power Pages Data Integration, Forms & Web Roles

8.1 Power Pages Lists, Basic Forms & Advanced Forms 8.2 Table Permissions, Web Roles & Page Access Security 8.3 External Identity Providers & Authentication Configuration

9 Chapter 9: Power Automate Cloud Flow Fundamentals & Triggers

9.1 Cloud Flow Types: Automated, Instant, Scheduled & Desktop Overview 9.2 Dataverse Connector Triggers & Operational Filters 9.3 Standard Connectors, Custom Connectors & Connection References

10 Chapter 10: Cloud Flow Actions, Expressions & Logic Controls

10.1 Logic Controls: Conditions, Switches, Apply to Each & Do Until Loops 10.2 Variables, Data Operations & Dynamic Content Manipulation 10.3 Power Automate Expression Language (WDL / Functions) 10.4 Error Handling, Configure Run After & Scope Controls

11 Chapter 11: Business Process Flows & Guided Processes

11.1 Business Process Flow Architecture, Stages, Steps & Data Steps 11.2 Branching Rules & Multi-Entity Business Process Flows 11.3 BPF Action Steps, Workflows & Cloud Flow Execution 11.4 BPF Security Roles, Order & Process Lifecycle

12 Chapter 12: Classic Workflows, Business Rules & Modern Logic Extensibility

12.1 Classic Dataverse Workflows: Real-Time vs. Background (Async) 12.2 Business Rules: Scope & Actions 12.3 Low-Code Plug-ins in Dataverse: Automated vs. Instant 12.4 Troubleshooting Automations, Run History & Analytics

13 Chapter 13: Power Platform Environment Architecture & Security

13.1 Environment Types: Default, Sandbox, Production, Trial, Developer 13.2 Environment Governance, Groups, Routing & Capacity Management 13.3 Data Loss Prevention (DLP) Policies & Connector Classifications

14 Chapter 14: Application Lifecycle Management (ALM) & Solutions

14.1 Unmanaged vs. Managed Solutions & Solution Layering Mechanics 14.2 Solution Components, Dependencies, Publishers & Prefixes 14.3 Exporting, Importing, Upgrading & Patches 14.4 Solution Checker, App Checker & ALM Best Practices

15 Chapter 15: Enterprise Interoperability & Service Integration

15.1 Exchange / Server-Side Synchronization & Email Integration 15.2 SharePoint & OneDrive Document Management Integration 15.3 Microsoft Word & Excel Document Templates

16 Chapter 16: Copilot, AI Capabilities & Exam Strategy

16.1 Copilot Studio & Generative AI across Power Platform 16.2 AI Builder Prebuilt & Custom Models in Apps and Flows 16.3 PL-200 Exam Strategy, Time Management & Question Analysis

2.1 Dataverse Search, Quick Find & Relevance Indexing

Key Takeaways Explain This Topic AI

Dataverse Search (formerly Relevance Search) leverages Azure Cognitive Search / Azure AI Search behind the scenes to deliver AI-driven, relevance-ranked global search across multiple tables through a single unified search box.

Enabling Dataverse Search is an environment-wide setting configured in the Power Platform Admin Center (PPAC) under Settings > Product > Features, which provisions an external dedicated search index.

Tables must have 'Track changes' enabled in their table properties to participate in Dataverse Search, and their searchable attributes must be configured as 'Find Columns' within the table's Quick Find Active Records View.

Dataverse Search supports Lucene query syntax, wildcards (*), exact phrase matching with quotation marks, fuzzy matching (~), term boosting (^), and natural language queries.

Security trimming executes in real time: search results strictly enforce Dataverse record-level ownership, business unit privileges, sharing, and column-level security profiles so users only see authorized data.

Last updated: August 2026

Dataverse Search, Quick Find & Relevance Indexing

Efficient information discovery is a core requirement of enterprise business applications. In Microsoft Dataverse, users interact with multiple search mechanisms ranging from single-table lookups to cross-entity, AI-powered natural language queries. For the PL-200: Microsoft Power Platform Functional Consultant exam, you must master the architecture, administration, configuration, and behavioral differences among Dataverse Search , Categorized Search , and table-specific Quick Find Views .

Understanding how Dataverse indexes data, synchronizes records with cloud search engines, and enforces security boundaries ensures you can design high-performing search experiences without compromising compliance or data governance.

1. Search Architecture in Microsoft Dataverse

Microsoft Dataverse provides three primary search experiences, each built on distinct back-end technologies and tailored to specific operational needs. +-----------------------------------------------------------------------------------+

  • | DATAVERSE SEARCH ARCHITECTURE OVERVIEW |
  • | |
  • | [Model-Driven App / Global Search Bar] |
  • | | |
  • | +---> Single Unified Query: "Contoso Redmond active order" |
  • | |
  • | +---------------------------+ +-----------------------------------+ |
  • | | DATAVERSE SQL ENGINE | | AZURE COGNITIVE SEARCH | |
  • | | (Primary Dataverse DB) | | (External Search Index) | |
  • | | | | | |
  • | | - Quick Find Views | | - Cross-table relevance ranking | |
  • | | - Relational queries | | - Natural language parsing | |
  • | | - SQL 'Like' operators | | - Fuzzy matching & faceting | |
  • | | - Synchronous execution | | - Asynchronous index sync | |
  • | +-------------+-------------+ +-----------------+-----------------+ |
  • | | ^ |
  • | | (Change Tracking via Service Bus Pipeline) | |
  • | +=============================================+ |
  • +-----------------------------------------------------------------------------------+
  • Comparative Analysis of Dataverse Search Modalities

Search Feature Technology Engine Scope Query Capabilities Security & Performance

Dataverse Search (formerly Relevance Search) Azure Cognitive Search (Azure AI Search) Cross-table (all indexed tables in environment) Natural language, fuzzy matching ( ~ ), Lucene syntax, faceting, lemmatization Results ranked by relevance score; asynchronous sync; real-time security trimming

Categorized Search (Classic Multi-table) Dataverse Relational SQL DB Cross-table (up to 10 tables maximum) SQL wildcard prefix matching ( *term* ), exact text match Grouped by entity type; synchronous query; high SQL compute consumption

Quick Find (Single Table / Grid) Dataverse Relational SQL DB Single Table (e.g., Active Accounts) Wildcard matching based on configured 'Find Columns' Evaluated against database view filters and relational indexes

Note

Historical Context: Dataverse Search was previously known as Relevance Search . In modern Model-Driven apps, Dataverse Search is the default global search experience when enabled by an administrator. Categorized search is retained for legacy compatibility.

2. Enabling & Administering Dataverse Search in PPAC

Enabling Dataverse Search is an environment-level administrative action performed in the Power Platform Admin Center (PPAC) . +-----------------------------------------------------------------------------------+

  • | PPAC DATAVERSE SEARCH ENABLING SEQUENCE |
  • | |
  • | [PPAC] ---> Environments ---> Select Environment ---> Settings |
  • | | |
  • | v |
  • | [Product] ---> Features ---> Dataverse search: Toggle [ON] |
  • | | |
  • | v |
  • | [Optional] ---> Enable Lucene query syntax & full search capabilities |
  • | | |
  • | v |
  • | [Background] ---> External Azure Cognitive Search Index Provisioned |
  • | (Initial synchronization starts automatically) |
  • +-----------------------------------------------------------------------------------+
  • Step-by-Step Administrative Activation

Navigate to the Power Platform Admin Center ( admin.powerplatform.microsoft.com ).

In the navigation pane, select Environments , then choose the target environment.

Select Settings from the command bar, expand Product , and click Features .

Under the Search section, locate Dataverse search and switch the toggle to On .

Optionally enable advanced search capabilities (Lucene query syntax).

Click Save at the bottom of the page.

Once enabled, Dataverse begins provisioning an external Azure Cognitive Search index and initiates an asynchronous baseline sync. Depending on database size and the number of indexed tables, initial indexing may take from several minutes to a few hours.

3. Configuring Searchable Tables & Quick Find Views

Enabling the environment-level toggle is only the first step. Functional consultants must configure which tables and which specific columns participate in search indexing. +-----------------------------------------------------------------------------------+

  • | TABLE & COLUMN INDEXING CONFIGURATION FLOW |
  • | |
  • | 1. TABLE PROPERTY: |
  • | Enable [Track changes] on Table Definition (Prerequisite) |
  • | | |
  • | v |
  • | 2. SOLUTION EXPLORER / MAKER PORTAL: |
  • | Add Table to Search Index (Manage Search Index) |
  • | | |
  • | v |
  • | 3. QUICK FIND ACTIVE RECORDS VIEW: |
  • | +-----------------------------------+-----------------------------------+ |
  • | | EDIT FIND TABLE COLUMNS | EDIT VIEW COLUMNS | |
  • | | (Defines what attributes can be | (Defines what attributes are | |
  • | | searched / matched against) | displayed in search result cards)| |
  • | +-----------------------------------+-----------------------------------+ |
  • +-----------------------------------------------------------------------------------+
  • Prerequisite: Change Tracking

For a table's data to synchronize continuously with the external Azure Cognitive Search engine, Track changes must be enabled on the table properties:

Open make.powerapps.com > Solutions > Select your Solution.

Select the Table > Edit Table properties > Expand Advanced options .

Check Track changes and save.

Important

If Track changes is disabled on a table, the table cannot be added to the Dataverse Search index. Change Tracking utilizes the Dataverse asynchronous service bus to replicate row inserts, updates, and deletes to Azure Cognitive Search in near-real-time.

Quick Find View Configuration: Find Columns vs. View Columns

Dataverse Search uses the table's default Quick Find Active Records View to determine indexing behavior:

Find Table Columns (Search Fields): These are the text, numeric, and lookup columns that Azure Cognitive Search indexes. When a user enters a query, Dataverse Search evaluates matches against these columns only. Examples include Account Name , Account Number , Telephone , and Email Address .

View Columns (Display Fields): These columns dictate the fields returned and rendered on search result cards and snippet previews in the model-driven user interface.

Filter Criteria: The view's underlying filter criteria (e.g., Status Equals Active ) dictate which records are indexed. Inactive or filtered-out rows are automatically excluded from the search index.

Quick Find View Property Operational Purpose PL-200 Exam Impact

Find Columns Determines searchable attributes indexed into Cognitive Search. If users complain they cannot search accounts by Tax ID , add Tax ID to Find Columns and republish.

View Columns Determines visible output fields shown in result lists. If users complain that search results do not display the Primary Contact , add Primary Contact to View Columns .

Filter Criteria Limits scope of indexed records (typically StateCode = Active ). Deactivated records are excluded from Quick Find and Dataverse search results by default.

4. Search Syntax, Operators & Lucene Querying

Dataverse Search provides powerful query syntax, supporting plain text, natural language, and advanced Lucene operators. +-----------------------------------------------------------------------------------+

  • | DATAVERSE SEARCH SYNTAX EXAMPLES |
  • | |
  • | [WILDCARD PREFIX] ---> cont* (Matches Contoso, Continental) |
  • | [EXACT PHRASE] ---> "northwind inc" (Matches exact phrase inside quotes) |
  • | [BOOLEAN OPERATOR] ---> legal AND audit (Must contain both terms) |
  • | [BOOLEAN NEGATION] ---> sales NOT retail(Contains sales, excludes retail) |
  • | [FUZZY MATCHING] ---> telecom~ (Matches telekom, telecon, etc.) |
  • | [GROUPING] ---> (corp OR inc) AND seattle |
  • +-----------------------------------------------------------------------------------+
  • Detailed Query Syntax Guide

Operator / Syntax Behavior Practical Example Expected Match

Simple Term Performs word-stemming and lemmatization across indexed fields. run Matches running , runs , ran , and run .

Exact Phrase ( " " ) Matches exact sequence of words enclosed in double quotes. "Fourth Coffee" Matches only the full string Fourth Coffee , not Coffee Fourth .

Wildcard ( * ) Matches zero or more characters. Must be placed as a suffix or infix. tele* Matches telephone , telecom , telemetry .

Boolean AND / + Requires both terms to exist in the record. Must be uppercase. Redmond AND Hardware Matches records containing both Redmond and Hardware .

Boolean OR / | Matches records containing either term. Default behavior. Dallas OR Houston Matches records containing Dallas , Houston , or both.

Boolean NOT / - Excludes records containing the specified term. Must be uppercase. Consulting NOT Tax Matches records with Consulting but omits any with Tax .

Fuzzy Search ( ~ ) Identifies matches with character misspellings or typographic errors. smth~ Matches Smith , Smyth , Smooth .

Grouping ( ( ) ) Precedence grouping for complex multi-condition queries. (Austin OR Dallas) AND Medical Matches Medical records located in either Austin or Dallas .

Tip

Boolean Syntax Rules: Boolean operators ( AND , OR , NOT ) must be entered in ALL UPPERCASE letters . If entered in lowercase ( and , or , not ), Dataverse Search treats them as literal search keywords rather than logical operators.

5. Security Trimming & Search Index Governance

A critical architectural advantage of Dataverse Search over external indexing tools is its real-time security trimming . +-----------------------------------------------------------------------------------+

  • | SECURITY TRIMMING PIPELINE |
  • | |
  • | [User Submits Search] ---> Azure Cognitive Search retrieves candidate rows |
  • | | |
  • | v |
  • | [Dataverse Security Engine] evaluates user context: |
  • | - User Security Roles & Depth (User, BU, Parent-Child, Org) |
  • | - Direct Record Sharing & Access Teams |
  • | - Column-Level Security (Field Security Profiles) |
  • | | |
  • | v |
  • | [Results Rendered] ---> User sees ONLY records they have Read privilege on. |
  • | Unauthorized columns appear as masked/hidden. |
  • +-----------------------------------------------------------------------------------+
  • Index Capacity & Storage Limits

Azure Cognitive Search indexes do not consume standard Dataverse Database storage; search index costs are bundled into Power Platform capacity.

Administrators can configure up to thousands of total searchable fields across an environment, but best practice dictates indexing only business-critical lookup and identification columns to preserve indexing throughput and query performance.