Find specific items in SharePoint List and send emails

(0) Share

Report

Posted on by CU-20080800-0

I'm currently trying to build a flow:

1. Get items from SharePoint List

2. Use condition to check each value in SharePoint List, whether the Condition_now is Inactive or Active

3. If the Condition_now is Inactive, do the following actions, if it's active, do nothing

Under Inactive condition

(1) Get those Inactive items (I tried to filter query already in get items)

(2) create HTML table for these inactive items individually

(3) Send the emails to me (their contact email addresses

But the question is that, I received 41 individual emails who satisfy Inactive condition because there are duplicated emails, but actually only 7 items satisfy the Inactive condition, so I should only receive 7 emails. Can someone check what's problem of this flow I've created?

All responses (4)

Answers (1)

CU-20080800-0 on at

Like (0)

Report

Re: Find specific items in SharePoint List and send emails

Oh, sorry. Perhaps I expressed incorrectly. I want to send emails to those items with Inactive condition, but your method really worked. Thank you so much!
v-yetonggu-msft on at

Like (0)

Report

Re: Find specific items in SharePoint List and send emails

Hi @Yue_Jiang ，

If I understand correctly, do you want to send these people's email addresses to yourself when Condition_now is active?

Best Regards,

Sunshine Gu
CU-20080800-0 on at

Like (0)

Report

Re: Find specific items in SharePoint List and send emails

Hi Sunshine Gu,
I wonder whether it's true that I send the emails if the condition is false, which means that there are inactive items
Verified answer

v-yetonggu-msft on at

Like (0)

Report
Re: Find specific items in SharePoint List and send emails

Hi @Yue_Jiang ,

There are not that many steps required, you just need to receive an html table email with their name and email address.

I did a test for your reference.

In my scenario:

My SharePoint List:

My Outlook Inbox:

My Flow:

Condition_now eq 'Inactive' length(outputs('Get_items')?['body/value']) item()?['Title']] item()?['Email']

Best Regards,

Sunshine Gu