Send emails to particular contacts on a Sharepoint list

(0) Share

Report

Posted on by MB35

Please can I get some help in building the following:

I have a sharepoint list with Person/Group formatted column with colleagues email addresses.

And I have an Excel file with a list of colleagues email addresses who should not receive an email

I need to build the rule of 'if email address on sharepoint is on excel, do not send an email'

Any tips? Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,855 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @MB35,

You can use a Filter Query field in the List rows present in table action. In that field you can check if any rows are found which match the value in your person or group type of field.

Below is an example

1. The Excel file with the table1

2. The flow which checks if the email value of my SharePoint list item (field name is Colleague) is found in that table.

3. Filter Query used in the List rows present in a table action

Email eq '@{triggerOutputs()?['body/Colleague/Email']}'

4. Expression in the Condition action to check if no matches are found

length(outputs('List_rows_present_in_a_table')?['body/value'])

is equal to 0

Was this reply helpful? Yes No
MB35 91 on at

Like (0)

Report
Copy link

Link copied!

Thankyou for your reply, I'm trying this but not quite getting the filter query right.
However, what I should have been clearer on, is, where the email address is in the excel, I still want to send an email but rather to a shared mailbox than direct to the person.
I envisaged if the email add on Sharepoint is listed in the excel, send email to shared, if not listed in the excel it can send to the colleague.
I'm going round in circles, so any support is really appreciated, thankyou

Was this reply helpful? Yes No
Expiscornovus 33,855 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @MB35,

Thank for clarifying.

Can you share a screenshot of your Excel table format? (obfuscate/hide data like email addresses in the screenshot if needed). This way I can change my example.

Was this reply helpful? Yes No
MB35 91 on at

Like (0)

Report
Copy link

Link copied!

My excel table is just a single column table of email adds with 'Email' as the header, example below

Was this reply helpful? Yes No