Let us say you are on call with your customer and you want to check what information (Contact, Leads, Opportunities, emails, etc.) about this customer you have in your CRM.<\/p>\n
In this situation, we can use the Relevance search feature which will search your customer across all the tables in the system and will show it in the result list.<\/p>\n
In the above screenshot, we searched for \u2018Nancy\u2019 and it showed the search results which included contact and lead.<\/p>\n You can use this feature inside your Dynamics 365 CRM environment but what if you want to use Relevance Search functionality in your external system, say a custom portal or any other external app or plugin or Power Automate or Canvas App?<\/p>\n Here the Relevance Search API<\/a> comes into the picture. We can use this API provided by Microsoft to add a relevance search feature to your project.<\/p>\n POST [Organization URI]\/api\/search\/v1.0\/query This blog will illustrate how we can use the Relevance Search API to add the Relevance search feature into the Canvas app.<\/p>\n I am dividing this blog into two parts. In the first part, we will create a Power Automate Flow to execute the Relevance Search API and in the second part, we will design a simple Canvas app then we will call the Power Automate flow to show the search results.<\/p>\n Let us start with creating a Power Automate Flow that can be call from the Canvas App.<\/p>\n \u2022 Create new Instant cloud Flow and select the PowerApps trigger.<\/p>\n \u2022 This will create a Power Automate Flow, which we can later call from the Canvas App. Give an appropriate name to the Flow.<\/p>\n \u2022 Add the next step to initialize the variable and assign the text that the user wants to search for across the multiple tables.<\/p>\n \u2022 To execute the Relevance search API, we first need to get the Access Token to authenticate the request. To do this we will use HTTP Request action.<\/p>\n Add new Step in the flow and select the HTTP request.<\/p>\n In this step, we are obtaining the access token that can be used to execute the Relevance Search API request.<\/p>\n Here we are using the Application User, which is a non-licensed user to generate the Access token. You will get the client id and secret key of your registered application in Azure Active Directory.<\/p>\n Pass the parameter to the HTTP step as below.<\/strong> After this step, run and test the Power Automate Flow manually to check whether we are getting the access token or not.<\/p>\n \u2022 Add another HTTP Request step where we will execute the Relevance search API request with the following details,<\/p>\n Method:<\/strong> POST \u2022 Save and run the flow again and check the response of the above HTTP Request step.<\/p>\n \u2022 Add Parse JSON step after HTTP Request. Here we will pass the response from the above step to the content and will use below sample JSON data to generate the Schema.<\/p>\n { \u2022 Before we add another step in the Flow, we will first understand the Relevance Search API Response.<\/p>\n Relevance search API response returns a \u2018value\u2019 object, which is an array of individual record along with search score, and fields where the matching word is found (highlights).<\/p>\n Below is the sample response, \u2022 We will now return the required response to the Canvas app. For that, we will first initialize the new Variable called \u201cResult\u201d,<\/p>\n \u2022 We will add \u2018Apply to each\u2019 step and will loop through the \u2018value\u2019 from Parse JSON step. This value is actually an array of the individual record.<\/p>\n \u2022 We will then add Switch step inside \u2018Apply to each\u2019. Here will check entity logical name of the individual record and based on the entity we will create the response.<\/p>\n We will use the following expression, trim(items(‘Apply_to_each_2’)?[‘@search.entityname’])<\/p>\n \u2022 As the Relevance Search API returns multiple entity records, we get different fields per record. For example, if the entity is contact then we get fullname field in the result, similarly, for Opportunity we get Name.<\/p>\n Therefore, to read the values that differ from entity to entity, we would need to add cases for each entity that we want to show the search result in the canvas app.<\/p>\n Here we have added a switch case for Contact, Lead and Opportunity.<\/p>\n \u2022 We will append the formatted response to the \u2018Result\u2019 variable. We will create the response in below format,<\/p>\n Entity1 Logical Name, Entity1 GUID, Entity1 Primary Entity Name Field| Entity2 Logical Name, Entity2 GUID, Entity2 Primary Entity Name Field<\/p>\n Each entity values will be separated by \u2018|\u2019 character and each entity value will contain the entity logical name, its unique identifier and its primary name field.<\/p>\n We will append the string generated by the below expression to the variable,<\/p>\n concat(trim(items(‘Apply_to_each_2’)?[‘@search.entityname’]),’,’,trim(items(‘Apply_to_each_2’)?[‘@search.objectid’]),’,’,trim(items(‘Apply_to_each_2’)?[‘fullname’]),’|’)<\/p>\n Here you would need to change the Primary name field based on the entity. If want, we can add any other additional field of that entity as well.<\/p>\n \u2022 Add final step \u2018Respond to a PowerApp or flow\u2019 as shown below in the screen shot. We will add the Text output and will assign the Result variable.<\/p>\n \u2022 If we run and test this flow we will finally get the response like below which we will read in the canvas app and will show the search results<\/p>\n { Here we have got two matching records (contact and lead) for the search text \u2018Rene\u2019.<\/p>\n Hence, we learned how to execute the Relevance Search API query in Power Automate. In Part-2 of this blog, we will see how to represent the response data in the Canvas App.<\/p>\n Introduction Relevance Search has been there for a while in our Dynamics 365 CRM that provides access to exciting new search capabilities in the environment. However, before you use this feature, an administrator must enable relevance search in target environment. Using relevance search we can search across multiple tables\/entities, sorted by relevance. Let us say\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1954,16,19,38,1985],"tags":[1867,545,592,1975,2120],"class_list":["post-26408","post","type-post","status-publish","format-standard","hentry","category-canvas-apps","category-dynamics-365","category-dynamics-crm","category-microsoft-powerapps","category-power-automate","tag-canvas-app","tag-dynamics-365-crm","tag-dynamics-crm","tag-power-automate","tag-relevance-search"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=26408"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26408\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=26408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=26408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=26408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Relevance](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/Relevance-search-feature.png\")
<\/a><\/p>\n
\n{
\n\u201csearch\u201d: \u201c<search term>\u201d
\n}<\/p>\n![\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/developer\/data-platform\/webapi\/relevance-search\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/instant-flow-cloud.png\")
<\/a><\/p>\n![\"power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/power-apps.png\")
<\/p>\n![\"powerapps\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/powerapps.png\")
<\/a><\/p>\n![\"initialize](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/initializing-variable.png\")
<\/a><\/p>\n![\"ask](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/ask-in-powerapps.png\")
<\/p>\n
\nAs a prerequisite, you must perform the below,
\n– First, we have to register an Application on the Azure Active Directory. For more information click here<\/a>.
\n– Then create an Application user on the Dynamics 365 CRM. For more information click here<\/a>.<\/p>\n
\nMethod:<\/strong> \u2013 POST
\nURI:<\/strong> \u2013 https:\/\/login.microsoftonline.com\/00000000-0000-0000-0000-000000000000\/oauth2\/token<\/a>
\n<This is the OAuth 2.0 Token Endpoint>
\nHeaders<\/strong>
\nAccept : application\/json
\nContent-Type : application\/x-www-form-urlencoded
\nBody<\/strong>
\ngrant_type=client_credentials
\nclient_id=<Application Id of registered application in Azure Active Directory>
\nclient_secret=<Secret key of registered application in Azure Active Directory>
\nresource= <crm url> e.g. https:\/\/contoso.crm.dynamics.com<\/p>\n![\"token](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/token-endpoint.png\")
<\/a><\/p>\n
\nURI:<\/strong> <organization URL>\/api\/search\/v1.0\/query
\nHeader:<\/strong> As shown in the below screenshot.
\nBody:<\/strong> {\u201csearch\u201d: SearchText} \/\/here \u2018SearchText\u2019 is the variable initialize above which holds the text pass from the Canvas App<\/p>\n![\"access](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/access-token.png\")
<\/a><\/p>\n![\"url\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/url.png\")
<\/a><\/p>\n![\"search](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/search-result-output.png\")
<\/a><\/p>\n
\n“value”: [
\n{
\n“@search.score”: 18.536037,
\n“@search.highlights”: {
\n}
\n},
\n{
\n“@search.score”: 10.059773,
\n“@search.highlights”: {
\n}
\n},
\n{
\n“@search.score”: 3.0122523,
\n“@search.highlights”: {
\n}
\n}
\n],
\n“facets”: {},
\n“totalrecordcount”: -1
\n}<\/p>\n![\"body\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/body.png\")
<\/a><\/p>\n![\"generated](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/generated-schema.png\")
<\/a><\/p>\n
\n{
\n“value”: [
\n{
\n“@search.score”: 9.740269,
\n“@search.highlights”: {
\n“firstname”: [
\n“{crmhit}Rene{\/crmhit}”
\n],
\n“fullname”: [
\n“{crmhit}Rene{\/crmhit} Sample”
\n]\n},
\n“@search.entityname”: “lead”,
\n“@search.objectid”: “79763014-cc8f-4afc-b33b-68a61710350c”,
\n“key”: “79763014-cc8f-4afc-b33b-68a61710350clead4”,
\n“ownerid”: “f39878a4-163d-eb11-bf68-000d3af05901”,
\n“owneridname”: “Sam C2C”,
\n“@search.ownerid.logicalname”: “systemuser”,
\n“owningbusinessunit”: “019278a4-163d-eb11-bf68-000d3af05901”,
\n“owningbusinessunitname”: “”,
\n“@search.owningbusinessunit.logicalname”: “businessunit”,
\n“sharedtoprincipalid”: [],
\n“@search.objecttypecode”: 4,
\n“fullname”: “Rene Sample”,
\n“versionnumber”: 2241955,
\n“statecode@StringCollection”: [
\n“Open”
\n],
\n“statecode”: 0,
\n“statuscode@StringCollection”: [
\n“New”
\n],
\n“statuscode”: 1,
\n“entityimage_url”: null,
\n“lastsyncdate”: “\/Date(1608822206278)\/”,
\n“createdon”: “12\/24\/2020 3:03 PM”,
\n“modifiedon”: “12\/24\/2020 3:03 PM”,
\n“documentbody”: null,
\n“body”: null,
\n“filebody”: null,
\n“emailaddress1”: null,
\n“companyname”: null,
\n“subject”: “Interested in Azure Subscription”,
\n“telephone1”: null
\n}
\n],
\n“facets”: {},
\n“totalrecordcount”: -1
\n}<\/p>\n![\"initialize](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/initialize-variable-1.png\")
<\/a><\/p>\n![\"value\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/value-1.png\")
<\/a><\/p>\n![\"\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/trim.png\")
<\/a><\/p>\n![\"switch](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/switch-case-1024x257.png\")
<\/p>\n![\"result\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/result.png\")
<\/a><\/p>\n
\n“text”: “lead,79763014-cc8f-4afc-b33b-68a61710350c,Rene Sample|contact,9e79b434-363d-eb11-bf68-002248d4bfa8,Rene Valdes (sample)|”
\n}<\/p>\nConclusion<\/h2>\n
![\"\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/01\/kanban-board.jpg\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"