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:

Business Process Flows

All responses (4)

Answers (0)

MB35 91 on at

Like (0)

Report

Re: Send emails to particular contacts on a Sharepoint list

My excel table is just a single column table of email adds with 'Email' as the header, example below
Expiscornovus 31,779 Most Valuable Professional on at

Like (0)

Report

Re: Send emails to particular contacts on a Sharepoint list

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.
MB35 91 on at

Like (0)

Report

Re: Send emails to particular contacts on a Sharepoint list

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
Expiscornovus 31,779 Most Valuable Professional on at

Like (0)

Report
Re: Send emails to particular contacts on a Sharepoint list

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