Generate Newsletter from SharePoint list

Like (0) Share

Report

Posted on 8 Dec 2021 14:35:41 by STA-Admin

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.

All responses (4)

Answers (1)

Verified answer

jinivthakkar 4,179 on 09 Dec 2021 at 16:29:03

Like (0)

Report

Re: Generate Newsletter from SharePoint list

@STA-Admin This is what I understood and built

List

Flow

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.
STA-Admin 25 on 09 Dec 2021 at 15:06:55

Like (0)

Report

Re: Generate Newsletter from SharePoint list

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:

<table>
<Tr>
<td>
<img src="picture1">
</td>
<td>
Title1
Entry1
</td>
</tr>
<tr>
<td>
<img src="picture2">
</td>
<td>
Title2
Entry2

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 4,179 on 09 Dec 2021 at 14:53:43

Like (0)

Report

Re: Generate Newsletter from SharePoint list

@STA-Admin what does entry column hold ? please share image of list with sample data.
STA-Admin 25 on 09 Dec 2021 at 11:50:21

Like (0)

Report

Re: Generate Newsletter from SharePoint list

Bump. Hoping for some help!