Send mail to adresses in a SharePoint list

Like (0) Share

Report

Posted on 20 Mar 2023 15:38:43 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

All responses (14)

Answers (1)

Ariini 76 on 23 Mar 2023 at 11:07:37

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

Hi @v-dezhili-msft 🙂
It creates another aplly to each but this time for select
But I tried it and it sends out the mails with the correct text - thank you so much!

The only thing Im missing is that it sends the mail to a user multiple times if he/she is listed for more than one project.
v-dezhili-msft Microsoft Employee on 23 Mar 2023 at 08:01:33

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

Hi @Ariini ,

Please try:

Best Regards,
Dezhi
Ariini 76 on 23 Mar 2023 at 07:55:03

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

Hello @v-dezhili-msft 🙂
I didnt use apply to each twice but it automatically added it in when I use the second getItem in my mail.
The value 'Aktuelles_GJ' is from another SharePoint list and every time I use this Power Automate automatically adds the other apply to each
v-dezhili-msft Microsoft Employee on 23 Mar 2023 at 07:45:57

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

Hi @Ariini ,

Could you please show your formula for send email action?
Actually you don't need to use apply to each2.

Best Regards,
Dezhi
Ariini 76 on 22 Mar 2023 at 13:46:01

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

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
Verified answer

v-dezhili-msft Microsoft Employee on 21 Mar 2023 at 09:40:47

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

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 21 Mar 2023 at 08:37:37

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

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.
v-dezhili-msft Microsoft Employee on 21 Mar 2023 at 08:32:33

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

Hi @Ariini ,

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

Best Regards,
Dezhi
Ariini 76 on 21 Mar 2023 at 08:02:13

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

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 21 Mar 2023 at 07:56:18

Like (0)

Report

Re: Send mail to adresses in a SharePoint list

Hi @Ariini ,

May I know what your data source looks like.

Best Regards,
Dezhi