cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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

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

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (9,517)