Devin, can I just say that this is probably one of the easiest to follow PowerAutomate tutorials I've ever come across. You're explaining this spot on and this really makes sometimes daunting tasks look easy. Very well done, one can learn a tone from what you're sharing here. Thank you ever so much!

@PragmaticWorks

Жыл бұрын

Wow, thanks!

@sebenotblank9487

Жыл бұрын

@@PragmaticWorks Nice and short Guide. One thing that is missing is how to create a table with multiple rows. There are multiple options like using an array or the select action and I guess many people want to create quotes or invoices that need this function. :)

Devin, I have literally spent two days to find out, how to build this flow. And now I found your Tutorial and I not just built my flow, but I understand power automate much much better! Thank you!

Devin, this was so incredibly helpful. I just created a successful flow and honestly could never have done it without your help. Thank you so much!!

@PragmaticWorks

Жыл бұрын

Great to hear!

Excellent content Devin, I loved the practical examples without unnecessary dribble or excessive technical detail. 5 stars! would recommend and I have immediately subscribed to the channel. If I had to hire you or your company I wouldn't even consider other competitors. Keep up the good work and all the best.

Dear Pragmatic Works Team, I'd like to thank all of you for your job. I'm watching you in Ukraine and for me, your clips are a way to not think about the war in my country. I always imagine like this war will end and I will go to my job and will try to do all these tricks.

Thank you very much for this detailed and comprehensive tutorial. I learned a lot from it.

This is an incredible tool. I ended up with a computer science degree and hating coding, so I never did it. When the If This Then That app came out I loved it and it made programming a little easier. This though. Power Automate looks really accessible to me. And your instruction was really spot on. Good video. Good content.

Devin, this is amazing. This helped me out like you wouldn't believe!

@PragmaticWorks

2 жыл бұрын

Glad you enjoyed!

Devin this is an awesome video. really simple and easy to follow. Loved it!! Thank you so much!

Thank you Devin. What a good, clear and fun tutorial. I had hit a wall with other resources. Thank you especially for mentioning the ".docx" in Create File / File Name. You're a champion and you saved me hours.

This was incredibly helpful! Thank you for the video.

This was so good, easy to understand, very well presented. Kudos.

Agreed, superb narration with clear and simple steps! Thank you

@PragmaticWorks

Жыл бұрын

You're very welcome!

Thanks d-dawg, just saved me hours of time at work

I know this video is 2 years old, but it would be helpful to disclose up front that this flow requires a Premium Power Automate license.

Thanks for taking the time to do this.

This is awesome. Thanks so much! I was struggling to nut this out.

Hi Devin, thank you for explaining what I felt was a confusing and challenging task, yet to try the process, however you have armed me with a good foundation of knowledge to tackle this process. Thank you!

@PragmaticWorks

6 ай бұрын

Thank you for learning with us!

Amazing class, thank you!

Thank you for this video! This is exactly what I'm looking for, and your instructions are so clear. My only complaint is that I didn't see it sooner!

Exactly what I needed!

Thank you so much! Very helpful for beginners! The flow with forms as a trigger works fine. Now trying to make it work with data from excel :)

@ziadjadaa6002

11 ай бұрын

Hi @birtewee, did you manage to add outside data to the word/certificate file from an excel sheet? If so, can you please share the solution? I'm trying to create a Salary Certificate form that gets the main employee data from the MS Form, and just need to add the Salary part from Excel. Much appreciate your input.

@yooluca6947

3 ай бұрын

@@ziadjadaa6002 hi, i need it to! Do you have it now?

Very Helpful - thanks for sharing 👍

@PragmaticWorks

Жыл бұрын

Glad it was helpful! Thank you!

thank you so much, it really help my project

I liked this video. Please add more.

Great video! The saddest part was realizing my organization doesn't have the Premium licensing to use the Populate a Microsoft Word template. /facepalm. But I learned a lot about Power Automate here, nonetheless. Thank you.

Very useful thank you 🙏

Amazing help on this.

Wow Great Video, thanks so much!!

@PragmaticWorks

Жыл бұрын

Glad it was helpful!

way easier than populating an Excel template (no OfficeScripts etc.)

@PragmaticWorks

2 жыл бұрын

Glad you enjoyed!

Awesome walk-through Devin! Thank you. I got a proof of concept going successfully with this. NOW, however, I want to populate the WORD document with data from a Dataverse collection in my Power App. Any pointers to good reference material that shows how to do this?

Hey guys, Question: I have a mac! and also want to populate word document in power automate. I think the steps in power automate are correct. In word on the other hand, I can’t follow the steps from the video, what do I have to do? I thought I just mark it as a text field and I probably changed the wrong thing in options…

I had 21 H&H technical reports emailed, I owe you...

BTW: The Populate Word template is a Premium feature.

Hi, fantastic video thank you. Can this be done with a powerpoint template instead of word template?

Hi Pragmatic Works! Thank you once again for the amazing breakdown and the reply to my earlier comment! I would like to ask if its possible to combine the responses of 2 different microsoft forms to populate the same word document only when an answer within the forms are the same?

@desktopdatacrunching4032

2 жыл бұрын

I'm not sure how you could pull that off actually. The action to return items from a form requires a Response ID that you'd typically get from a Trigger. Since you can only have 1 trigger in a flow i'm not sure how you could pull off fields from multiple forms.

Hi there! Is there a way to pass numerical values from a completed form to a premade graph, so that the graph and extra text populates before converting to a PDF?

Thsnks for the tutorial Devin! What about checkboxes? How can we populate those

This was great Devin. I have two questions though, if you have time or can give me a link to research further. 1) What if you have more than one attachment to send to the user, how do you grab those and add to the e-mail? 2) In the form the person has a multiple choice and you want each choice to go to a different check box in the Word template - how does that happen? Not sure how to parse those so they become a single text rather than (example) ["Option 1","Option 2","Option10"]. I really did like the way you walked through everything. Very good!

Thank you very much for this Video, you made it really easy to understand. However I have a question, can I do the trigger with an Excel file containing names?

Great video! Would really like to know how to change the date format.

Devin, this video saved my life, I spent days searching for a way to create this flow. Someone know why the file is not being created in Word type? All files are coming as a blank page, so I have to access each one and transform in word

Hi! Do you have a video on how to use something more dynamic than a form to populate these fields? Like Web Data from ZoomInfo or some kind of web platform like that, for a specific business that would be dependent on, and scrape triggered by, the creation of some kind of new asset (new account plan word doc or contract created) for a new business with a certain identifier?

Great tutorial -- thanks. I know this wasn't the point of the exercise, but you'd normally generate certificates from a roster or other previously gathered information that validates the attendance. Letting learners request templates with just the form wouldn't pass the audit sniff test. Assume this tassk would be just as easy to complete from a class roster or worksheet??

Great video Devin! I noticed one of the actions had a tag of "Premium". What kind of licensing or subscription are required for this workflow?

@bernardojacobi6877

Жыл бұрын

Hi there mate, I have been through this journey recently. You need a pay as you go / pay per use subscription. I think its about $0.80 per flow run, its a bit pricey but if it saves you or others time then it is worth it. I recently wasted money on a 'per user' licence which doesn't provide access to the Word template functionality.

it would be great to see this with a non premium connector being used.

GREAT VIDEO! Have you posted the video you talk about at the end? :D Can't find it.

Thank you for sharing this video. How many characters are allowed in the field? I want to be able to update the whole paragraph. Is it possible?

What about checkboxes and conditional logic within the word template pls. Thank you 😊

Neat feature. For that Date field, what if I want to use the date when the certificate was generated from Power Automate? Is there a way to do that?

just what I'm looking for thanks for sharing... I have the same scenario but I have several templates, how can we initialize variable based on user selected value in the forms.

@desktopdatacrunching4032

2 жыл бұрын

You can do an initialize variable and then write values to it based on what's coming from your Form using Dynamic Content

Hello, Could you explain me how to do so with a multiple choice question in the forms ? I strugle to find the way to convert the multiple choice answer in the pdf document Thanks a lot, great vidéo !

@victorgarcialiegeois9413

2 жыл бұрын

Same question to add a scan of the Id card to the forms but again I don't find a way to convert the scan of the id in the word template. I would be very grateful if you could help me hehe !

Devin, if we have created for example a report card in the word template, the forms will have and option to select multiple subjects and then give their marks, how can we automate for different number of subjects. Some can have 4 subjects while others can have more or less subject. Is there a way that we can adjust the template table according to the selected number of subjects?

Nice blog! One question, why aren't you using the premium action "Convert Word Document to PDF"?

Hi, this was a great video, thank you! Do you know if it’s possible to pass through a barcode from a SharePoint list? The barcodes are generated via SharePoint when a new recorded is added. I keep on getting errors when trying to pass it through dynamically?

Is it possible to do something larger than these documents?? I would like to use Forms to collect a comprehensive amount of information. On the back of this I would like to save this data (which i think would be via Excel) and then create various Word documents / PDFs. Is it possible to use Power Automate on this scale? Everything I have seen so far is just solutions smaller tasks.

Hi Pragmatic Works! Thank you for this amazing breakdown of how-to steps! I would like to know if it is possible to not convert to pdf but still send it out as a microsoft word docx instead?

@PragmaticWorks

2 жыл бұрын

Hi Hendrik, this would be a local setting for each user. They could set PDFs to open in MS word.

@hendrikkwok4550

2 жыл бұрын

@@PragmaticWorks Much Appreciated! Thank you!

"Thank you for your sharing. I'd like to inquire if it's only possible to create one certificate at a time. For instance, if an organizing unit intends to produce multiple certificates at once, where can I input the names for multiple certificates?

Yes! Thank you for your clear instruction--so very helpful. Not sure if anyone is checking this thread, but when we added the "Create a Word document" PowerAutomate promoted for Premium subscription. My licensing includes "Microsoft 365 Business Premium" and "Power Apps for Office 365". Any thoughts or suggestions?

@FlorianRemy

6 ай бұрын

You need a Word Online (Business) premium license. I just followed this tutorial, to find out that I can't use it because of this restriction..

Thanks for sharing , Id like to ask about how i can add photo from Mform to word tamplate

I figured out the flow and all my answers populate. However, the emailed PDF displays the labels of the active x control. Any solutions would be appreciated Awesome tutorial!

Hello, I need to populate a word template with contact information from the dataverse, and finally to send the file to the contact's mail with an manual action, for example a click in a ribbon button in the main contact's form

this is very helpful. But, what if we have many rows to add into template file , for example we have a collection from Powerapps to push as JSON . Could you please explain how to create the word doc. Thank you

hola hay una posibilidad que ala accion del wor populate template lo tome uno de sus campos el nombre de la persona pero no escrito en form si no que hay una columna de lo que crea el form en el excel llamar ala columna de acuerdo su dni, en la columna mostrarias sus nombres completos pero yo intento llamarlo con items()?['Nombre'] pero me bota erroro si no su nota final que eso no se pide escribir en el form

Since the Class Name never changes, could you use a compose action instead? I tend to use a lot of variables in my flows that change so I try to keep static information in compose actions, is there a pitfall I haven't seen yet?

@desktopdatacrunching4032

2 жыл бұрын

Yeah totally makes sense to do it that with how this one was designed for only handling a single class.

yu save me thank's

Hi there, how do you format a date that is coming in as a long number? thanks

Can this be done with JSON data passed from powerapps? For example have the template uploaded like you do, then on the press of a button pass the data from 10 or so fields in JSON to power automate, then use that data to populate the fields in the template?

Great video. I have a queston for you. How to export the MS Forms likert responses to word and then convert to pdf?

Great tutorial to get started with PA. I'm having some trouble though. The file created, either PDF or Word is fine, however, once received by email, the attached PDF is unreadable. Anyone else having the same issue?

Does the HTML part of this process in Power Automate also accept CSS styling? My team has to use MS Word docs for our Project Briefs, which are sent to team members and clients. Those Word docs are formatted with table layouts, background colors for specific table cells, font sizes, etc. We do not have MS Forms or Power Automate yet. I'm still researching all they can do. I need to confirm if I can create a table layout with custom styling in Power Automate to match our Project Brief template. That way, clients can fill out all project details in a MS Form, and Power Automate will export that form data to a Word doc that looks exactly the way we want.

hi, can you please help me in removing the blank spaces while using the Repeater control. If the value is blank, its creating a 2 line space between tables

Hi Great video and thanks for the detailed explanation. However, could you please explain how to convert populated word document in SharePoint to Pdf. I tried with "Convert Word Document to PDF" and it is not working. Kindly help.

Is there a way to do this with multiple-choice questions from a Microsoft form?

You are G R E A T!

@PragmaticWorks

Жыл бұрын

Thank you for watching!

Is there a way with this template to create a list? Let's say my power automate will connect to my dataverse. I want to add values from my main entity, and create a table with a 1:N relationship to another entity.

i am having issues with multichoice answers populating in my dynamic content with brackets and quotes, how can I automate this removal for a clean text

Thanks for this video. My question is about populating the word template but from a rich text editor. Is it possible to populate the word template with html text and get only the text?

@desktopdatacrunching4032

Жыл бұрын

I've only been able to get Power Automate to recognize the fields when they're plan text.

Anyway of doing this without the premium subscription?

does this work the same using the Power Automate app in Teams

Unfortunately I do not have the "Word online" operation to integrate in Power Automate. Is this a premium feature or something similar?

This is great but is there a way to do this without a premium license?? Any workaround is much appreciated

in mac os on word for business it is impossible to add tag to single word... how can i do this?? thanks

Is there a work around if you don't have premium to use the Word templates? or is it just worth getting a premium account?

How can I add a hyperlink into the Word document in similar fashion?

Can something similar be done with an email in Outlook?

Great video 👏 Consider me subscribed

How can i make one document with multiple documents

Okay, I got lost on the Form Link... where do I go to make a form and to get the link?

Hi, Can anyone pls help me with why I cannot locate my fillable word doc in the step "CREATE FILE" ?

Is there an alternative to this? The Populate Word Doc action is premium. I can't use it.

Thanks for this video. Its super informative. However i am facing an issue. I have over 20 fields in the form, but when i populate these in the form only about 6 fields show up not all. Where possibly i am going wrong?

@gulatinaveen

2 ай бұрын

Sorry, This is solved. I overlooked a few things.

Can i add a hyperlink in the text?

What happens if there's say 5 different questions and answers on a form and you want to populate the questions and answers on two different columns?

@kenanderson5739

5 ай бұрын

On your word doc template build, insert a 2x5 table. I have 5 series of questions and 5 different columns to keep the data organized.

Do I save as a word document or word template?

@desktopdatacrunching4032

2 жыл бұрын

You'll save it as a word doc. Thanks!

5:02 you mentioned "save as template" i did and the document was named as ".dotx" but when you upload at 5:41 - the document is .docx

@desktopdatacrunching4032

Жыл бұрын

I misspoke there. You should be saving this as a regular word doc.

Hi can you guide on how to change the date format

@desktopdatacrunching4032

Жыл бұрын

Check out this video for formatting dates. kzread.info/dash/bejne/mYNmwdKyd93MZKg.html

How to insert line breaks?

I use power automate to populate word template file created open on word online fine but in work app some fields are Duplicate? Can u help me on this

@desktopdatacrunching4032

2 жыл бұрын

Hi Ajay, It's going to be a little difficult to troubleshoot that here but you may want to check out our mentoring service. pragmaticworks.com/virtual-mentoring/

Is this possible without a premium connector?

@yewchoob85

5 ай бұрын

yeah it is.