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)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
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

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,189 Most Valuable Professional on at

Like (0)

Report

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

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