Customer experience | Sales, Customer Insights,...

Auto tag a lead to an account

(0) Share

Report

Posted on by dynamicsgs

190

Hello,

We currently have leads coming across from HubSpot, and if the lead has the correct email domain for that company, it automatically brings in the account also.

We use the "parent account for lead" field to then link the lead to the relative account, so we can see the lead on the account level straight away. However, the only issue we have is when the account comes across from HubSpot, it doesn't auto link the lead to the account. This field remains blank.

Is there any way to automate this, by tagging the lead directly to the account, or is it not possible?

Thank you in advance.

I have the same question (0)

All responses (5)

Answers (0)

StefanS365 3,575 Most Valuable Professional on at

Like (0)

Report

Hi there,

How are the leads from HubSpot added to the Leads table in Dynamics 365 Sales?

The 'parent account for lead' field is a lookup to the Accounts table and needs an unique identifier (guid) to set/select a specific account; the Account Name is not necessarily unique.

It's possible to automate the Account selection/setting with Power Automate flow for example.

Was this reply helpful? Yes No
dynamicsgs 190 on at

Like (0)

Report

Hi Stefan,

The leads come across automatically through HubSpot operations (like an integration software that allows leads to flow across from one platform to another). When the lead flows across, it will automatically sync across the related account also and create this in Dynamics. So what we want, is to automatically link the lead to the account through the Parent account for lead field.

Does this make sense, or do you need more info?

Thank you in advance.

Was this reply helpful? Yes No
StefanS365 3,575 Most Valuable Professional on at

Like (0)

Report

So both (lead and account) are added to Dynamics but you're missing the link in the field Parent account for lead.

Yes, that makes sense.

Was this reply helpful? Yes No
dynamicsgs 190 on at

Like (0)

Report

Now I am looking to automate this. Is it possible to achieve?

Was this reply helpful? Yes No
Suggested answer

StefanS365 3,575 Most Valuable Professional on at

Like (0)

Report

Yes, with help of Power Automate flow: I use the same trick: match the e-mail domain of the lead with accounts

Here's an example. I've added an unmanaged solution with this flow to download and import in your environment.:

Used expressions:

substring(triggerOutputs()?['body/emailaddress1'],indexOf(triggerOutputs()?['body/emailaddress1'],'@'),sub(length(triggerOutputs()?['body/emailaddress1']),indexOf(triggerOutputs()?['body/emailaddress1'],'@')))

first(outputs('List_rows_-__Accounts')?['body/value'])?['accountid']

[View:/cfs-file/__key/communityserver-discussions-components-files/762/PowerAutomatecloudflowtosetparentaccountforlead_5F00_9_5F00_0_5F00_0_5F00_211012.zip]

Was this reply helpful? Yes No