Answered

Send mail to adresses in a SharePoint list

(0) Share

Report

Posted on by Ariini

Hello everyone 🙂

Im trying to make a flow that reads a column in my SharePoint list and extracts the mails from this column (there are either mailadresses or empty fields).

I tried to use 'Select' but I always get the error that my column doesnt exist - I double checked the name in my SharePoint settings and its correct.

I also tried to create an array and append it to a string and I made the condition that the item should not be empty but then I get the error that I cant sent to 'Null'.

(I cant even try to filter so that I dont get mail adresses more than once)

Has someone another solution or can help me to fix my attempts?

Thanks 🙂

Ariini

Categories:

Using flows

All responses (14)

Answers (1)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Ariini

Are you trying to loop through items in the list and send an email or are you sending a single email?

What is the type of column where you are storing the email addresses? A text column? A person or group column?
Ariini 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Im trying to loop through them.
The mail should be sent once a year (its a reminder) and I need to get every mail adress that is added and if possible make them distinct so they are not getting 50 mails each (Some of the adresses are added to multiple entries)
The column is a (Single Line of) Text.
v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ariini ,

You mean you have empty fields in your email column but you want to send an email to every email address?
Could you please show the flow you already have?
Please try:

Best Regards,
Dezhi
Ariini 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello and thank you for your help 🙂
I tried using your suggestion but it says that my expression is invalid.
My email fields are named 1st Counterpart Email, 2nd Counterpart Email and 3rd Counterpart Email - is there a problem because of the spaces? I tried putting the names in '' as well but it doesnt work.

I tried it like this at first but I always get an empty array
Sorry I just started using Power Automate so its a mix of tutorials and my data.

Kind regards
Ariini
v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ariini ,

May I know what your data source looks like.

Best Regards,
Dezhi
Ariini 76 on at

Like
a
(0)

Report
Copy link

Link copied!

It seems like I messed up at the start and the columns names are field_10, field_12 and _x0033_rdCounterpartEmail
All of them are single lines of text
v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ariini ,

Do you need all emails in the 1st 2nd 3rd column?

Best Regards,
Dezhi
Ariini 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-dezhili-msft
Yes if possible I have to send everyone a mail but not twice if they are listed in multiple entries/columns.
Verified answer

v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ariini ,

Sorry I don't quite understand your needs.
Can you give me some examples?
I did a test as per my understanding.
In my scenario I want to send emails to the email addresses in the email email2 and email3 columns in each row, but I only need it once when an email address exists in both email email2 or email3 columns.

Best Regards,
Dezhi
Ariini 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-dezhili-msft 🙂
Well kind of - each row has the columns 1st,2nd and 3rd Counterpart.
Each row is one project and it could happen that the 1st Counterpart of project nr 1 is as well a counterpart in project nr 200.

I tried using your solution and it seems to work if the first entry has a mail address but it fails if there is none.
So it seems like I got the part wrong where it skips the empty entries
I get an error on the last part where the mail is sent