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.
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!
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?
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.
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. 😊
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.
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 🤦🏻♂️
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.
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
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.
Great video, thank you. Let's say you want to attach photo of individual in the certificates. How to add that on the certificate for each of the students?
I would have to try this out to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Great video! One question, When i add content in my template for date, after the flow runs it formats the date incorrectly. My source data comes from a microsoft form and the format is set to dd,mm,yyyy, and the content is populated into a field within a table. Just wonder why it changes the format after populating it shows yyyy,mm,dd. any ideas please?
Hello, great video! do you know if there's any option of doing this without the "Populate a Microsoft Word Template" Connector, just using the basic connectors in Power automate?
I came to this video after I was unsuccessful in my initial attempts. What I saw is that the text fields must be one name, no spaces. It would be worth it to call that out specifically because if you name your field with a space, it throws an error on the Power Automate side. THANK YOU!!!
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
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 :) )
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 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.
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.
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.
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 @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 @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, 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?
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/
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 😉
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.
@@Hulk-m3x I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
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
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.
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
@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
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
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....
Just seen this. Very promising. How do I extend the automation such that a template is created and emailed every time a new text file is created in a specific folder in Onedrive?
Thanks! I would 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
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!
Thank you for this. Is there way to add hyperlink dynamically with this method? I ee it only works will plain text :( . Links appear as plain text too and there is not way to do CLick Here kind of thing to redirect them. TO top that user cant select and copy link from control. they have to copy whole control content and paste in notepad just to get that URL
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?
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
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
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?
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)
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 :)
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: th-cam.com/video/a2C7RzrWw6I/w-d-xo.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 ✌️
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 use this with repeater inside repeater? Ex. I have X amount of projekt which have X amount of task each, is possible to use this action for it?
@@shaggy2408 It is a known documented limitation. There may be other premium connectors available that offer this feature. You can explore those options.
@@RezaDorrani i have actually solved it with different approach with Custom Page where I have added a gallery inside a container and used PDFviewer to show content from container and saved it to SharePoint and download file afterward to print it...
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.
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?
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
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.
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?
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?
@RezaDorrani - my scenario is that I am trying to keep my Word document in the Dataverse table instead of SPO or OneDrive, but I haven't come up with a solution yet. per the microsoft the 'word to template' action is not supported to work with the Dataverse.
@RezaDorrani I am not able to post the a link. TH-cam somehow keeps deleting my comments... Please look for a "How to populate word as a template dynamically from the Dataverse?" There is a topic on the Microsoft Power Automate Community. Somebody was looking for the same solution in 2023.
@@enj0i50 Community forums and official Microsoft documentation are 2 different things. There is no call out of this action not working with a data source. It has nothing to do with a data source as you simply provide it dynamic data, it will generate the doc and you can save it in any data source of your choice.
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
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! 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!!
@@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.
I think you might be psychic. Every time I wonder if I can do something you drop exactly the right video.
I read minds :)
I was thinking the same!!! Went to his channel and Boom! It was there :) I like the flow of Reza's tutorials. Very well done!
Exactly 💯
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
Thanks
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.
Thanks so much!
There is always something new to learn.
You're right!!
You are the best at these videos Reza! Thank you for all the time and effort you put into making them.
Thank You Gina
Life saver of a video for a big project I have for work, thank you sir!
You're welcome! Glad it helped!
Amazing video! Thank you so much for sharing it. Greetings from Colombia!
Most welcome!
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!
Glad it helped!
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...
Thats a planned video 😉
@@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?
@@JB-ch9ws th-cam.com/video/KVnfWsO1Fhs/w-d-xo.htmlsi=MsvyEYdhGk3dHdOP
Deleting conditionally is not an option
Excellent teaching style- so clear!!!
Many thanks!
The trick with the compose is super smart. Thank you Reza
Most welcome!
Another great one Reza. Thanks!
Awesome!
Amazing videos as always!
Thanks so much
Thank you Reza, very informative videos and enables power apps champion to solve day to day challenges
Most welcome
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.
I have a video planned on repeating section.
I am awaiting the overall response to this video to know if it’s worth building a follow up video.
@@RezaDorrani This video was truly amazing. You are the best Microsoft MVP.
@@nitinchamroo5748 Thanks!
This one is fantastic! Thank you!
You're very welcome!
Thanks Reza, for this most usefull video..🎉❤
Always welcome
amazingly well done video!
Thank You
Hi you make great video, is it possible to use a fingerprint reader on a powerapps application, it would be cool thanks
I am not sure about fingerprinting.
Thanks sir for another helpful video!
Most welcome!
Thank you Reza for continuing to publish content building with the Classic designer.
I covered both modern and classic 😉
@@RezaDorrani yes, many thanks for still covering the classic 😉
Uggg true. That new design is awful
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. 😊
Let’s see the response to this video.
I have plans to do more videos with this connector in future.
Thanks for the video. very informative. can certificate be in pdf format?
Most welcome!
The word connector also has a convert to pdf action.
Superb useful use case . Any plans to make videos on PowerBI too?
No plans on power bi
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.
Yes, correct. You can run the actions in a loop.
Super. Thank you @@RezaDorrani
Nice video tutorial. Thanks for sharing
Most welcome
You re so far the best ... please can you show how to populate a word table template and send it by email ... thx a lot
Thanks!
I have already done a video on that - th-cam.com/video/KVnfWsO1Fhs/w-d-xo.html
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 🤦🏻♂️
Most welcome
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.
Glad it helped!
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
Premium offers most value. I have done videos with HTML technique as well.
@@RezaDorrani please can you share the link to the html video
@@markjacobson9532 I dont have the link handy. It would be somewhere in my power automate playlist.
Thanks Reza!
Welcome!
Thanks for the video.. Please How do you implement with HTML tags?
Rich text is not a supported control
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.
You would need to add multiple image content controls for that.
Great video, thank you.
Let's say you want to attach photo of individual in the certificates. How to add that on the certificate for each of the students?
I would have to try this out to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Great video! One question, When i add content in my template for date, after the flow runs it formats the date incorrectly. My source data comes from a microsoft form and the format is set to dd,mm,yyyy, and the content is populated into a field within a table. Just wonder why it changes the format after populating it shows yyyy,mm,dd. any ideas please?
You would need to use expressions in flow to adjust the date. Check my video on expressions.
@@RezaDorrani thank you for the quick reply. Can you use an expression "Formatdatetime" within the same field? many thanks for your help
Please check that video. I don't exactly remember the expressions.
@@RezaDorrani Thank you will do
Hello, great video! do you know if there's any option of doing this without the "Populate a Microsoft Word Template" Connector, just using the basic connectors in Power automate?
I'm not aware of other options
I came to this video after I was unsuccessful in my initial attempts. What I saw is that the text fields must be one name, no spaces. It would be worth it to call that out specifically because if you name your field with a space, it throws an error on the Power Automate side. THANK YOU!!!
Most welcome! Thank You for calling it out :)
Thank you for this .I need one more help ,how to get the signature image file from dataverse .
I have not tried with getting file content from Dataverse so not sure.
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
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 :) )
Most welcome!
Planned - Yes, but priority will be based on demand.
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?
Thanks!
Best to rename the file prior to creating file in SharePoint
@@RezaDorrani okay, thank you!
@@RezaDorrani can you make the file name dynamic to match a field in the document to be able to easily identify who the docs are for?
@@thatonepixel5578 possible
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.
I will repost in the correct community.
Please post in the community tab where the download link was shared :)
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 Randy.
Im not aware of any workarounds with standard licensing.
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.
Attachment in email is the word doc as shown in video.
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)?
Thanks.
I have not tried merging docs so not sure about the options.
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.
I have not tried the editing scenario. Use case showcased was to generate a finalized doc.
@@RezaDorrani is there any video you already covered if you are going to check it is possible for the same ?
I dont have one
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.
I don’t think that’s an option as flow would not be able to comprehend the content controls.
Amazing Video! Really help me out a lot! How were you able to set the cursor for the signature?
What time in video did I do that?
@@RezaDorrani 3:24
@@OhItsTayleaux I simply clicked on that area and added the control. Nothing special.
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?
Welcome!
I have not tried merging documents or pages hence not sure.
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/
Thank You so much!
You're welcome!
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 😉
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.
The word doc template - read access is enough.
Present sir❤
Thanks
@@RezaDorrani please upload a video on powerautomate crud operations as well
@@Hulk-m3x
@@Hulk-m3x I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
thanks for the great vid.. however ive encountered the image getting rotated. any ideas how to fix that?
I have not experienced any image rotation issues hence not sure
Is it possible to use microsoft forms responses to autopopulate forms?
Yes
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
The action allows populating a new one, not updating. So you would need to delete old one and then populate new one on item updated.
@@RezaDorrani Thank you for swift response. how delete the old one dynamically and to replace new one
@@kumarvelu2920 Use delete file action and then follow same process as shown in video
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.
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
You can always convert word to pdf.
Check th-cam.com/video/KVnfWsO1Fhs/w-d-xo.html
thx. will this work if I do the reverse where I have a word doc and use dynamic fields to populate a sharepoint list?
Not sure about options for reverse as I have not come across it in a project scenario
@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
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 Reza, this is really good content. Can we do something similar in power point?
Thanks!
There is no out of the box action like word for PowerPoint
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....
It’s not a supported feature. I’m not aware of a workaround for it.
Just seen this. Very promising. How do I extend the automation such that a template is created and emailed every time a new text file is created in a specific folder in Onedrive?
Thanks!
I would 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
Just use an automatic power automate trigger to email when the file is saved to the folder.
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!
I don’t remember running into this issue and not sure if there is a limitation
@@RezaDorrani strange I got it to work in word app as well by replacing the old ones with a new placeholder.😅
@@SamRustagi weird
Do you have a video showing this when using word on a Apple Mac?
No
Thank you! Does this approach also work with PPTs?
Not with PPT
Thank you for this. Is there way to add hyperlink dynamically with this method? I ee it only works will plain text :( . Links appear as plain text too and there is not way to do CLick Here kind of thing to redirect them. TO top that user cant select and copy link from control. they have to copy whole control content and paste in notepad just to get that URL
I am not aware if hyperlink is supported. Check documentation for the word connector to see whats supported.
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?
I do not have a workaround reference
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
@@RezaDorrani thanks
Is there not a way to do this from the desktop powerautomate? Or does it have to be via the web browser?
This is purely for cloud flows. I'm not aware of options in power automate for desktop
@@RezaDorrani Dang :/
I would like to download this template and flow. is the link still valid? Great video btw. As usual.
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
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?
learn.microsoft.com/en-us/power-platform/admin/power-automate-licensing/faqs#multiplexing
Is there a simple way to dynamically change the document to populate data. I have many templates with same tags/fields.
I have not explored this scenario hence not sure
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)
@@RezaDorrani Ah, okay. I haven't transitioned to the new Flow Designer yet. Not ready for a change right now. Ha ha!
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 :)
th-cam.com/video/KVnfWsO1Fhs/w-d-xo.html
Thanks Reza , but the populate to word is premium connector ?
Yes
thanks! any luck with populated rich text?
Welcome!
Rich text is not supported as per documentation
Some more usecase of copilot powerapps/powerautomate will help if you can make videos on that
Let’s see. I have a lot of videos planned. Week by week Il release them.
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: th-cam.com/video/a2C7RzrWw6I/w-d-xo.html
The question here is, what happens if a field doesnt contain a value?
Are you in need of a repeating control?
If yes, then check th-cam.com/video/KVnfWsO1Fhs/w-d-xo.htmlsi=H9skm_J6X_244xMO
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 ✌️
@@jonaskoniger3337 Im not aware of a solution for this. Try and check on forums.
Hi! How can I do the same with Power Automate Desktop? Thanks in advance for your help.🤗
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 use this with repeater inside repeater?
Ex. I have X amount of projekt which have X amount of task each, is possible to use this action for it?
As per documentation, repeater inside repeater is not supported.
@@RezaDorrani that is really bad...
I did also tried to merged the output from that action into one document, but is it not working...
@@shaggy2408 It is a known documented limitation. There may be other premium connectors available that offer this feature. You can explore those options.
@@RezaDorrani i have actually solved it with different approach with Custom Page where I have added a gallery inside a container and used PDFviewer to show content from container and saved it to SharePoint and download file afterward to print it...
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.
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?
Thanks so much.
Yes, word connector is premium and license will be needed.
Thank you for your answer.
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?
@@majayong-r3n Every user running the flow will need the license. The trigger of the flow will play an important role.
Understood!! Thanks 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
Thats not an option. You would have to set all the controls in template and only set it when needed based on your conditions.
Is these feature works only on premium version or normal version itself? Because I tried this but unable to save the flow
Its a premium feature
@@RezaDorrani Thank you for your response
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.
Not with one placeholder. The limitation is called out in the documentation.
Hi Reza, Can we able to create a Custom Template using Power Apps (Dynamically have number of word pages and placeholders/columns)
Not create a template, just populating it
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?
I have not explored any option without premium connector so not sure
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?
Populate word template does not support rich text. Check documentation for unsupported controls.
Will it work for updating tables?
updating tables? You mean inserting table data in word.
Yes, there is a repeating table section control.
Hello, can dynamic tables be generated with a non-premium flow? (FROM CHILE ! )
I have not investigated on non-premium options
Hey Reza, can you do the same but with repating images from the image field in a sharepoint list please 😇
Repeating section content control does not support images.
@@RezaDorrani i learned that the hard way 2 years ago. hoped it was better now but seen your reaction its not 😔
@@WaaaghNL Its not a feature yet
Any work around for uploading more than 1 image to a word template without 3rd party connectors ?
Video shows adding 2 images in word template
hey Reza, would it be possible to do something similar with a dataverse ?
Yes
@RezaDorrani - my scenario is that I am trying to keep my Word document in the Dataverse table instead of SPO or OneDrive, but I haven't come up with a solution yet. per the microsoft the 'word to template' action is not supported to work with the Dataverse.
@@enj0i50 Can you show me where in documentation it states that? Share link
@RezaDorrani I am not able to post the a link. TH-cam somehow keeps deleting my comments... Please look for a "How to populate word as a template dynamically from the Dataverse?" There is a topic on the Microsoft Power Automate Community. Somebody was looking for the same solution in 2023.
@@enj0i50 Community forums and official Microsoft documentation are 2 different things.
There is no call out of this action not working with a data source. It has nothing to do with a data source as you simply provide it dynamic data, it will generate the doc and you can save it in any data source of your choice.
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
As long as it works
Pasar un ritchtext que contiene texto e imagenes a un word template is possible
That is a limitation as per the documentation
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 .
The data can come from any data source
Any solution to handle rich text? Thanks!
Rich text control is not supported
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!!
Flow must be in default environment for it to show up.
@@RezaDorrani okay got it now. my org is blocking word connection so i'm kinda stuck... 😒😒
Is it possible to do a repeating section, within a repeating section? I've been trying and failing miserably!
I dont think thats an option
@@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.
@@AssassinUK This is a known limitation