I know you have been doing this for a while but when you go through these without missing syntax or a "" or curly brace is impressive! always so clear and concise
You make it look soooooo simple and easy to do. I've done this sometime in the past but watched it as if it was my first time watching this feature so I can learn something and wasn't disappointed at all. Thanks for sharing.
Thank you reza ,it is amazing shot ,i wish it was not premium one , currently i have a purchase request form being printed through HTMl document using flow
Hi Reza, I am reaching out to see if you can please enable the download link for this Populate a Word Template video again for me? Thank you so much for such great content.
Thank you Reza :) Is there any video in your planned to create PowerApps about project planner that show in Gantt chart / Time line view ? (Thanks again for multiple valuable video :) )
Great video. Thanks @Reza I have created an App (PowerApps), the App has a collection in which I am trying to parse the data and then populate a repeatable section in Populate a Word online template. Unfortunately, the repeatable section is not working, and I would appreciate it if you could make on video on this. Any advise also will be great.
Hi Reza, Thanks for sharing this video. I am working on building something similar to this but I have two templates based on the user selection and have multiple pages which then convert to PDF and merge into one PDF file. It is working fine but the issue that I am facing is the page number for the templates. Is there any way to populate the page numbers when we merge the documents?
hello Reza good explanation. Wanted to ask will the users of this automation has to have "contribute" access to the word document template lets say for example the inputs will be coming from a SharePoint list.
Great - as usual. Thxs. I was wondering, if / how one can populate a word template with power automate with images in a repeating section. As it looks to me, that is currently not supported. Maybe someone has an idea for a workaround....
As always a big fan of your tutorials they are to the point. Simple and educational. Thank you. How can we point to multiple signatures, in case we have more than one person signing the document.
Thank you @Reza for such a wonderful video. Have been waiting for such a video for a long time. I see that the certificate is being triggered manually for every item in the 2nd half. Wanted to check if we can generate the same for a big list all at once. Will this mean we have to Apply to each to get a lot of info dynamically onto the certificate? I have a use case for at least 150 such instances each month and hence want to build something dynamic in nature.
Thanks so much. Links are available in community tab. Respond to the thread for this video on community tab and if link is not open, Il share an updated one
What would be really interesting is creating tables in Word with repeating sections. You intimated that it could be done in your chapter on building the Word template, but I'd be keen to see it working in practice...
@@RezaDorrani Hi Reza, did you create the repeating sections video? Also I'm interested to know if Microsoft Populate Word can conditionally delete sections in my word template depending on form field data? If not do you know an alternative option?
Yes there is. It's a Microsoft connector... Why is excel included but word isn't? Why is converting a Word file to PDF within Word (by printing), but is the Word to PDF in P.A. suddenly a Premium?
Thank you for sharing this Reza! I always wondered why “File Identifier” did not work when I used the same exact text from Environment Variables... Though it seems I forgot “encodeUriComponent” part 🤦🏻♂️
Wow!! very impressed As ask you last time about PDF signature. I got some idea but in case of populate on PDF directly (Make some template on PDF) Is it have any solution for it? Thank you so much
hi Reza, How can we populate the word template based on conditional controls, for example i want a certain to field to populate if the value is greater than 50000 or dont want to show a complete row in word if a certain value is blank
Yet another great one. I can't thank you enough. BTW, is it possible to merge different word files in one consolidated file leveraging power automate (without using third-party connectors)?
Hi Reza Another splendid video. If I'm being fussy though, I would think that it would be better to have to generated document save to a document library. Adding attachments to SharePoint list items just never feels right for me. 😎
I try and mix and match in my videos. I have done videos saving files to libraries so thought of saving one as attachments. As I said in video, you can save it wherever you want 😉
Great information! Can this be done without the Premium Connectors? I did follow your tutorial on Power Apps to PDF; however, it appears the experimental version does not allow the use of shapes, lines, etc. in creation of a PDF. For that reason, Word would appear to be a better option.
Thanks for the demo reza, it would be very helpful if you can also make video on dynamicFileSchema when user dynamically selects docx file from the document library. 😊
Hi Reza, Great video! Really appreciate it! I've followed your flow and it works! But do you know why the attachment in the email appears not in a Word document? I need to download the attachment first and then open the Word document.
Very useful Reza jan. I use this method to generate a Word document by entering data in a PowerApps form but didn't know why to remove the double quotes in the attachment.
Hi Reza, Thanks for this detailed video, I am using the same functionality for populating dynamic content in word template but I noticed that the updated metadata is showing in word online but not in word app. Is this a bug or some sort of limitation? I am using plain text only. Thanks again!
Wow, those quotation marks around the dynamic content for content bytes really had me in a stranglehold for the last week lol. It's so annoying that the solution was something so small! lol
@@RezaDorrani OK, good to know. I think this is the 1st thing I have tried to do that's not possible. Everything esle, Power Apps and Power Automate I've always found a work arouud.
Hello Raza, here in Korea we learned a lot of knowledge the power apps from you. I appreciate. May I ask you a question? In this video, I realize the population word function is premium meaning that I have to purchase. Am I correct?
Sorry but May I ask you one more question? If I buy a premium license for this and develop a program after that deploy it to the 200 users. Does it work for 200 users without premium license?
Great video Reza! Appreciate it. Very clean execution and explanation. I did the first part with a Power BI trigger and worked beautifully. Much thanks!
HI @Reza Dorrani ,Thank you for your Video , I have a question: Is it possible to dynamically select a specific template at runtime based on input values? For instance, if we have more than 40 templates (e.g., Temp1, Temp2, Temp3, etc.), can the system choose the correct template depending on the provided input? Looking forward to your guidance.
Hi Reza Dorrani sir, Good Afternoon!! I have a list of assets with a column named "Office Location" containing values such as Delhi, Bangalore and Mumbai. I also have another list named "Roles" which contains two columns: "User" and "Location". The data Presented shows that for the same user, let's say "Raju" we have different locations such as Delhi, Bangalore, Mumbai and so on. My requirement is to use a gallery control to display data where the office locations from the assets list match with the locations present in the roles list. Please give me Answer for my requirement ASAP. Thanks & Regards, Sanjam Ugandhar.
I do not have any video references on your requirement. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hello Reza! Big fan of your videos and have learned a lot from you. Is there a way to use a dynamically-created MS Word template with the "populate a Microsoft Word template" connector? I'm trying to populate template fields into a copy of a standard template that is created within the workflow, but since the template copy hasn't been created yet the connector has no content controls to find/display. If I use the original template to populate the content control fields, then change the filename to a variable filename, the content controls disappear. Help (and thank you in advance)!
Thanks so much for watching and learning from my videos. I have not tried the scenario with dynamic word templates. It would probably not be supported as it would not be aware of content controls. I would suggest checking or posting your query on forums in case someone has found some workaround powerusers.microsoft.com
Hi Raza , I need a help , I am creating a Flow for employees contact which is on word template and is get the responses from Form and populate the word docs then it’s convert into a pdf file and send on email, issue I am facing we have a section on Form if it’s selected by No than a normal contract should go to the employee IF they Put some value on that section then they should receive another copy of contract which has different terms, please advice how can I achieve this. Thank you
I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Very helpful. However, if I had a csv file in the previous step (Get file content) how can I use the fields in a file content stored in One Drive or Sharepoint to fill up the advanced parameters of a Populate a Microsoft Word Template action? Thanks
Thanks! I do not have a video reference on the mentioned scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, do you have a work around flow for populating a word doc based on SharePoint List column values? It seems Populate MS Word Template is a premium connector?
Great Video, Raza...Could you help me converting word to pdf or not editable mode? because the word template is able to modify...technically they can edit image or pdf also :)
Hello sir. Thank you so much for the lovely session. How this output document can be integrated with Docu sign approval process through powerautomate. Kindly provide your thoughts and reference videos if any
Most welcome! I have done no work with docusign hence not sure. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video thank you! I have an MS form being completed by multiple users in the organisation. I'm planning on using this connector to populate a word template. Will I need a single premium license for the flow owner?
The Populate a Word Template action is not working for me. I have searched the community forums but to no avail. Thanks for the video, though. In theory, it should work.
What if the source field to populate the word document is multiline long text with rich text? It converts things like ** to bold and ## to header format. How do we get this to display correctly on our word document?
What was the reason for removing the Quotes when attaching file in email? I have an issue with the output file that is attached keeping the text fields in the file. Only trick that seems to have worked is to convert to pdf then back to word using adobe connector and attaching that file. Thoughts?
The new designer adds that quotes. The content bytes expects the file blob and not the info in quotes which means a string. I have not come across any issues so not sure about the reason or fix for your issue.
I have done very little work with PAD hence not sure. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Is it possible to insert multiple images with just one placeholder? Example, I’m using the images attached to a sharepoint list and I want them to be placed in the word document.
Perfect Timing for this video! I'm hope to order this premium connector soon. Can the file be renamed and saved to SharePoint after it is generated by selecting "Create File" in Sharepoint action, then putting the template as the body of the file?
Hi I need to populate a word document from power automate flow which my word template table has nested repeating section control but it seems power automate populate word template action doesn't support nested repeating section control could you please give me solution?
Yes. It does not support nested repeating sections. I am not aware of a solution for it. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Can i do this with my data which is in SQL server database, I want to populate a word template with importing data that is present in SQL server database record .
Hi Reza, thank you for this video. I have 300s different templates in a SharePoint library, user selects the template from dropdown list in power app, based on template selected fields for that specific templates shown dynamically to enter data, upon button click flow should populate those value to selected template from powerapp. Is it possible using Powerapps and Power automate flow...? Note: dynamic templates (multiple templates, one power automate flow to populate.
Do I need to build 300 flows for each template or how to dynamically populate values for selected template with one flow...? if one flow then we need to pass the location template file dynamically.
I have not tried making the templates dynamic, hence not sure of the options. I would recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Hello Reza, i was wondering ... 1) can a repeating section from a Word doc. be populated/connected with SP multi-line-flattext-field-json/metadata without premium connector? 2)I was searching for a way to fill a power apps SP-form invoice with parent and a child repeating table data that would be stored in a multilinetextfield from the parent list or library and send a pdf with signature fields on the bottom to be signed with a certificate. Is that possible or do I have to use Adobe Sign or do you have a other solution?
Congratulations on the great videos... I'm having a problem, I want to fill in images that I have attached to an item on Sharepoint, when getting content from the attachment it gives an error saying that it's not PNG/JPEG, but they are... how to solve it ?
Thanks! I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi! How do I show my flow from the sharepoint Automate button? I have done this but I don't see the "Generate certificate" in the Automate menu. Thanks!!
I wish there was a way to get data OUT of a word document, after you have made the document using it. Like if someone updates it or whatever… be able to pull that back out in json format
@@RezaDorrani yea, it looks like you have to unzip the word document and work with the document.xml file… but then you have to do xpath and know what all the tags are to traverse the xml. Looks very complicated from the research ive done thus far.
i have a problem with the image when my document is generated it d'ont show the image and instead i have a message : "Impossible to charge the image" what can i do ?
I have not come across this and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
The problem was that my image was in the header of my word document not sure why that didn’t work but when i used in in the body it worked 👍 thank u for your reply ❤
I have followed all the steps in your tutorial, but I can't get the image. When the word document is generated, I get an error on the image that says "The image cannot be displayed"
Hi @RezaDorrani , thanks for sharring content for us. after data is loaded/ Populated in .docx in content control if we want to edit , it is not edited, instead it removes value along with content control. if you see the above video 9:16 name is populated the text , can you try to edit the name and see it is possioble to edit the values ? after you downloaded to your local system.
Hi, I am using SharePoint instead of one drive. Also after generating the doc , i still can see the template's content controls properties. How to remove those controls and copy the word doc to new folder in SharePoint? I would like to have a normal doc without content controls. Thanks
@@RezaDorraniforgot to mention, i am not using word populate option. I just create a new file using the template and update the file properties. Then I am attaching the newly created word doc ( in same template folder ) to email .
Hello Sir. Thank you for the detailed video. when an item get modified, how the previously created word file is updated automatically with the same name kindly suggest your thoughts
@RezaDorrani thx. trying to grep a summary section of a word doc to populate a sharepoint list column. I will try it out and report back if this works. thx for idea again
How can we populate multiple images to word document with repeating table? Inside the flow, I add the "file content" awa other columns in an Array variable. Then insert the variable to the repeating table. I have successfully populate all the library columns but the image is always empty. There is no error occur so I don't know how to troubleshoot.
Hi Reza, if I have the same fields like "Name" multiple times in the word, and I am then trying to use the action I then need to enter all the information by hand in PowerAutomate multiple times since all the same "Name" fields appear independently. Is there a more efficient way of using the same fields in Word without having to fill each of them in PowerAutomate? Thanks very much for your help and your videos!
Hi Reza, I found this video on dynamically plugging in the content based on the field name: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-a2C7RzrWw6I.html The question here is, what happens if a field doesnt contain a value?
Even if a field does not contain a value, you would need to populate it with an empty string. Im not aware of any options around it. Also, the video you shared is not something I have built or seen so not sure about that scenario.
I have a set of 100 word files each containing 20 variables, the total existing number of variables is 120. (these 120 are all unique ones) So in the flow I use a switch to navigate to the right word template which needs to be filled. I then need to plug in each variable. Meaning 20x100 variables to type in manually in powerautomate. Can you follow with this description? Appreciate you looking into it ✌️
Very nice. I just used this feature last week to create a label based on Sharepoint List inputs for our one of our Groups. Thankfully I had already been granted Premium Features by our IT Group so that I could use it. Only issue was sharing the Power Automate Flow in a Power App so that others can run it who didn't have Premium Licenses, so I chose to have folks run the Flow as Me. Hopefully that's not an issue with the Microsoft folks. However, it may cause an issue if I have to leave the organization for whatever reason. Someone else would probably have to take over the Automate Flow that also has Premium. I did notice that Premium didn't show up on the Office 365 Example, the first one. Is it not a Premium feature there?
If flow is triggered from power apps, the premium license need falls on power apps which means every user running the app will need a premium power apps license. Office 365 example first one? which one?
@@RezaDorrani I had someone without a license test, and they were able to run the power automate flow without an issue. The first example. When you were in Office 365, when you searched Word, Word Online (Business) pops up and the Populate a Word Template doesn't have Premium next to it like in the Sharepoint example.
@@ed-salinas-97 They may have been assigned a trial license or auto claim. Word connector is a premium connector (new flow designer does not show that)
I would like to save the Word file in OneDrive and then once the file gets updated and it's finished (offline) I would like to update the SharePoint list with the information in Word, do you have a video about something similar?