Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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
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.
Could you guide me on where I'm doing wrong? and guide me in the right direction, please.
To achieve it, we have to use power automate(flow).
In the flow, there is a step "List records" that search all records of the entity and return the search result.
Go to https://us.flow.microsoft.com/, select the D365 environment, click Solutions, edit a custom solution, new a flow.
First set the trigger, search for "When a record is created" and add it. Select "Entity Name" to Leads.
Then add a step, search for "list records" and select it.
Select "Entity Name" to Leads. In the "Filter Query", enter Enquire description field's name eq 'Enquire description field's dyanmic value'.
Then add a condition, set the first value to length(outputs('List_records')?['body/value']), and then select is not equal to, the second value is 0.
is not equal to
In the “If yes”, add step "send an email (V2)".
Finished. This is an overview of flow.
Thank you very much Sir, I will give it a go and let you know. Much appriciated your help on this brother..
Thank you for looking into my issue. Much appreciated brother, however, I'm getting an error in the list record step.
Any Idea what causing it. I have replicated the exact same steps you have mentioned.
Can you please check the field name in List Records Filter Query?
You need to use Membership ID Field (use its physical name here), if still doesn't work please share the update screen shot of List Query Action.To point you in the direction, Bad Request means web service (retrieve) fails due to faulty filter or configuration of List records action.
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.
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.
First please don't use D365 connector in the power automate, but use Common Data Service connector, because D365 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.
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.
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.
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..
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.
Pleasure is all mine.
Keep connected and feel free to discuss if you face any issue ever.
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.
Never hesitate to ask, at your service! :)
Business Applications communities