Lead lookup in CRM 365

(0) Share

Report

Posted on by Biswad

Hi Friends ,

I'm working on a project where we have an online form which is filled up by our subscribers to get a communication preference settings. On that form we have 4 fields as below

1) Last name

2) Forename

3) Email ID

4) membership ID

Once the form is submitted it gets created as a lead on our CRM 365.

I would like to run a process that will trigger an email to the lead on their submitted email ID. That is the working fine, however, I would like to set an extra step to check if the submitted membership ID exists in our CRM database before sending them an email. If exists then send email, Below are the steps I have created however the process doesn't carry out a lookup in our database. Here Enquire description field is a field in the lead form where the membership ID is stored and the Customer(member/contact) is the field where we have the membership ID of our customers.

8053.CMR-365_5F00_Lead_5F00_step.jpg

Could you guide me on where I'm doing wrong? and guide me in the right direction, please.

All responses (14)

Answers (1)

Wahaj Rashid 11,319 on at

Like (0)

Report

RE: Lead lookup in CRM 365

Never hesitate to ask, at your service! :)
Biswad 20 on at

Like (1)

Report

RE: Lead lookup in CRM 365

Much appreciated Sir, I will discuss any issue I'm unable to solve . List record step is very new to me and learnt a lot from this post. Thank you :) I'm very new to CRM and still scratching the surface. I hope you will not get annoyed with my simple issues which might look big to me :) Stay blessed Sir.
Wahaj Rashid 11,319 on at

Like (0)

Report

RE: Lead lookup in CRM 365

Hi Biswad,

Pleasure is all mine.

Keep connected and feel free to discuss if you face any issue ever.

Thanks,

Wahaj
Biswad 20 on at

Like (1)

Report

RE: Lead lookup in CRM 365

Thank you sir for trying to help me out. I have now taken this issue with our crm service provider and they mentioned they already have a built in plugin which will do the process I'm trying to achieve , Unfortunately we don't have a common data model connector either , this need to be setup by our crm provider.
Biswad 20 on at

Like (0)

Report

RE: Lead lookup in CRM 365

Hi Hao ,

Thank you for taking your time to look into this. For some reason I'm unable to common data model connector, later I figured out that the our CRM is with the CRM service provider. I have taken this issue with them and they said the have a inbuilt plugin which will server the work flow I'm trying to achieve. Also the form in the front end need to be redesign. I truly appreciate your answer and I will get back to this forum when I will have issue.

Stay blessed brother..
LuHao 40,872 on at

Like (1)

Report

RE: Lead lookup in CRM 365

Hi Biswad,

1. First, we need to confirm that the value of the "Enquire description" field is the membership ID.

2. "List Records" is the equivalent of record Query, which queries an entity for all records that satisfy the Filter according to the condition "Filter Query".

Please refer to carldesouza.com/.../

So once it searches for a record that has the same "Enquire description" field value as the new created Lead, it adds the record to an array as an element. When all the Lead records are searched, an array containing all Leads records which repeat "Enquire description" field values will be returned.

Therefore, we only need to determine whether the number of elements in the returned array is not 0. If it is not 0, it means that the Lead which haa the same "Enquire description" field value is found. If it is 0, then the "Enquire description" field of the new created Lead record is unique.

You can test the flow after you create it.
Biswad 20 on at

Like (0)

Report

RE: Lead lookup in CRM 365

Hi brother,

Here are the screenshots. I have a question as when we use the dynamic "Enquire description" field does it lookup to the membership ID we have in the database? if so how will it identify on which field its going to check.

Thank you for your effort in solving this problem .. Much appreciated.
LuHao 40,872 on at

Like (0)

Report

RE: Lead lookup in CRM 365

Hi Biswad,

First please don't use D365 connector in the power automate, but use Common Data Service connector, because D365 connector is deprecated.

https://docs.microsoft.com/en-us/power-platform/important-changes-coming#dynamics-365-connector-is-deprecated

Could you provide a screenshot of the Enquire description field properties? like this.

We will use its name (not display name) in the Filter Query, so the Filter Query should be Enquire description field's name eq 'Enquire description field's dyanmic value'.

new_enquiredescription is the name of the field in my environment, just for demonstration. Please use the name of the field in your environment.
Wahaj Rashid 11,319 on at

Like (0)

Report

RE: Lead lookup in CRM 365

Hi Biswad,

Seems like your Filter Query is wrong.

It should be like <physical field name> eq '<mebersip id value>'.

See following screenshot of yours:

If you are not sure about field name, open form, open Membership ID field properties and on the Details tab look for Name field.
Biswad 20 on at

Like (0)

Report

RE: Lead lookup in CRM 365

Thank you for looking into it brother.. I'm still getting the same error after I entered the membership ID field manually .. Here is the screenshot. Any suggestions would be greatly appreciated.