Answered

How To Filter Excel Rows Using Unique Column Names & Send Email and add dynamic content

(1) Share

Report

Posted on by Tim19943

Hi @abm , i watched gratefully your video on youtube. https://www.youtube.com/watch?v=vwMo79HFvtg&t=1s

i saw some comments which were requesting the same as mine, but couldn't find the answer. how can i manage to add dynamic content in my email within the apply to each loop.

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Tim19943

What you trying to map here? Could you please post a sample data?

Thanks

Was this reply helpful? Yes No
Tim19943 56 on at

Like (0)

Report
Copy link

Link copied!

i would like to have three kind of data from my excel file, corresponding on same row as where the filter is applicable on.
for example Account, Name and Email address. but if use the dynamic content it creates a new apply to each loop. and using an items expression doesn't wor k because it can't retrieve the data in the current loop.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Tim19943

I still don't understand it. I can see you are mapping the Excel values from the loop. Could you please explain?

Thanks

Was this reply helpful? Yes No
Tim19943 56 on at

Like (1)

Report
Copy link

Link copied!

Hi @abm

but when i select them it has created a new apply to each loop. and because of that the complete flow is not working anymore on the unique emails. in that case I'm sending data twice to the same email address because of the source.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Tim19943

This is my understanding. You have an Excel sheet and it contains multiple emails (Duplicated). You want to find the unique emails. Iterate each unique email and get the related Excel rows info into an email. Is this correct?

Thanks

Was this reply helpful? Yes No
Tim19943 56 on at

Like (1)

Report
Copy link

Link copied!

Hi abm, yes that is correct! and if possible i would like to have a table with the data per unique email in it as well

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Tim19943

Looks like your flow is similar like my video tutorial. In my video I set the output as HTML file. What other information you need to map under the Email?

Thanks

Was this reply helpful? Yes No
Tim19943 56 on at

Like (1)

Report
Copy link

Link copied!

Hi @abm, actually the three dynamic content from the earlier screenshot. so Account Name, CDM Name and Email address

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Tim19943

You need to include that in Create HTML table? You can't map Excel dynamic values to your current logic. Like you mentioned it will add the loop. Are there any issues for adding those under the create HTML table?

Thanks

Was this reply helpful? Yes No
Tim19943 56 on at

Like (1)

Report
Copy link

Link copied!

Hi @abm, no these kind of data need to be added in the email text. so i cannot use it in the HTML table.

it is like we end the email with a variable like CDM Name and Email address.

Was this reply helpful? Yes No