Hope someone can please advise or assist me. I have not seen a solution for this anywhere yet.
In a nutshell, I am looking to create a Newsletter using Power Automate to do it. A link to a Microsoft Form is sent to the relevant parties who would complete files such as Title, Content, Date and the option to upload any files, photos, illustrations etc. This is my trigger and the next step would be the populating of a Microsoft List I have already created for this purpose. Ultimately, I would be populating to a Microsoft Word Template (I would have the appropriate Developer controls in place in the template and do have Word Business which is required for this exercise), I am just looking for someone (who has perhaps managed to do a Newsletter this way) to advise me of the steps in the process from initial trigger to the final template population.
Something I should point out is that contributions would be submitted via the Form periodically so how do I ensure that each contribution (article) has its own page in the template (after all, the Newsletter will be several pages as there are several parties who would be invited to contribute articles)?
From conversations I have had, some have suggested I use "Parse Json" in my flow, others not, some say to incorporate an array. I am very unsure of all the steps in between which I would need so would be grateful if anyone had experience of doing this. I really need to hear from someone who really knows what they are talking about because, up until now, guidance I have received is sketchy and all very trial and error. No one yet seems to have achieved this with Power Automate, unless I have been looking in the wrong areas. I hope I have come to the right place now.
Thanks in advance, guys!
