Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Generate Newsletter from SharePoint list



I am using Microsoft Forms to populate a sharepoint list. That part I have had no problem with. Users fill out the form with their newsletter entry and a link to a picture to include. The sharepoint list has two columns (Entry & Picture).


Now I want to create a flow that takes the items in the list and populates an email template. I'm using get items to get all the items added within a date range (that way I can use the same list and just update the odata filter each week). I feel like I'm completely missing something, but how do I use the individual items from the list?


What I'm doing is taking the HTML from the newsletter I created in outlook, and I just want to add the content from the sharepoint list to the relevant parts of the HTML in the send an email action. I don't want all the text from every list item in the same place as that's not how I want the newsletter to appear (each newsletter entry is in a different table row). I hope I'm making sense. I've spent the day googling and I haven't made much progress. 


Any help would be much appreciated.

Regular Visitor

Bump. Hoping for some help!

Super User
Super User

@STA-Admin what does entry column hold ? please share image of list with sample data.

Regular Visitor

Thanks so much for the response. Picture below:




These are obviously just sample entries. The idea is to take the content and insert it in the relevant part of the HTML template.


Basically like this:





<img src="picture1">









<img src="picture2">






Does that make sense?


Title 1 = Staff Training Day

Title 2 = Politician Visits School


Entry 1 = This is a test entry...

Entry 2 = This is a second test entry...

Super User
Super User

@STA-Admin  This is what I understood and built





Email I receive 


you only need a variable where you build html


and add the html in email body


Hope this helps.


If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,214)