How to list extracted items from SharePoint lists in one email?

(0) Share

Report

Posted on by kazh

Hello!

We are trying to create a recurring flow that sends reminder emails based on the dates on SharePoint list items.

Currently we can successfully extracted the items from SharePoint lists with the below Filter Array. Our conditions are as below.

@And(equals(empty(item()?['WrapupFlag']), true),not(equals(item()?['Status']?['Value'], 'Closed')),not(equals(item()?['Status']?['Value'], 'Confirming by Requester')))

However, even though the target items are successfully listed on the email, the same email are sent multiple times.

So my question is, is there a way to list the items filtered by filter array in one email and send only one email?

Thank you very much in advance.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

v-peijunz-msft Microsoft Employee on at

Like (1)

Report

Hi @kazh

Receiving multiple emails is because the "Send an email" action is in the "Apply to each" action, so all the items that meet the condition would send an email.
To send only one email, I have made a simple test for your reference.
1. Here is the flow, to use the "Create HTML table" to store the items that are filtered from the filter array:

2. Result:
Best regards,
Sylvia

Was this reply helpful? Yes No
kazh 29 on at

Like (0)

Report

Thank you for your answer!

I now clearly understand why I get multiple emails.

However, the problem remains.

We need to send emails to PIC, which is a dynamic content and even if we try to express PIC email with the below code, the flow fails at sending email.

Is there a way to fill dynamic content to "To" email address without adding apply to each?

Thank you!

Was this reply helpful? Yes No
v-peijunz-msft Microsoft Employee on at

Like (0)

Report

Hi @kazh

Is the PIC a column from your SharePoint list?
Is that a person column or single line of text column to store the email?
If you don't mind, could you please show the screenshot?

Thank you.

Best regards,
Sylvia

Was this reply helpful? Yes No
kazh 29 on at

Like (0)

Report

Thanks for your quick reply!

It is a person column!

Was this reply helpful? Yes No
Verified answer

v-peijunz-msft Microsoft Employee on at

Like (0)

Report

Hi @kazh

Please try the following ways:

Best regards,
Sylvia

Was this reply helpful? Yes No
kazh 29 on at

Like (0)

Report

Thank you very much!

It works perfectly now!

Was this reply helpful? Yes No