Generate a Word Document from a SharePoint list using Power Automate
Vložit
- čas přidán 13. 09. 2024
- This recording is part 1 of 2.
Sending a lot of mail-merge? Not wanting to do it from your computer only?
Power Automate has the right action to generate a Word document in the backend.
In this video, I will show you how to start from a SharePoint list, create a document template, and move the data from that list to a new document using Power Automate.
Part 2: Demonstrating the full flow running, and the document being generated with over 255 characters -- • Generate a Word Docume...
🔗CONNECT
LinkedIn: / fsouyri
Blog: sharepointfran...
Twitter: / francoissouyri
📽SUBSCRIBE
/ @digitalfrancois
🎁SUPPORT ME
The videos I publish are so short that they will not generate any revenue on CZcams but I want to continue to contribute to unlock and build solutions. If you find it useful you can just www.buymeacoff...
Merci pour cette vidéo François. J'ai créé un sharepoint IT pour l'entreprise le mois passé, et j'apprends à utiliser flow. La vidéo était très claire et m'a permis de créer un générateur de reception form.
Super ! Merci beaucoup pour ton feedback :-)
Many thanks. Not only extremely useful and well detailed but I appreciate your presentation style.
Thanks for your kind words! I truly appreciate your feedback and I'm grateful that you found the content helpful. Your support means a lot to me so that I continue publish what I find useful !
I must say that this video was extremely useful and well detailed. Grand merci à toi, François!
So glad that it helped ! Au plaisir.
Thank you! Very helpful and very easy to understand.
Thank you so much for your feedback 😊
Amazing. Thank you :)
I'm glad you enjoyed it! Your support means a lot to me.
Fantastic video! Really clear and helpful
Great to hear!
Great video and it helped me... thank you
Glad it helped! Let us all know in response if you managed to generate more documents and ideas on the subject..
Thank you so much for the Tutorial I was turning my wheels for months trying to figure out Power Automate.
Glad it helped!
I would like to populate one Word document with multiple lines from one sharepoint list. Is that possible?
Yes, I have done this for instance with multiple line address. Give it a try
Excelente video😍
Why, thank you! Will continue posting what I feel that everybody will benefit from knowing
Hi Francois, first of all thank you for taking the time and effort to make a video, much appreciated! As you already heard the ending was bit premature (it's really hard to not make a joke out of this one). What I'm really curious about is the maximum length of the fields you are populating. Or to be more specific; can you populate a field with more than 255 characters using this premium connector? Because I've made this work without using premium connectors, however that puts a limit to the length of the fields to be populated (which is a Word/Office limitation, really). I suspect the premium connector has the same problem...
will publish a part 2 soon then :-)
part 2 uploaded :-) czcams.com/video/2WDVcAck8WM/video.html
Why the polulated document didn't keeped all backgrounds?
that sounds like an incorrect format type, check extension and format encoding.
This is exactly what I needed! However I dont have premium license :(
It will be vey unlikely to find a Document Generator for free I am afraid :-(
Hi Francois, Thank you for sharing this video, I was really looking for this solution on how to populate list data to SP. I couldn't see the rest of the flow. the video ended before showing if the flow was successful or not. the reason I am asking is I don't have access to premium connectors. I want to make sure this works so I can ask my manager to get approval to get access to the premium connector.
Thanks in advance!
you are right, the last seconds got cut - I will check that ;-(
However, I am showing the process of writing the Power Automate and yes it works and generates the Word doc, and a PDF if we add an additional action to convert Word to PDF! Just get Premium license as it will only be for the 1 user who is running PowerApp on behalf of
@@digitalfrancois thank you, just checking if this is possible for excel, populating data to excel?
@@slideman2706 I would investigate using a third party, like I did here (Excel to PDF) as it does the job fast and simply. And yes they do have excel generator which I used to.
Hi there! This is exactly what I was looking for but I a little bit more in depth help. Is there any way I can connect with you off line and possibly hire you to assist me? I have a sharepoint list and a word document. I need to mail merge certain rows based on certain criteria. I am having a ton of trouble trying to get this to work and your video cut off without going further. My company just migrated to using Office 365 from google and I am so frustrated! Thank you in advance for your hepl!
Sorry for the delay. Have not received any comments notification recently ;-(
Keep experimenting to find the solution, and look at third party like Plumsail may help too accelerate.
My contact in channel description.
Hi, thanks for the tip,but have a problem. I want to ask why when i choose "when item is created", mine shows the field names (from the SP list), unlike yours which only has "site address" and "list name" (mine has it as well).
I dont know this is related or not but my Word document is not populated by the newly created item in SP List and returning blank values. hope you understand what i mean. Have a nice day
sorry about the delay. Did you figure it out? I would look into the "talking" between SharePoint and Word.. making sure that there is no login issue, re-install Word even ...
Can you please provide a workaround for those who don't have premium feature?
no need for premium, unless this has changed in the features model again. Anyone else here tried recently?
Premium :/ component
yes, it is now Premium. And it is unlikely to find a Doc Gen tool for free nowadays.🤥