cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

sending emails to a SharePoint contacts list

Hi guys i have a probelm with building a Flow

 

I would like to setup a flow that send a email to a contact list, the same date every month. 

 

I hope any of you guys can give me some advice. 

 

1) Get email adresse from Sharepoint list

2) Generate static email

 

\ Matts 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: sending emails to a SharePoint contacts list

Hi @ MattsChr,

 

 

I have made a test on my side, and have created a sharepoint list with a single line of text column "email" as below:

Capture.PNG

 

You could refer to screenshot below to create the flow:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

Please let me know if your problem could be solved.

 

 

Regards,
Alice Zhang

View solution in original post

11 REPLIES 11
Highlighted
Kudo Collector
Kudo Collector

Re: sending emails to a SharePoint contacts list

Sending an email TO a SharePoint list typically requires some extra configuration steps in SharePoint. Which version of SharePoint are you using?

 

Or did you mean that you want to send a email to everyone that is listed in the contact list?

Dean Gross

Office 365- MSCA
SharePoint - MCSE
Microsoft 365 Enterprise Administrator Expert
Highlighted
Frequent Visitor

Re: sending emails to a SharePoint contacts list

Hi @DLGross

 

I would like to send a email to all of the people who are listed on the list. i am using the latest version of SP in Office365

 

/M

Highlighted
Community Support
Community Support

Re: sending emails to a SharePoint contacts list

Hi @ MattsChr,

 

 

I have made a test on my side, and have created a sharepoint list with a single line of text column "email" as below:

Capture.PNG

 

You could refer to screenshot below to create the flow:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

Please let me know if your problem could be solved.

 

 

Regards,
Alice Zhang

View solution in original post

Highlighted
Frequent Visitor

Re: sending emails to a SharePoint contacts list

Hi @v-yuazh-msft

Thank you so much for the input. (y)

 

I have tried to copy your flow. But I run into an error. as you can see i can't choose the dynamic email value under "Append to string variable" any clues why this happens? 

 

1.PNG

 

again thank you for the help

 

/Matts

Highlighted
Community Support
Community Support

Re: sending emails to a SharePoint contacts list

Hi @ MattsChr,

 

 

 

Please  check if you have created a email column in your "VIP" list.

 

Please condider add a expression as below:

items('Apply_to_each')?['email']
 
Capture.PNG

 

 

Regards,
Alice Zhang

Highlighted
Frequent Visitor

Re: sending emails to a SharePoint contacts list

Hi @v-yuazh-msft

 

I have created a string columm in the list 

 

I keep getting this error

 

error.PNG

 

/Matts

Highlighted
Community Support
Community Support

Re: sending emails to a SharePoint contacts list

Hi @ MattsChr,

 

 

Please create a email column with a "Single line of text" type in your "VIP" list.

 Capture.PNG

 

 

Regards,
Alice Zhang

Highlighted
Frequent Visitor

Re: sending emails to a SharePoint contacts list

Hi @v-yuazh-msft

 

I have found the problem... 

in the action "get items" i have refered to the URL of the list and not the site itself.. 

 

Once again thank you for your help! - I appreciate it

 

/Matts

Highlighted
Advocate I
Advocate I

Re: sending emails to a SharePoint contacts list

Well done, @v-yuazh-msft !

Well done, Sir!

Highlighted
Regular Visitor

Re: sending emails to a SharePoint contacts list

Hiii, 

 

I'm trying this out but my flow fails at send the email.

 

He unifies both email address and doesn't separate them with ";" therefore it fails. He says that one or more email address are invalid.

 

Please help

Highlighted
Helper IV
Helper IV

Re: sending emails to a SharePoint contacts list

I need to send email to share point list.This list contains one item.This item have multiple contact names.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (6,825)