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

1 ACCEPTED SOLUTION

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

 

 

 

View solution in original post

4 REPLIES 4
STA-Admin
Frequent 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
Frequent 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
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,329)