cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
STA-Admin
Regular Visitor

Generate Newsletter from SharePoint list

Hello,

 

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.

4 REPLIES 4
STA-Admin
Regular Visitor

Bump. Hoping for some help!

jinivthakkar
Super User
Super User

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

STA-Admin
Regular Visitor

Thanks so much for the response. Picture below:

 

samplelist.png

 

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:

 

<table>

<Tr>

<td>

<img src="picture1">

</td>

<td>

<p>Title1</p>

<p>Entry1</p>

</td>

</tr>

<tr>

<td>

<img src="picture2">

</td>

<td>

<p>Title2</p>

<p>Entry2</p>

 

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...

jinivthakkar
Super User
Super User

@STA-Admin  This is what I understood and built

List 

jinivthakkar_0-1639067067009.png

Flow

jinivthakkar_1-1639067099955.png

Email I receive 

jinivthakkar_2-1639067147350.png

you only need a variable where you build html

jinivthakkar_3-1639067235744.png

and add the html in email body

jinivthakkar_4-1639067270103.png

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

Announcements
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)