cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MattsChr
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
v-yuazh-msft
Community Support
Community Support

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
DLGross
Kudo Commander
Kudo Commander

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
MattsChr
Frequent Visitor

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

v-yuazh-msft
Community Support
Community Support

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

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

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

Hi @v-yuazh-msft

 

I have created a string columm in the list 

 

I keep getting this error

 

error.PNG

 

/Matts

Hi @ MattsChr,

 

 

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

 Capture.PNG

 

 

Regards,
Alice Zhang

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

Well done, @v-yuazh-msft !

Well done, Sir!

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

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,146)