Search rows (Dataverse) connector is giving me zero records all the times as results

[Abhishekchopra]

I want to perform search based on relevance instead of only based on exact string match. For that Search Rows is one connector for Dataverse which is in Preview mode. I followed all steps mentioned in below documentation but still it gives me zero records as results.

https://docs.microsoft.com/en-us/power-platform/admin/configure-relevance-search-organization#what-i...

Appreciate the immediate help. 

[HarryO · Accepted solution]

Hi

I have reviewed the information provided on yours issue with Search Rows returning no results.

I have outlined some steps below to try which is based on Relevance Search is enabled in the Power Platform Admin Centre.

If this a custom entity then please double check it is in the searchable with the below steps:

1.  Go to https://make.powerapps.com/ and ensure the correct environment is selected
2. Click on the Settings dropdown at the top of the page > Customization > Customize the System
3. In the pop out window, select Entities on the left column > click Configure Relevance Search
4. Confirm that your entity is within the Selected Entities field on the right. If not then please add it then allow some time for this change to take effect before testing

If the above has been done and the issue is still present then please ensure the specific tables are Searchable with the below steps.

1. Go to https://make.powerapps.com/ > click Data dropdown on the left side > select Tables
2. Find your Table and select it to open
3. Ensure the rows you're needing to pull data from has a tick in the Searchable column 
4. If it's not ticked then select the display name of the row to bring up the side menu and tick the Searchable box.

Please let me know if the above works for you.

Kind regards,
Harry.