Enabled Dataverse search in the Microsoft Dataverse environment

-
Search is a very powerfull feature when properly configured. Here is a quick step through on how to implement search in Power Pages.

Enable Search in the environment

  • Go to the Power Platform Admin Center. 
  • Open the administration settings for the Microsoft Dataverse environment and navigate to the search or options settings. 
  • Enable "Dataverse Search." This needs to be done once for each environment.



Enabled Dataverse search in Power Pages 

  • Go to Portal Management for the Power Pages site and click on Site Settings. 
  • Filter the settings for search. 
  • Make sure that EnableAdditionalEntities, Enabled, and EnableDataverseSearch are set to "true." 
  • Ensure that the table to be included in the search is included in the filters. 
Note that tables are listed with the category first, followed by the column and table name. If multiple tables fall under the same category, they should be separated by a comma. Categories with tables are separated by a semicolon. This setting needs to be updated every time the search is expanded to include multiple tables.


Creating a Portal Search View

To be able to index the columns in each table, we need to create a search view. 
  • Go to make.powerapps.com and find the table for which you want to create a view, then click on "Views."


  • Create a new public view and give it a name that is logical for the search. 
  • Apply any desired filtering or sorting. 
  • Once this is done, go back to Portal Management and site settings. 
  • Set the Search/IndexQueryName to the name of the search view, "Ready Power Pages Search."



Enable table permissions

To allow users to see search results, we need to set access levels for the table and choose which roles should have read access. 


Create a page to display search results 

If a page to display details of a search result does not already exist, it needs to be created. 
  • Go to make.powerpages.microsoft.com and select new page. 
  • Give the page a name and choose a suitable layout.
  • Add a form to the page that will display the result, such as a contact.


Create a Site Marker for the search result 

To be able to display the result in the search, we need to create a Site Marker for the search result. This holds the page that is chosen to display the result, but most importantly, it needs to be named correctly. In this case, the name should be "contact_SearchResultPage." Therefore, it is the machine name (logical name) of the table, followed by "_SearchResultPage."



Further customizations 

Here you will find an overview of additional customization options for the search.

Rebuild the search index by restarting the Power Pages website 

  • To reindex: Go to the Power Platform Admin Center and click on Resources -> select the appropriate Power Pages site and choose Restart Site under Site Actions.



This should cover what you need to include your tables and entities in your global Power Pages search. :)

Cheers,
Morten

Comments

Post a Comment

Popular posts from this blog

Designing and programming - Part 2

-
This part of the series will handle the creative part of the cycle. You might loosely categorize the steps of the design process in three different stages. First is the creative methods - this stage contains methods that drives the design project forward adding new ideas and features to the design. However, systemizing the ideas and filtering them is also part of this stage. The next stage contains different methods of implementation. This is where the ideas meet the matter - where ideas become code and components. You get the idea:) The third and last stage is perhaps the most crucial one. This is where you test and evaluate your results. It is now that you have to decide whether the implementations meet with the requirements and visions of the design. The outcome of this stage will determent if the prototype is ready for some real world testing, also called a beta. Anyways, after clearing that up, the creative stage is what this part of the series will be all about. The Creati
Read more

Filtering Dropdown choices in a Power Pages form using Dataverse Relations

-
Image
Filter dropdowns Dropdown filters are a useful feature in form design, allowing users to filter options in one dropdown based on other selections in the form. In Power pages, leveraging the capabilities of Dataverse relations makes it possible to create these powerful filtering mechanisms. This is how it works. What you need to know first. Before we dive into the implementation details, ensure that you have a basic understanding of Power Pages forms and Dataverse relations.  How is´t made Create two tables in your Dataverse environment: "Type" and "Category." These tables will hold the relevant data for the dropdowns. Establish a Lookup Relationship between the "Category" and "Type" tables. Create a lookup column in the "Category" table that references the "Type" table. This lookup column will allow us to filter the categories based on the selected type. Now, create a third table called "Request." This table will ser
Read more

Exploring the Power of Variables in Liquid and Power Pages

-
Covering the basics - Variables As a templating language, Liquid offers a rich collection of possibilities for web developers and designers, bringing Dynamics business data to the web. Variables in Liquid enable us to display dynamic content and enable us to implement a certain level of custom logic as well. We'll have a look at some examples on how to work with variables. Variable Assignment In Liquid, variables can be assigned values using the {% assign %} tag. For example, let's assign the value "Hello, Nerd!" to the variable greeting: {% assign greeting = 'Hello, Nerd!' %} Variable Output Once a variable is assigned a value, it can be outputted using the {{ }} syntax. To display the value of greeting, we can use: {{ greeting }} Assigning Site Settings Liquid is powerfull enough to allow you to assign values from site settings to variables. For example, if you need the site setting for inactivity for
Read more