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.
