How to Write an Expression to Get items from filter

[vsvsardo]

Hi there, 

I'm using data from a Sharepoint List and have created a specific filter to be used for the HTML Table.

All the values in the HTML table are filtered and show up correctly on the email. The issue is the formulas that I'm using to send this email to the person identified in the Sharepoint List. By using the formula outputs('Get_items')?['body/value'][0]['EmailRecipient']?['Email'] it only sends the filtered table to one person regardless of the remaining date on the sharepoint list column Email Recipient. Please bear in mind that I can't use "Apply to each" action, as this will send repetitive emails. 

Therefore, how can I write an expression to get items from the previous filter (step: Filter using each product)?

HTML table - deleted the items on the image for data protection reasons

[abowen]

Could you not use an 'Apply to each' to iterate through the array of emails? Each 'Send email' action would contain a different email address using the 'Current Item' content as the To field, no?

[vsvsardo]

Hi @abowen 

I've tried the Apply to each action to send the email, but it won't send one unique email to each user identified in the column Email Recipient in the Sharepoint List, so it sends unecessary duplicate emails to the same user.

Maybe there is a way to work around this issue?

[abowen]

What must be unique about the email? Just names/email addresses? If so, you can make the emails unique by inserting the "Current Item" dynamic content to the Apply to each, which represents each successive item in the iteration. 

I might be misunderstanding you... Your "Body" dynamic content (input for the Apply to each) contains the email addresses you need to use, yeah? Just want to be sure. 

[vsvsardo]

Apologies if I wasn't clear on the query above. 

So, one person should receive one email with the table filtered by Product Type and deadline.

For example, If you're the owner of specific tasks for Products A, B and C, you should receive 3 separate emails because the table (HTML) in each email should only have the relavant information for Product A (email 1), Product B (email 2) and Product C (email 3). 

Somehow, when I use "Apply to each" action and then "Send an email (V2)", some users receive the same emails duplicates and others, don't and I want to avoid that.

 

[vsvsardo]

One thing to add: by using "Apply to each" action, if the HTML table has 2 lines, it sends the same email twice, 3 lines, 3 same emails and so on...

[abowen]

I may be out of my depth here. I haven't worked with HTML tables yet, but my current intuition is that you should try to find the "Current Item" dynamic content and then scan through that for whatever content you need to be in the email (body or to-address) based on what row of the table you're currently at. It might help if you shared what your "Body" input for the Apply to each looks like raw. 

[vsvsardo]

The issue isn't the HTML table, as the information there is filtered correctly in every email.

The issue comes when I want to add other fields/expressions using the data from the Sharepoint List.

By using the Apply to each 2, the email content is correct, it just sends duplicate emails to all the users.

Is there a way to fix that?

[abowen]

I didn't mean to imply the HTML table was incorrectly formatted. I mean that when you open the Dynamic content dialog in Automate inside the Apply to each, you should be able to find a Current item option, that looks like the following screenshot. That should allow you to write expressions to find the data you're looking for and send emails to the correct people with the correct content. 

Unless you suspect that your Apply to each is running too many times for some reason, then I would attempt to solve this issue using the Current item tool.