Unanswered

Dynamic HTML table filter query

(0) Share

Report

Posted on by Vikram_Vh

Hi all

I am trying to send a mail to select recipients only the data pertaining to them in the excel table. Tried to use these steps

1.Manual trigger flow

2.List rows present in a table

3.filter array to only list those records where there is a performance gap and needs to be mailed.

4.create html table

5.initialize variable for email field

6.apply to each - append email to string variable from array

7.send an email to the email variable.

But the problem is things are working till point 4. the mail is triggering all the filtered records as one html table to all the mail id's together. How do i send the specific html table/record to only those mail id who are added to the resp. rows.

the flow is like this.

please suggest on what's missing /where I am going wrong. Thank you in advance

regards

vikram

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Vikram_Vh 38 on at

Like (0)

Report
Copy link

Link copied!

@DamoBird365 I saw your video before building this flow. But somehow this is not working. can you pls help.

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Vikram_Vh

If the emails are in the filter array? Perform a select on the filter by using the text mode for the map and providing the email dynamic content. This will give you an array of emails and if they are dupicated you can use compose with a union on the same array union(select array,select array) and then join the result with a semi colon ready for Send Email.

Hope that makes sense and I have understood.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
Vikram_Vh 38 on at

Like (0)

Report
Copy link

Link copied!

Hi @DamoBird365 Appreciate your immediate revert. if its possible, can you show your suggestions as some screenshots of which actions to picked (will be a great help). e.g. are you i have added one filter array already to filter out only applicable records. are you suggesting i add one more filter array as below. But then how do i use the dynamic email id on both ends of the filter?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Vikram_Vh

no more filters....

A select (on email field)
A compose - union(select, select)
A compose - join(on above select with 😉

the union is only required if the emails are duplicated but I’m assuming they will be.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
Vikram_Vh 38 on at

Like (0)

Report
Copy link

Link copied!

Hi @DamoBird365

Tried to add the actions as suggested..I guess I am doing something wrong. Attaching my complete flow for your perusal

To summarize, out of the rows appended, only rows for dealer a and b should go to sales rep 1, and dealer d and f to sales rep 3. not all rows to all mail id;s.

Dealer Target Actual Sales Rep Email
a 10 5 1 1@gmail.com
b 10 6 1 1@gmail.com
c 10 10 2 2@gmail.com
d 10 4 3 3@gmail.dom
e 10 6 2 2@gmail.eom
f 10 8 3 3@gmail.fom

thanks for your patience...

Was this reply helpful? Yes No