How to auto assign records in Dynamics CRM?
-
First thing is to start with a action when a record in Dynamics CRM is created. This can be Case, Lead, Opportunity or anything else that you want to automate the assignment process. I will use Lead in my example.
-
Then we need to get the the team and its members that we are going to assgined the new leads to. Now, this is a bit difficult as you actually don't need the team table, as this will return the team (Sales for example) but not its members, and actually need the members of Sales team, but how and where we are going to take this information from?
-
So we will manually add teammemberships in tablename, and we will filter by teamid. In this way we are getting only members from certain team (Sales in this case).
-
Next step is to Initialize variable which will actually get the total number of users in the above filtered team from teammemberships table. We will use the following formula: lenght(body('Get_team_members')?[‘value’])
-
Then we will initialize another variable, but this time we are asking to randomly pick a number from the previous step. We will use the following formula: rand(1,variables('numberOfMembers'))
-
After that we will combine the two variables along with the userid, so that way we will know what user stays behing each number. We will use the following formula: body('Get_team_members')?[‘value’]?[variables(‘randomNumber’)]?[‘systemuserid’]
-
One we have the entire formula ready, we need to come back to the intially crated new Lead and update the Owner filed with the Compose steps's output.
Continue Reading Radoslavov’s Article on their blog
How to auto assign records in Dynamics CRM?
In companies with different departments there always has a need records to be redirect (or to use the technical term assign ) to a certain people based on some criteria. Whether this is a support team where a new case is assigned to sub-team (such as: Technical Support, Customer Support, Sales Support, etc.), or perhaps a Sales team based on lead creation so they can handle the potential clients.
Blog Syndicated with Radoslavov’s Permission
More About This Author
- Hi all, I'm from Sofia, Bulgaria. I've been working with Office 365 and Dynamics 365 for more than 5 years. Started as a Technical Support Engineer and slowly but surely found my way as a Dynamics CRM Consultant. Recently I've started my own company in Bulgaria called Simetrix Consult, for providing training for Office 365 and Dynamics CRM. Always willing to learn new tips and tricks about Office 365 and Dynamics CRM.
Array
- Dyn365CE5 August 2021How to auto assign records in Dynamics CRM?
- Dyn365CE5 August 2021Identify fake/abusive records in CRM
- Dyn365CE24 February 2021Postman – Dynamics 365 connection
- Dyn365CE19 February 2021Custom Connector in Power Automate