Generate a Word Document from a SharePoint list using Power Automate

Рет қаралды 38,154

DigitalFrancois - (François tells Tech)

3 жыл бұрын

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: sharepointfrancois.com
Twitter: / francoissouyri
📽SUBSCRIBE
/ @digitalfrancois
🎁SUPPORT ME
The videos I publish are so short that they will not generate any revenue on KZfaq but I want to continue to contribute to unlock and build solutions. If you find it useful you can just www.buymeacoffee.com/spfrancois

Пікірлер: 38

@bencor4193 Жыл бұрын

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.

@digitalfrancois Жыл бұрын

Super ! Merci beaucoup pour ton feedback :-)

@djstone5518 6 ай бұрын

Many thanks. Not only extremely useful and well detailed but I appreciate your presentation style.

@digitalfrancois 6 ай бұрын

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 !

@joanne6381 Жыл бұрын

I must say that this video was extremely useful and well detailed. Grand merci à toi, François!

@digitalfrancois Жыл бұрын

So glad that it helped ! Au plaisir.

@justinheath2189 Ай бұрын

Amazing. Thank you :)

@scarletcourt9026 Жыл бұрын

Thank you! Very helpful and very easy to understand.

@digitalfrancois Жыл бұрын

Thank you so much for your feedback 😊

@Feuch24 2 жыл бұрын

Fantastic video! Really clear and helpful

@digitalfrancois Жыл бұрын

Great to hear!

@Janmabhoomi-Kosam 6 ай бұрын

Great video and it helped me... thank you

@digitalfrancois 6 ай бұрын

Glad it helped! Let us all know in response if you managed to generate more documents and ideas on the subject..

@nialeal2572 2 жыл бұрын

Excelente video😍

@digitalfrancois 2 жыл бұрын

Why, thank you! Will continue posting what I feel that everybody will benefit from knowing

@nev9932 2 жыл бұрын

Thank you so much for the Tutorial I was turning my wheels for months trying to figure out Power Automate.

@digitalfrancois Жыл бұрын

Glad it helped!

@CarpeNoctem42 2 жыл бұрын

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

@digitalfrancois 2 жыл бұрын

will publish a part 2 soon then :-)

@digitalfrancois 2 жыл бұрын

part 2 uploaded :-) kzfaq.info/get/bejne/aL10icZyyNGch4E.html

@slideman2706 3 жыл бұрын

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!

@digitalfrancois 3 жыл бұрын

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

@slideman2706 3 жыл бұрын

@@digitalfrancois thank you, just checking if this is possible for excel, populating data to excel?

@digitalfrancois 2 жыл бұрын

@@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.

@pedrohenriquefontesleitao9750 2 жыл бұрын

I would like to populate one Word document with multiple lines from one sharepoint list. Is that possible?

@digitalfrancois 2 жыл бұрын

Yes, I have done this for instance with multiple line address. Give it a try

@allnightdays1438 Жыл бұрын

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

@digitalfrancois Жыл бұрын

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

@geraldjamesmartinez2419 Жыл бұрын

This is exactly what I needed! However I dont have premium license :(

@digitalfrancois 11 ай бұрын

It will be vey unlikely to find a Document Generator for free I am afraid :-(

@kimwatkins2792 2 жыл бұрын

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!

@digitalfrancois Жыл бұрын

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.