cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MattsChr
Level: Powered On

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 Team
Community Support Team

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

10 REPLIES 10
DLGross
Level 8

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
MattsChr
Level: Powered On

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

Community Support Team
Community Support Team

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

MattsChr
Level: Powered On

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

Community Support Team
Community Support Team

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

MattsChr
Level: Powered On

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

Community Support Team
Community Support Team

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

MattsChr
Level: Powered On

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

peter_not
Level: Powered On

Re: sending emails to a SharePoint contacts list

Well done, @v-yuazh-msft !

Well done, Sir!

Highlighted
mcalderon
Level: Powered On

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 166 members 5,915 guests
Please welcome our newest community members: