Populate a Word Template with Power Automate | How to Tutorial

  Рет қаралды 96,590

Reza Dorrani

Reza Dorrani

Күн бұрын

Пікірлер: 356
@slowberries
@slowberries 11 ай бұрын
I think you might be psychic. Every time I wonder if I can do something you drop exactly the right video.
@RezaDorrani
@RezaDorrani 11 ай бұрын
I read minds :)
@layadog
@layadog 11 ай бұрын
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!
@NandagopalB
@NandagopalB 2 ай бұрын
Exactly 💯
@seanpeters8717
@seanpeters8717 11 ай бұрын
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
@RezaDorrani
@RezaDorrani 11 ай бұрын
Thanks
@dougydoe
@dougydoe 11 ай бұрын
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.
@RezaDorrani
@RezaDorrani 11 ай бұрын
Thanks so much! There is always something new to learn.
@dougydoe
@dougydoe 11 ай бұрын
You're right!!
@14gigigirl
@14gigigirl 10 ай бұрын
You are the best at these videos Reza! Thank you for all the time and effort you put into making them.
@RezaDorrani
@RezaDorrani 10 ай бұрын
Thank You Gina
@sarthakkhanna9903
@sarthakkhanna9903 10 ай бұрын
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!
@RezaDorrani
@RezaDorrani 10 ай бұрын
Glad it helped!
@solarpunk_
@solarpunk_ 11 ай бұрын
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
@RezaDorrani 11 ай бұрын
Thats a planned video 😉
@JB-ch9ws
@JB-ch9ws 8 ай бұрын
@@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?
@RezaDorrani
@RezaDorrani 8 ай бұрын
@@JB-ch9ws kzbin.info/www/bejne/gYfRl4qphJZ5ntUsi=MsvyEYdhGk3dHdOP Deleting conditionally is not an option
@tian_obia
@tian_obia Ай бұрын
Life saver of a video for a big project I have for work, thank you sir!
@RezaDorrani
@RezaDorrani Ай бұрын
You're welcome! Glad it helped!
@juanpablogiraldocarvajal4965
@juanpablogiraldocarvajal4965 Ай бұрын
Amazing video! Thank you so much for sharing it. Greetings from Colombia!
@RezaDorrani
@RezaDorrani Ай бұрын
Most welcome!
@inggomez-allen7920
@inggomez-allen7920 3 ай бұрын
Excellent teaching style- so clear!!!
@RezaDorrani
@RezaDorrani 3 ай бұрын
Many thanks!
@oluwatobiyusuf
@oluwatobiyusuf 10 ай бұрын
The trick with the compose is super smart. Thank you Reza
@RezaDorrani
@RezaDorrani 10 ай бұрын
Most welcome!
@moyo96
@moyo96 11 ай бұрын
Another great one Reza. Thanks!
@RezaDorrani
@RezaDorrani 11 ай бұрын
Awesome!
@SudhirKesharwanispxpertsolutio
@SudhirKesharwanispxpertsolutio 11 ай бұрын
Thank you Reza, very informative videos and enables power apps champion to solve day to day challenges
@RezaDorrani
@RezaDorrani 11 ай бұрын
Most welcome
2 ай бұрын
Amazing videos as always!
@RezaDorrani
@RezaDorrani 2 ай бұрын
Thanks so much
@andreapasutti5867
@andreapasutti5867 3 ай бұрын
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!!!
@RezaDorrani
@RezaDorrani 3 ай бұрын
Most welcome! Thank You for calling it out :)
@gmc111568
@gmc111568 11 ай бұрын
This one is fantastic! Thank you!
@RezaDorrani
@RezaDorrani 11 ай бұрын
You're very welcome!
@shaikhfirdos2723
@shaikhfirdos2723 11 ай бұрын
Thanks Reza, for this most usefull video..🎉❤
@RezaDorrani
@RezaDorrani 11 ай бұрын
Always welcome
@codeaffection10
@codeaffection10 11 ай бұрын
Thanks sir for another helpful video!
@RezaDorrani
@RezaDorrani 11 ай бұрын
Most welcome!
@PANDUANOFFICE25
@PANDUANOFFICE25 11 ай бұрын
Nice video tutorial. Thanks for sharing
@RezaDorrani
@RezaDorrani 11 ай бұрын
Most welcome
@steviesimsii
@steviesimsii 11 ай бұрын
Thank you Reza for continuing to publish content building with the Classic designer.
@RezaDorrani
@RezaDorrani 11 ай бұрын
I covered both modern and classic 😉
@steviesimsii
@steviesimsii 11 ай бұрын
@@RezaDorrani yes, many thanks for still covering the classic 😉
@Maynardjones100
@Maynardjones100 11 ай бұрын
Uggg true. That new design is awful
@sunnykongjl
@sunnykongjl 10 ай бұрын
amazingly well done video!
@RezaDorrani
@RezaDorrani 10 ай бұрын
Thank You
@abdourahmanediallo9430
@abdourahmanediallo9430 4 ай бұрын
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
@RezaDorrani
@RezaDorrani 4 ай бұрын
Thanks! I have already done a video on that - kzbin.info/www/bejne/gYfRl4qphJZ5ntU
@WaliSayed
@WaliSayed 10 ай бұрын
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.
@RezaDorrani
@RezaDorrani 10 ай бұрын
Glad it helped!
@nitinchamroo5748
@nitinchamroo5748 11 ай бұрын
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.
@RezaDorrani
@RezaDorrani 11 ай бұрын
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.
@nitinchamroo5748
@nitinchamroo5748 11 ай бұрын
@@RezaDorrani This video was truly amazing. You are the best Microsoft MVP.
@RezaDorrani
@RezaDorrani 11 ай бұрын
@@nitinchamroo5748 Thanks!
@sheikhmuzammil89
@sheikhmuzammil89 11 ай бұрын
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. 😊
@RezaDorrani
@RezaDorrani 11 ай бұрын
Let’s see the response to this video. I have plans to do more videos with this connector in future.
@fadiahdab
@fadiahdab 11 ай бұрын
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
@RezaDorrani
@RezaDorrani 11 ай бұрын
Premium offers most value. I have done videos with HTML technique as well.
@markjacobson9532
@markjacobson9532 3 ай бұрын
@@RezaDorrani please can you share the link to the html video
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@markjacobson9532 I dont have the link handy. It would be somewhere in my power automate playlist.
@raj7sam
@raj7sam 11 ай бұрын
Superb useful use case . Any plans to make videos on PowerBI too?
@RezaDorrani
@RezaDorrani 11 ай бұрын
No plans on power bi
@william2053
@william2053 11 ай бұрын
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 🤦🏻‍♂️
@RezaDorrani
@RezaDorrani 11 ай бұрын
Most welcome
@alpanapradhan2328
@alpanapradhan2328 4 ай бұрын
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.
@RezaDorrani
@RezaDorrani 4 ай бұрын
You would need to add multiple image content controls for that.
@sankhlayashraj
@sankhlayashraj 11 ай бұрын
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.
@RezaDorrani
@RezaDorrani 11 ай бұрын
Yes, correct. You can run the actions in a loop.
@sankhlayashraj
@sankhlayashraj 11 ай бұрын
Super. Thank you @@RezaDorrani
@majayong-r3n
@majayong-r3n 10 ай бұрын
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?
@RezaDorrani
@RezaDorrani 10 ай бұрын
Thanks so much. Yes, word connector is premium and license will be needed.
@majayong-r3n
@majayong-r3n 10 ай бұрын
Thank you for your answer.
@majayong-r3n
@majayong-r3n 10 ай бұрын
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?
@RezaDorrani
@RezaDorrani 10 ай бұрын
@@majayong-r3n Every user running the flow will need the license. The trigger of the flow will play an important role.
@majayong-r3n
@majayong-r3n 10 ай бұрын
Understood!! Thanks so much!
@vishnu537
@vishnu537 4 күн бұрын
Tq this video helps
@RezaDorrani
@RezaDorrani 4 күн бұрын
Welcome
@dianezpilon2805
@dianezpilon2805 11 ай бұрын
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?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Thanks! Best to rename the file prior to creating file in SharePoint
@dianezpilon2805
@dianezpilon2805 11 ай бұрын
@@RezaDorrani okay, thank you!
@thatonepixel5578
@thatonepixel5578 9 ай бұрын
@@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?
@RezaDorrani
@RezaDorrani 9 ай бұрын
@@thatonepixel5578 possible
@devbataju1726
@devbataju1726 Ай бұрын
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?
@RezaDorrani
@RezaDorrani Ай бұрын
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/
@Fafa101-fnj
@Fafa101-fnj 11 ай бұрын
Hi you make great video, is it possible to use a fingerprint reader on a powerapps application, it would be cool thanks
@RezaDorrani
@RezaDorrani 11 ай бұрын
I am not sure about fingerprinting.
@nobby-green
@nobby-green Ай бұрын
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?
@RezaDorrani
@RezaDorrani Ай бұрын
You would need to use expressions in flow to adjust the date. Check my video on expressions.
@nobby-green
@nobby-green Ай бұрын
@@RezaDorrani thank you for the quick reply. Can you use an expression "Formatdatetime" within the same field? many thanks for your help
@RezaDorrani
@RezaDorrani Ай бұрын
Please check that video. I don't exactly remember the expressions.
@nobby-green
@nobby-green Ай бұрын
@@RezaDorrani Thank you will do
@stretch233
@stretch233 11 ай бұрын
Thanks Reza!
@RezaDorrani
@RezaDorrani 11 ай бұрын
Welcome!
@tahirtahir4937
@tahirtahir4937 11 ай бұрын
Thanks for the video. very informative. can certificate be in pdf format?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Most welcome! The word connector also has a convert to pdf action.
@القرآنوالسنة-ج1ج
@القرآنوالسنة-ج1ج 11 ай бұрын
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)?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Thanks. I have not tried merging docs so not sure about the options.
@MrBond249
@MrBond249 11 ай бұрын
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. 😎
@RezaDorrani
@RezaDorrani 11 ай бұрын
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 😉
@SrijenGupta
@SrijenGupta 23 күн бұрын
Hi @Reza , Great video indeed ! I was working on to create an automated flow which is connected with MS Form responses and populate the template according to user input and then share them a PDF file over email? Can you guide me with any such resources/video if available? The templates can be in both excel / word format
@RezaDorrani
@RezaDorrani 23 күн бұрын
I do not have a video reference on the mentioned scenario. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
@nuraindamia9582
@nuraindamia9582 10 ай бұрын
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.
@RezaDorrani
@RezaDorrani 10 ай бұрын
Attachment in email is the word doc as shown in video.
@mardithpascua8112
@mardithpascua8112 9 сағат бұрын
Hi Reza, why when I tried to download the generated word file, it contains the control tags from the template? is there a way to remove or hide it when from the generated file?
@RezaDorrani
@RezaDorrani 5 сағат бұрын
I have not experienced this issue. You can try downloading the solution shown in video (members only - check video description for details)
@ivandanielacerogonzalez4798
@ivandanielacerogonzalez4798 Ай бұрын
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?
@RezaDorrani
@RezaDorrani Ай бұрын
I'm not aware of other options
@jamie0610
@jamie0610 7 ай бұрын
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?
@RezaDorrani
@RezaDorrani 7 ай бұрын
learn.microsoft.com/en-us/power-platform/admin/power-automate-licensing/faqs#multiplexing
@kumarvelu2920
@kumarvelu2920 7 ай бұрын
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
@RezaDorrani 7 ай бұрын
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.
@kumarvelu2920
@kumarvelu2920 7 ай бұрын
@@RezaDorrani Thank you for swift response. how delete the old one dynamically and to replace new one
@RezaDorrani
@RezaDorrani 7 ай бұрын
@@kumarvelu2920 Use delete file action and then follow same process as shown in video
@divyanair6147
@divyanair6147 11 ай бұрын
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?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Welcome! I have not tried merging documents or pages hence not sure.
@ImGumby49
@ImGumby49 11 ай бұрын
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.
@RezaDorrani
@RezaDorrani 11 ай бұрын
Thanks Randy. Im not aware of any workarounds with standard licensing.
@SamRustagi
@SamRustagi 7 ай бұрын
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!
@RezaDorrani
@RezaDorrani 7 ай бұрын
I don’t remember running into this issue and not sure if there is a limitation
@SamRustagi
@SamRustagi 7 ай бұрын
@@RezaDorrani strange I got it to work in word app as well by replacing the old ones with a new placeholder.😅
@RezaDorrani
@RezaDorrani 7 ай бұрын
@@SamRustagi weird
@coachandeh
@coachandeh 3 ай бұрын
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?
@RezaDorrani
@RezaDorrani 3 ай бұрын
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
@pequadcob2009
@pequadcob2009 2 ай бұрын
Just use an automatic power automate trigger to email when the file is saved to the folder.
@SzGnoTz
@SzGnoTz 11 ай бұрын
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 :) )
@RezaDorrani
@RezaDorrani 11 ай бұрын
Most welcome! Planned - Yes, but priority will be based on demand.
@fayo1997
@fayo1997 11 ай бұрын
Thanks for the video.. Please How do you implement with HTML tags?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Rich text is not a supported control
@Soulebi03
@Soulebi03 6 ай бұрын
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.
@RezaDorrani
@RezaDorrani 6 ай бұрын
The word doc template - read access is enough.
@olaideogungbola8705
@olaideogungbola8705 5 ай бұрын
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
@RezaDorrani
@RezaDorrani 5 ай бұрын
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.
@arkadipghosh
@arkadipghosh 11 ай бұрын
Thank you for this .I need one more help ,how to get the signature image file from dataverse .
@RezaDorrani
@RezaDorrani 11 ай бұрын
I have not tried with getting file content from Dataverse so not sure.
@edrasandradebatistadesousa2973
@edrasandradebatistadesousa2973 8 ай бұрын
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 ?
@RezaDorrani
@RezaDorrani 8 ай бұрын
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
@edrasandradebatistadesousa2973
@edrasandradebatistadesousa2973 8 ай бұрын
@@RezaDorrani thanks
@kumarvelu2920
@kumarvelu2920 8 ай бұрын
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
@RezaDorrani
@RezaDorrani 8 ай бұрын
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
@saikaushik7825
@saikaushik7825 5 күн бұрын
Hi @Reza can you make a video using dynamic file schema in word like one placeholder present in multiple places it should apply in all pages
@RezaDorrani
@RezaDorrani 5 күн бұрын
Every 6-8 months I ask for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets max votes, I will add the topic to my backlog
@knightfury13
@knightfury13 8 ай бұрын
thanks for the great vid.. however ive encountered the image getting rotated. any ideas how to fix that?
@RezaDorrani
@RezaDorrani 8 ай бұрын
I have not experienced any image rotation issues hence not sure
@RohitTheMore
@RohitTheMore 3 ай бұрын
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
@RezaDorrani
@RezaDorrani 3 ай бұрын
I am not aware if hyperlink is supported. Check documentation for the word connector to see whats supported.
@Tango_01
@Tango_01 Ай бұрын
Hello Reza, thank you very much for the video. I am implementing it in Power Apps. The only thing I am struggling with is inserting the generated signature (pen input) into the Word document. The Power Automate flow receives the following string: "data:image/png;base64,iVBORw0KGgoAAAANSUh..." What should I do to make the signature visible? I get an error when passing it as a parameter to the picture content control. This is the error: "Error Action 'Populate_a_Microsoft_Word_template' failed The image is not of type PNG or JPG. Please provide an image of type PNG or JPG." I would greatly appreciate your help. Big hug! 🫂
@RezaDorrani
@RezaDorrani Ай бұрын
I do not recollect much of this video. Did I show signature scenario in video?
@Tango_01
@Tango_01 Ай бұрын
@@RezaDorrani Hi Reza, thanks for your answer. You had the signature in an image file (you didn't work with a pen input), you took its file content (binary), and that's how you displayed it in the picture content control of the Word template.
@RezaDorrani
@RezaDorrani Ай бұрын
Then I'm not sure whats the fix for it as the video is the best reference I have. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
@prasadk3828
@prasadk3828 7 ай бұрын
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 :)
@RezaDorrani
@RezaDorrani 7 ай бұрын
kzbin.info/www/bejne/gYfRl4qphJZ5ntU
@SamAnalyst140
@SamAnalyst140 2 күн бұрын
You are a hero Reza, kindly assist me on adding an attachment that i appended to a variable and also the word populated document that i have converted to a pdf in an approval mail attachment please, i want to be able to attach both in the approval mail, thank you
@RezaDorrani
@RezaDorrani 2 күн бұрын
I do not have a video reference on this 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.
@MichaelDeBlasis1369
@MichaelDeBlasis1369 9 ай бұрын
I would like to download this template and flow. is the link still valid? Great video btw. As usual.
@RezaDorrani
@RezaDorrani 9 ай бұрын
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
@OhItsTayleaux
@OhItsTayleaux 7 ай бұрын
Amazing Video! Really help me out a lot! How were you able to set the cursor for the signature?
@RezaDorrani
@RezaDorrani 7 ай бұрын
What time in video did I do that?
@OhItsTayleaux
@OhItsTayleaux 7 ай бұрын
@@RezaDorrani 3:24
@RezaDorrani
@RezaDorrani 7 ай бұрын
@@OhItsTayleaux I simply clicked on that area and added the control. Nothing special.
@mmarath2k7
@mmarath2k7 11 ай бұрын
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
@RezaDorrani
@RezaDorrani 11 ай бұрын
Once file is generated, it is a normal doc. Not sure why its not the same for your scenario.
@mmarath2k7
@mmarath2k7 11 ай бұрын
​@@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 .
@RezaDorrani
@RezaDorrani 11 ай бұрын
@@mmarath2k7 My video is about word populate. Not sure about your scenario.
@patrickcook2296
@patrickcook2296 5 ай бұрын
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.
@patrickcook2296
@patrickcook2296 5 ай бұрын
I will repost in the correct community.
@RezaDorrani
@RezaDorrani 5 ай бұрын
Please post in the community tab where the download link was shared :)
@suryaraochowdarykoduri
@suryaraochowdarykoduri 3 ай бұрын
Is there a simple way to dynamically change the document to populate data. I have many templates with same tags/fields.
@RezaDorrani
@RezaDorrani 3 ай бұрын
I have not explored this scenario hence not sure
@NathanMosher
@NathanMosher 10 ай бұрын
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
@RezaDorrani 10 ай бұрын
Populate word template does not support rich text. Check documentation for unsupported controls.
@jonaskoniger3337
@jonaskoniger3337 7 ай бұрын
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!
@jonaskoniger3337
@jonaskoniger3337 7 ай бұрын
Hi Reza, I found this video on dynamically plugging in the content based on the field name: kzbin.info/www/bejne/l2OmaIWwp7yqbKs The question here is, what happens if a field doesnt contain a value?
@RezaDorrani
@RezaDorrani 7 ай бұрын
Are you in need of a repeating control? If yes, then check kzbin.info/www/bejne/gYfRl4qphJZ5ntUsi=H9skm_J6X_244xMO
@RezaDorrani
@RezaDorrani 7 ай бұрын
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.
@jonaskoniger3337
@jonaskoniger3337 7 ай бұрын
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 ✌️
@RezaDorrani
@RezaDorrani 7 ай бұрын
@@jonaskoniger3337 Im not aware of a solution for this. Try and check on forums.
@Wzxxx
@Wzxxx 3 ай бұрын
Thank You so much!
@RezaDorrani
@RezaDorrani 3 ай бұрын
You're welcome!
@bekingproductions
@bekingproductions 9 ай бұрын
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
@RezaDorrani 9 ай бұрын
Flow must be in default environment for it to show up.
@bekingproductions
@bekingproductions 9 ай бұрын
@@RezaDorrani okay got it now. my org is blocking word connection so i'm kinda stuck... 😒😒
@enakomiya6019
@enakomiya6019 11 ай бұрын
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.
@RezaDorrani
@RezaDorrani 11 ай бұрын
Not with one placeholder. The limitation is called out in the documentation.
@hartmutengel9515
@hartmutengel9515 5 ай бұрын
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....
@RezaDorrani
@RezaDorrani 5 ай бұрын
It’s not a supported feature. I’m not aware of a workaround for it.
@elnazbaghdadi-eu1we
@elnazbaghdadi-eu1we 6 ай бұрын
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?
@RezaDorrani
@RezaDorrani 6 ай бұрын
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
@Ekaluk999
@Ekaluk999 10 ай бұрын
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
@RezaDorrani 10 ай бұрын
You can always convert word to pdf. Check kzbin.info/www/bejne/gYfRl4qphJZ5ntU
@TrisaParker
@TrisaParker 11 ай бұрын
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?
@RezaDorrani
@RezaDorrani 11 ай бұрын
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.
@swapnils6133
@swapnils6133 11 ай бұрын
Hi Reza, this is really good content. Can we do something similar in power point?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Thanks! There is no out of the box action like word for PowerPoint
@anupdutta-m6x
@anupdutta-m6x 9 ай бұрын
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
@RezaDorrani
@RezaDorrani 9 ай бұрын
Thats not an option. You would have to set all the controls in template and only set it when needed based on your conditions.
@saravanasmart1439
@saravanasmart1439 9 ай бұрын
Is these feature works only on premium version or normal version itself? Because I tried this but unable to save the flow
@RezaDorrani
@RezaDorrani 9 ай бұрын
Its a premium feature
@saravanasmart1439
@saravanasmart1439 9 ай бұрын
@@RezaDorrani Thank you for your response
@gilbertpradier
@gilbertpradier 4 ай бұрын
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.
@gilbertpradier
@gilbertpradier 4 ай бұрын
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.
@RezaDorrani
@RezaDorrani 4 ай бұрын
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/
@6Mourning6Star6
@6Mourning6Star6 2 ай бұрын
Is there not a way to do this from the desktop powerautomate? Or does it have to be via the web browser?
@RezaDorrani
@RezaDorrani 2 ай бұрын
This is purely for cloud flows. I'm not aware of options in power automate for desktop
@6Mourning6Star6
@6Mourning6Star6 2 ай бұрын
@@RezaDorrani Dang :/
@ShubhamGupta-zd3hy
@ShubhamGupta-zd3hy 10 ай бұрын
If we have a checkbox in the word documnent and when it's yes in sharepoint that need to also tick in the word .How can we do that ?
@RezaDorrani
@RezaDorrani 10 ай бұрын
learn.microsoft.com/en-us/connectors/wordonlinebusiness/#known-issues-and-limitations
@rubenpuertosmartinez
@rubenpuertosmartinez 9 ай бұрын
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?
@RezaDorrani
@RezaDorrani 9 ай бұрын
I do not have a video reference on this scenario
@rubenpuertosmartinez
@rubenpuertosmartinez 9 ай бұрын
Is it possible?
@RezaDorrani
@RezaDorrani 9 ай бұрын
Not sure
@rubenpuertosmartinez
@rubenpuertosmartinez 9 ай бұрын
Thanks for your video is really useful :)
@rubenpuertosmartinez
@rubenpuertosmartinez 9 ай бұрын
Can we ask for a video with that scenario? Word file saved in One Drive to update a SharePoint list?
@IAmaProgrammers
@IAmaProgrammers 4 ай бұрын
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.
@RezaDorrani
@RezaDorrani 4 ай бұрын
I don’t think that’s an option as flow would not be able to comprehend the content controls.
@stevecarvaines8115
@stevecarvaines8115 4 ай бұрын
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)!
@RezaDorrani
@RezaDorrani 4 ай бұрын
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
@shaggy2408
@shaggy2408 4 ай бұрын
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?
@RezaDorrani
@RezaDorrani 4 ай бұрын
As per documentation, repeater inside repeater is not supported.
@shaggy2408
@shaggy2408 4 ай бұрын
@@RezaDorrani that is really bad... I did also tried to merged the output from that action into one document, but is it not working...
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@shaggy2408 It is a known documented limitation. There may be other premium connectors available that offer this feature. You can explore those options.
@shaggy2408
@shaggy2408 4 ай бұрын
@@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...
@jayshankarchandran321
@jayshankarchandran321 5 ай бұрын
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 .
@RezaDorrani
@RezaDorrani 5 ай бұрын
The data can come from any data source
@AssassinUK
@AssassinUK 4 ай бұрын
Is it possible to do a repeating section, within a repeating section? I've been trying and failing miserably!
@RezaDorrani
@RezaDorrani 4 ай бұрын
I dont think thats an option
@AssassinUK
@AssassinUK 4 ай бұрын
@@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.
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@AssassinUK This is a known limitation
@legendgod
@legendgod 4 ай бұрын
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.
@RezaDorrani
@RezaDorrani 4 ай бұрын
It is not a supported feature. The documentation has the limitations highlighted.
@legendgod
@legendgod 4 ай бұрын
@@RezaDorrani Could you share the document link when you're free. Thanks for prompt reply!
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@legendgod plz check video description
@legendgod
@legendgod 4 ай бұрын
@@RezaDorrani Thanks. See it now "Nested image content controllers are not supported."
@yumyumhotsauce1
@yumyumhotsauce1 9 ай бұрын
thx. will this work if I do the reverse where I have a word doc and use dynamic fields to populate a sharepoint list?
@RezaDorrani
@RezaDorrani 9 ай бұрын
Not sure about options for reverse as I have not come across it in a project scenario
@yumyumhotsauce1
@yumyumhotsauce1 9 ай бұрын
@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
@mardithpascua8112
@mardithpascua8112 9 ай бұрын
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?
@RezaDorrani
@RezaDorrani 9 ай бұрын
I do not have a workaround reference
@d.g.567
@d.g.567 11 ай бұрын
Thank you! Does this approach also work with PPTs?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Not with PPT
@fiontargroup25
@fiontargroup25 10 ай бұрын
Do you have a video showing this when using word on a Apple Mac?
@RezaDorrani
@RezaDorrani 10 ай бұрын
No
@ahmadabukhiran3803
@ahmadabukhiran3803 11 ай бұрын
Thanks Reza , but the populate to word is premium connector ?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Yes
@Hulk-m3x
@Hulk-m3x 11 ай бұрын
Present sir❤
@RezaDorrani
@RezaDorrani 11 ай бұрын
Thanks
@Hulk-m3x
@Hulk-m3x 11 ай бұрын
@@RezaDorrani please upload a video on powerautomate crud operations as well
@RezaDorrani
@RezaDorrani 11 ай бұрын
@@Hulk-m3x
@RezaDorrani
@RezaDorrani 11 ай бұрын
@@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.
@IAmaProgrammers
@IAmaProgrammers 5 ай бұрын
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.
@RezaDorrani
@RezaDorrani 5 ай бұрын
I have not tried the editing scenario. Use case showcased was to generate a finalized doc.
@IAmaProgrammers
@IAmaProgrammers 5 ай бұрын
@@RezaDorrani is there any video you already covered if you are going to check it is possible for the same ?
@RezaDorrani
@RezaDorrani 5 ай бұрын
I dont have one
@ed-salinas-97
@ed-salinas-97 11 ай бұрын
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?
@RezaDorrani
@RezaDorrani 11 ай бұрын
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?
@ed-salinas-97
@ed-salinas-97 11 ай бұрын
@@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.
@RezaDorrani
@RezaDorrani 11 ай бұрын
@@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)
@ed-salinas-97
@ed-salinas-97 11 ай бұрын
@@RezaDorrani Ah, okay. I haven't transitioned to the new Flow Designer yet. Not ready for a change right now. Ha ha!
@amir_aslam07
@amir_aslam07 8 ай бұрын
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
@RezaDorrani
@RezaDorrani 8 ай бұрын
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
@RodDangerKimble
@RodDangerKimble 10 ай бұрын
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
@RezaDorrani 10 ай бұрын
As long as it works
@ThreeDigitIQ
@ThreeDigitIQ 4 ай бұрын
How do you populate repeating sections inside repeating sections (like an array inside and array) ? [ { "PortfolioName": "Portfolio A", "Projects": [ { "ProjectName": "Project 1" }, { "ProjectName": "Project 2" }, { "ProjectName": "Project 3" } ] }, { "PortfolioName": "Portfolio B", "Projects": [ { "ProjectName": "Project 4" }, { "ProjectName": "Project 5" } ] } ] Word seems to allow it, buy Power Automate doesn't recognize the embedded repeating section
@RezaDorrani
@RezaDorrani 4 ай бұрын
Not a supported feature!
Create Dynamic PDFs with Tabular Data using Power Automate
16:41
Reza Dorrani
Рет қаралды 59 М.
Populate a Microsoft Word Template in Power Automate Desktop
4:55
Anders Jensen
Рет қаралды 2,2 М.
1% vs 100% #beatbox #tiktok
01:10
BeatboxJCOP
Рет қаралды 67 МЛН
黑天使只对C罗有感觉#short #angel #clown
00:39
Super Beauty team
Рет қаралды 36 МЛН
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
Populate a Word Template table Dynamically with Power Automate
18:38
Power Automate: How to populate a Word Template 📃
24:10
Pragmatic Works
Рет қаралды 211 М.
Power Automate Beginner Tutorial
54:42
Learnit Training
Рет қаралды 180 М.
Automate Word Templates Like a Pro with Power Automate Desktop
27:15
Populate Word Template with Images using Power Automate
19:35
Dhruvin Shah
Рет қаралды 2,9 М.
How to use Microsoft Power BI - Tutorial for Beginners
27:53
Kevin Stratvert
Рет қаралды 4,2 МЛН
Power Automate: How to Insert Repeating Sections into Word Template
15:38