Update source campaign for leads with most recent emails they received.

(0) Share

Report

Posted on by Hari Narayan Singh

230

Hi Community,

Is there a way to append the source campaign column for leads with campaign name of most recent emails they have received.
I want all the leads from marketing campaigns to have a source campaign.

So here's what we want to identify & Implement

1. Leads with source campaign columns as empty.
2. Look for the most recent email there parent contact has received
3. Append the campaign name columns of that email to source campaign of the respective leads.

appreciate your help...

Regards,
Hari

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Hari Narayan Singh,

This could be achieved by Power Automate flow. Here are the steps you need to do:

1. List all leads whose source campaign is empty.

2.Loop these leads and list email messages which is regarding to the contact of lead(order by 'Modified On' Desc and limit one row).

3. Create a row of Campaign table with the email's subject in step2.

4.Update the Lead and fill in the source campaign column with the Campaign in step3.

Was this reply helpful? Yes No