Populate a Word Template with Power Automate | How to Tutorial

  Рет қаралды 39,066

Reza Dorrani

Reza Dorrani

Күн бұрын

In this step-by-step tutorial, learn how to dynamically populate a Microsoft Word template using Power Automate. This powerful automation can be leveraged in various scenarios for document generation like Invoices, Proposals, Onboarding, etc. Video showcases how to generate word document for certificates of participation for courses.
Follow along as I guide you through the process of creating a Word template, incorporating content controls for both text and images. Harness the full potential of Power Automate to dynamically fill the template with data sourced from a SharePoint list. Additionally, discover how to send the generated word document as an email attachment to the user or save the document to your data source.
Please note that a premium license is required to utilize the Word Online (Business) connector in Power Automate.
Documentation: learn.microsoft.com/en-us/con...
⬇️ Download word template and Power Automate flow ➡️ link in Community Tab for Channel Members (Silver Club 🥈 or higher)
#powerautomate #microsoft #microsoftword #sharepoint
0:00 Introduction to Populating Word Templates with Power Automate
0:38 Create Microsoft Word Template with content controls
4:30 Populate Word Template with Power Automate
9:17 Generate Word Document from SharePoint List data

Пікірлер: 242
@slowberries
@slowberries 4 ай бұрын
I think you might be psychic. Every time I wonder if I can do something you drop exactly the right video.
@RezaDorrani
@RezaDorrani 4 ай бұрын
I read minds :)
@layadog
@layadog 3 ай бұрын
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!
@seanpeters8717
@seanpeters8717 3 ай бұрын
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 3 ай бұрын
Thanks
@14gigigirl
@14gigigirl 3 ай бұрын
You are the best at these videos Reza! Thank you for all the time and effort you put into making them.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Thank You Gina
@sarthakkhanna9903
@sarthakkhanna9903 3 ай бұрын
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 3 ай бұрын
Glad it helped!
@dougydoe
@dougydoe 3 ай бұрын
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 3 ай бұрын
Thanks so much! There is always something new to learn.
@dougydoe
@dougydoe 3 ай бұрын
You're right!!
@moyo96
@moyo96 4 ай бұрын
Another great one Reza. Thanks!
@RezaDorrani
@RezaDorrani 4 ай бұрын
Awesome!
@gmc111568
@gmc111568 4 ай бұрын
This one is fantastic! Thank you!
@RezaDorrani
@RezaDorrani 4 ай бұрын
You're very welcome!
@oluwatobiyusuf
@oluwatobiyusuf 2 ай бұрын
The trick with the compose is super smart. Thank you Reza
@RezaDorrani
@RezaDorrani 2 ай бұрын
Most welcome!
@PANDUANOFFICE25
@PANDUANOFFICE25 4 ай бұрын
Nice video tutorial. Thanks for sharing
@RezaDorrani
@RezaDorrani 4 ай бұрын
Most welcome
@user-tv2of5rg6z
@user-tv2of5rg6z 4 ай бұрын
Thank you Reza, very informative videos and enables power apps champion to solve day to day challenges
@RezaDorrani
@RezaDorrani 4 ай бұрын
Most welcome
@codeaffection10
@codeaffection10 4 ай бұрын
Thanks sir for another helpful video!
@RezaDorrani
@RezaDorrani 4 ай бұрын
Most welcome!
@shaikhfirdos2723
@shaikhfirdos2723 4 ай бұрын
Thanks Reza, for this most usefull video..🎉❤
@RezaDorrani
@RezaDorrani 4 ай бұрын
Always welcome
@sunnykongjl
@sunnykongjl 3 ай бұрын
amazingly well done video!
@RezaDorrani
@RezaDorrani 3 ай бұрын
Thank You
@steviesimsii
@steviesimsii 4 ай бұрын
Thank you Reza for continuing to publish content building with the Classic designer.
@RezaDorrani
@RezaDorrani 4 ай бұрын
I covered both modern and classic 😉
@steviesimsii
@steviesimsii 4 ай бұрын
@@RezaDorrani yes, many thanks for still covering the classic 😉
@Maynardjones100
@Maynardjones100 4 ай бұрын
Uggg true. That new design is awful
@sheikhmuzammil89
@sheikhmuzammil89 4 ай бұрын
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 4 ай бұрын
Let’s see the response to this video. I have plans to do more videos with this connector in future.
@stretch233
@stretch233 4 ай бұрын
Thanks Reza!
@RezaDorrani
@RezaDorrani 4 ай бұрын
Welcome!
@solarpunk_
@solarpunk_ 4 ай бұрын
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 4 ай бұрын
Thats a planned video 😉
@JB-ch9ws
@JB-ch9ws Ай бұрын
@@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 Ай бұрын
@@JB-ch9ws kzbin.info/www/bejne/gYfRl4qphJZ5ntUsi=MsvyEYdhGk3dHdOP Deleting conditionally is not an option
@fadiahdab
@fadiahdab 3 ай бұрын
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 3 ай бұрын
Premium offers most value. I have done videos with HTML technique as well.
@WaliSayed
@WaliSayed 3 ай бұрын
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 3 ай бұрын
Glad it helped!
@william2053
@william2053 4 ай бұрын
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 4 ай бұрын
Most welcome
@rthoughts7232
@rthoughts7232 4 ай бұрын
Superb useful use case . Any plans to make videos on PowerBI too?
@RezaDorrani
@RezaDorrani 4 ай бұрын
No plans on power bi
@Sreekanth297
@Sreekanth297 4 ай бұрын
Present sir❤
@RezaDorrani
@RezaDorrani 4 ай бұрын
Thanks
@Sreekanth297
@Sreekanth297 4 ай бұрын
@@RezaDorrani please upload a video on powerautomate crud operations as well
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@Sreekanth297
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@Sreekanth297 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.
@user-dr9kd5em8k
@user-dr9kd5em8k 4 ай бұрын
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 4 ай бұрын
Thanks. I have not tried merging docs so not sure about the options.
@RodDangerKimble
@RodDangerKimble 3 ай бұрын
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 3 ай бұрын
As long as it works
@nitinchamroo5748
@nitinchamroo5748 4 ай бұрын
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 4 ай бұрын
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 4 ай бұрын
@@RezaDorrani This video was truly amazing. You are the best Microsoft MVP.
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@nitinchamroo5748 Thanks!
@nuraindamia9582
@nuraindamia9582 3 ай бұрын
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 3 ай бұрын
Attachment in email is the word doc as shown in video.
@MrBond249
@MrBond249 3 ай бұрын
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 3 ай бұрын
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 😉
@arkadipghosh
@arkadipghosh 4 ай бұрын
Thank you for this .I need one more help ,how to get the signature image file from dataverse .
@RezaDorrani
@RezaDorrani 4 ай бұрын
I have not tried with getting file content from Dataverse so not sure.
@andriharii
@andriharii 4 ай бұрын
i love classic designer
@RezaDorrani
@RezaDorrani 4 ай бұрын
Ok
@sankhlayashraj
@sankhlayashraj 4 ай бұрын
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 4 ай бұрын
Yes, correct. You can run the actions in a loop.
@sankhlayashraj
@sankhlayashraj 4 ай бұрын
Super. Thank you @@RezaDorrani
@SzGnoTz
@SzGnoTz 4 ай бұрын
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 4 ай бұрын
Most welcome! Planned - Yes, but priority will be based on demand.
@FhackerMDG
@FhackerMDG 4 ай бұрын
Hi you make great video, is it possible to use a fingerprint reader on a powerapps application, it would be cool thanks
@RezaDorrani
@RezaDorrani 4 ай бұрын
I am not sure about fingerprinting.
@tahirtahir4937
@tahirtahir4937 4 ай бұрын
Thanks for the video. very informative. can certificate be in pdf format?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Most welcome! The word connector also has a convert to pdf action.
@fayo1997
@fayo1997 4 ай бұрын
Thanks for the video.. Please How do you implement with HTML tags?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Rich text is not a supported control
@swapnils6133
@swapnils6133 4 ай бұрын
Hi Reza, this is really good content. Can we do something similar in power point?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Thanks! There is no out of the box action like word for PowerPoint
@saurabhsaxena9970
@saurabhsaxena9970 4 ай бұрын
Some more usecase of copilot powerapps/powerautomate will help if you can make videos on that
@RezaDorrani
@RezaDorrani 4 ай бұрын
Let’s see. I have a lot of videos planned. Week by week Il release them.
@OhItsTayleaux
@OhItsTayleaux 11 күн бұрын
Amazing Video! Really help me out a lot! How were you able to set the cursor for the signature?
@RezaDorrani
@RezaDorrani 11 күн бұрын
What time in video did I do that?
@OhItsTayleaux
@OhItsTayleaux 11 күн бұрын
@@RezaDorrani 3:24
@RezaDorrani
@RezaDorrani 11 күн бұрын
@@OhItsTayleaux I simply clicked on that area and added the control. Nothing special.
@d.g.567
@d.g.567 4 ай бұрын
Thank you! Does this approach also work with PPTs?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Not with PPT
@kumarvelu2920
@kumarvelu2920 22 күн бұрын
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 22 күн бұрын
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
@ImGumby49
@ImGumby49 3 ай бұрын
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 3 ай бұрын
Thanks Randy. Im not aware of any workarounds with standard licensing.
@jamie0610
@jamie0610 4 күн бұрын
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 4 күн бұрын
learn.microsoft.com/en-us/power-platform/admin/power-automate-licensing/faqs#multiplexing
@knightfury13
@knightfury13 Ай бұрын
thanks for the great vid.. however ive encountered the image getting rotated. any ideas how to fix that?
@RezaDorrani
@RezaDorrani Ай бұрын
I have not experienced any image rotation issues hence not sure
@divyanair6147
@divyanair6147 4 ай бұрын
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 4 ай бұрын
Welcome! I have not tried merging documents or pages hence not sure.
@dianezpilon2805
@dianezpilon2805 3 ай бұрын
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 3 ай бұрын
Thanks! Best to rename the file prior to creating file in SharePoint
@dianezpilon2805
@dianezpilon2805 3 ай бұрын
@@RezaDorrani okay, thank you!
@thatonepixel5578
@thatonepixel5578 2 ай бұрын
@@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 2 ай бұрын
@@thatonepixel5578 possible
@Ekaluk999
@Ekaluk999 2 ай бұрын
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 2 ай бұрын
You can always convert word to pdf. Check kzbin.info/www/bejne/gYfRl4qphJZ5ntU
@ed-salinas-97
@ed-salinas-97 4 ай бұрын
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 4 ай бұрын
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 4 ай бұрын
@@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 4 ай бұрын
@@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 4 ай бұрын
@@RezaDorrani Ah, okay. I haven't transitioned to the new Flow Designer yet. Not ready for a change right now. Ha ha!
@yumyumhotsauce1
@yumyumhotsauce1 2 ай бұрын
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 2 ай бұрын
Not sure about options for reverse as I have not come across it in a project scenario
@yumyumhotsauce1
@yumyumhotsauce1 2 ай бұрын
@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
@AnupDutta123
@AnupDutta123 2 ай бұрын
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 2 ай бұрын
Thats not an option. You would have to set all the controls in template and only set it when needed based on your conditions.
@MichaelDeBlasis1369
@MichaelDeBlasis1369 Ай бұрын
I would like to download this template and flow. is the link still valid? Great video btw. As usual.
@RezaDorrani
@RezaDorrani Ай бұрын
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
@mardithpascua8112
@mardithpascua8112 Ай бұрын
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 Ай бұрын
I do not have a workaround reference
@gerarddebrun7712
@gerarddebrun7712 2 ай бұрын
Do you have a video showing this when using word on a Apple Mac?
@RezaDorrani
@RezaDorrani 2 ай бұрын
No
@ahmadabukhiran3803
@ahmadabukhiran3803 4 ай бұрын
Thanks Reza , but the populate to word is premium connector ?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Yes
@TrisaParker
@TrisaParker 3 ай бұрын
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 3 ай бұрын
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.
@prasadk3828
@prasadk3828 8 күн бұрын
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 8 күн бұрын
kzbin.info/www/bejne/gYfRl4qphJZ5ntU
@kumarvelu2920
@kumarvelu2920 9 күн бұрын
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 9 күн бұрын
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 9 күн бұрын
@@RezaDorrani Thank you for swift response. how delete the old one dynamically and to replace new one
@RezaDorrani
@RezaDorrani 9 күн бұрын
@@kumarvelu2920 Use delete file action and then follow same process as shown in video
@videobewerker111
@videobewerker111 4 ай бұрын
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?
@RezaDorrani
@RezaDorrani 4 ай бұрын
I have not explored any option without premium connector so not sure
@NathanMosher
@NathanMosher 3 ай бұрын
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 3 ай бұрын
Populate word template does not support rich text. Check documentation for unsupported controls.
@oddreonuhh
@oddreonuhh 2 ай бұрын
thanks! any luck with populated rich text?
@RezaDorrani
@RezaDorrani 2 ай бұрын
Welcome! Rich text is not supported as per documentation
@ganeshroyal7281
@ganeshroyal7281 4 ай бұрын
Hi Reza, Can we able to create a Custom Template using Power Apps (Dynamically have number of word pages and placeholders/columns)
@RezaDorrani
@RezaDorrani 4 ай бұрын
Not create a template, just populating it
@enakomiya6019
@enakomiya6019 4 ай бұрын
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 4 ай бұрын
Not with one placeholder. The limitation is called out in the documentation.
@user-br4hb9nj6r
@user-br4hb9nj6r 2 ай бұрын
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 2 ай бұрын
Thanks so much. Yes, word connector is premium and license will be needed.
@user-br4hb9nj6r
@user-br4hb9nj6r 2 ай бұрын
Thank you for your answer.
@user-br4hb9nj6r
@user-br4hb9nj6r 2 ай бұрын
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 2 ай бұрын
@@user-br4hb9nj6r Every user running the flow will need the license. The trigger of the flow will play an important role.
@user-br4hb9nj6r
@user-br4hb9nj6r 2 ай бұрын
Understood!! Thanks so much!
@edrasandradebatistadesousa2973
@edrasandradebatistadesousa2973 Ай бұрын
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 Ай бұрын
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 Ай бұрын
@@RezaDorrani thanks
@davidoddy4668
@davidoddy4668 4 ай бұрын
Any work around for uploading more than 1 image to a word template without 3rd party connectors ?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Video shows adding 2 images in word template
@renaissancecourtseniorcent8498
@renaissancecourtseniorcent8498 2 ай бұрын
Is it possible to use microsoft forms responses to autopopulate forms?
@RezaDorrani
@RezaDorrani 2 ай бұрын
Yes
@ricardofreestyle2278
@ricardofreestyle2278 4 ай бұрын
Hello, can dynamic tables be generated with a non-premium flow? (FROM CHILE ! )
@RezaDorrani
@RezaDorrani 4 ай бұрын
I have not investigated on non-premium options
@surajkumbhar113
@surajkumbhar113 4 ай бұрын
Any solution to handle rich text? Thanks!
@RezaDorrani
@RezaDorrani 4 ай бұрын
Rich text control is not supported
@raslaankhan5146
@raslaankhan5146 4 ай бұрын
Thanks Reza. Its a shame Word online action is a premium connector.
@RezaDorrani
@RezaDorrani 4 ай бұрын
There is no shame in being a premium connector as long as it offers value.
@rockabillyron
@rockabillyron 4 ай бұрын
Yes there is. It's a Microsoft connector... Why is excel included but word isn't? Why is converting a Word file to PDF within Word (by printing), but is the Word to PDF in P.A. suddenly a Premium?
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@rockabillyron Word connector has been premium since day 1 as far as I know
@raslaankhan5146
@raslaankhan5146 4 ай бұрын
@@rockabillyron I agree. It is a shame, because organisation is already paying for these apps. Just to connect them we need to pay more.
@WaaaghNL
@WaaaghNL 4 ай бұрын
Hey Reza, can you do the same but with repating images from the image field in a sharepoint list please 😇
@RezaDorrani
@RezaDorrani 4 ай бұрын
Repeating section content control does not support images.
@WaaaghNL
@WaaaghNL 4 ай бұрын
@@RezaDorrani i learned that the hard way 2 years ago. hoped it was better now but seen your reaction its not 😔
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@WaaaghNL Its not a feature yet
@SteckerlAcerosWeb
@SteckerlAcerosWeb 18 күн бұрын
Hi! How can I do the same with Power Automate Desktop? Thanks in advance for your help.🤗
@RezaDorrani
@RezaDorrani 18 күн бұрын
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
@elkinleguizamon779
@elkinleguizamon779 Ай бұрын
Pasar un ritchtext que contiene texto e imagenes a un word template is possible
@RezaDorrani
@RezaDorrani Ай бұрын
That is a limitation as per the documentation
@ShubhamGupta-zd3hy
@ShubhamGupta-zd3hy 3 ай бұрын
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 3 ай бұрын
learn.microsoft.com/en-us/connectors/wordonlinebusiness/#known-issues-and-limitations
@therisingsun4828
@therisingsun4828 4 ай бұрын
The Populate a Word Template action is not working for me. I have searched the community forums but to no avail. Thanks for the video, though. In theory, it should work.
@RezaDorrani
@RezaDorrani 4 ай бұрын
It does work :) Not sure what your issue is related to.
@bekingproductions
@bekingproductions Ай бұрын
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 Ай бұрын
Flow must be in default environment for it to show up.
@bekingproductions
@bekingproductions Ай бұрын
@@RezaDorrani okay got it now. my org is blocking word connection so i'm kinda stuck... 😒😒
@manojarajaram529
@manojarajaram529 4 ай бұрын
Will it work for updating tables?
@RezaDorrani
@RezaDorrani 4 ай бұрын
updating tables? You mean inserting table data in word. Yes, there is a repeating table section control.
@mmarath2k7
@mmarath2k7 3 ай бұрын
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 3 ай бұрын
Once file is generated, it is a normal doc. Not sure why its not the same for your scenario.
@mmarath2k7
@mmarath2k7 3 ай бұрын
​@@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 3 ай бұрын
@@mmarath2k7 My video is about word populate. Not sure about your scenario.
@saravanasmart1439
@saravanasmart1439 2 ай бұрын
Is these feature works only on premium version or normal version itself? Because I tried this but unable to save the flow
@RezaDorrani
@RezaDorrani 2 ай бұрын
Its a premium feature
@saravanasmart1439
@saravanasmart1439 2 ай бұрын
@@RezaDorrani Thank you for your response
@TheCarter117Gaming
@TheCarter117Gaming 4 ай бұрын
I wish there was a way to get data OUT of a word document, after you have made the document using it. Like if someone updates it or whatever… be able to pull that back out in json format
@RezaDorrani
@RezaDorrani 4 ай бұрын
Thats a completely different scenario. May be some day in future I may try that.
@TheCarter117Gaming
@TheCarter117Gaming 4 ай бұрын
@@RezaDorrani yea, it looks like you have to unzip the word document and work with the document.xml file… but then you have to do xpath and know what all the tags are to traverse the xml. Looks very complicated from the research ive done thus far.
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@TheCarter117Gaming It will be complex
@amir_aslam07
@amir_aslam07 25 күн бұрын
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 24 күн бұрын
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
@jesusjohanncarrascoaguilar8449
@jesusjohanncarrascoaguilar8449 3 ай бұрын
Podrías enseñar porfas que también lo convierta en pdf
@RezaDorrani
@RezaDorrani 3 ай бұрын
Coming in my next video
@rubenpuertosmartinez
@rubenpuertosmartinez 2 ай бұрын
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 2 ай бұрын
I do not have a video reference on this scenario
@rubenpuertosmartinez
@rubenpuertosmartinez Ай бұрын
Is it possible?
@RezaDorrani
@RezaDorrani Ай бұрын
Not sure
@rubenpuertosmartinez
@rubenpuertosmartinez Ай бұрын
Thanks for your video is really useful :)
@rubenpuertosmartinez
@rubenpuertosmartinez Ай бұрын
Can we ask for a video with that scenario? Word file saved in One Drive to update a SharePoint list?
@user-ne9yn5kz4u
@user-ne9yn5kz4u 4 ай бұрын
Hi Reza Dorrani sir, Good Afternoon!! I have a list of assets with a column named "Office Location" containing values such as Delhi, Bangalore and Mumbai. I also have another list named "Roles" which contains two columns: "User" and "Location". The data Presented shows that for the same user, let's say "Raju" we have different locations such as Delhi, Bangalore, Mumbai and so on. My requirement is to use a gallery control to display data where the office locations from the assets list match with the locations present in the roles list. Please give me Answer for my requirement ASAP. Thanks & Regards, Sanjam Ugandhar.
@RezaDorrani
@RezaDorrani 4 ай бұрын
I do not have any video references on your requirement. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@manikantamorla6058
@manikantamorla6058 4 ай бұрын
Can we do from dataverse?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Yes
@wasif2454
@wasif2454 4 ай бұрын
can we send this Word as a PDF file type ?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Yes! Il show you in my next video 😉
@enj0i50
@enj0i50 4 ай бұрын
hey Reza, would it be possible to do something similar with a dataverse ?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Yes
@enj0i50
@enj0i50 4 ай бұрын
​ @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
@RezaDorrani 4 ай бұрын
@@enj0i50 Can you show me where in documentation it states that? Share link
@enj0i50
@enj0i50 4 ай бұрын
@RezaDorrani I am not able to post the a link. KZbin 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.
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@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.
@yogeshm8344
@yogeshm8344 3 ай бұрын
Hi @Reza Rich text is not working for me, When using a rich text content control.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Its not working for me either as it is not a supported control. Check documentation
@yogeshm8344
@yogeshm8344 3 ай бұрын
@@RezaDorrani yah..it is a limitation. Is there any other way to convert HTML to Word in power automate apart from third party
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@yogeshm8344 I’m not aware of any other way
@yogeshm8344
@yogeshm8344 3 ай бұрын
@@RezaDorrani ok thanks
@MatthewShimmin
@MatthewShimmin 2 ай бұрын
How do I do this step but fill the form via information inputted from a powerapp? So Powerapp > Word Doc ? I am very lost
@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 or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@beladuarte9218
@beladuarte9218 2 ай бұрын
How to insert line breaks?
@RezaDorrani
@RezaDorrani 2 ай бұрын
I dont think that is supported
@tahasair1336
@tahasair1336 3 ай бұрын
i have a problem with the image when my document is generated it d'ont show the image and instead i have a message : "Impossible to charge the image" what can i do ?
@RezaDorrani
@RezaDorrani 3 ай бұрын
I have not come across this and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@tahasair1336
@tahasair1336 3 ай бұрын
The problem was that my image was in the header of my word document not sure why that didn’t work but when i used in in the body it worked 👍 thank u for your reply ❤
@belicoid6810
@belicoid6810 3 ай бұрын
6:04 But you're manually filling in the template in the flow
@RezaDorrani
@RezaDorrani 3 ай бұрын
Your right. That’s because step 1 was to show how to populate from flow and step 2 (later in video) is how to populate it dynamically.
@Vishal-cj8un
@Vishal-cj8un 2 ай бұрын
Is this a free connector?
@RezaDorrani
@RezaDorrani 2 ай бұрын
No
@Vishal-cj8un
@Vishal-cj8un 2 ай бұрын
@@RezaDorraniIs there any free solution which can take data from a excel source and update word files and then covert them into multiple PDF files. My organisation don't have a premium licence 😔
@RezaDorrani
@RezaDorrani 2 ай бұрын
@@Vishal-cj8un I am not aware of any
@pooptommy123
@pooptommy123 Ай бұрын
is there a way to generate the word template from data in an excel sheet stored in SharePoint?
@RezaDorrani
@RezaDorrani Ай бұрын
Should be possible
Create Microsoft Word templates for SharePoint
0:32
Trevor Beck
Рет қаралды 4,8 М.
1❤️#thankyou #shorts
00:21
あみか部
Рет қаралды 88 МЛН
OMG😳 #tiktok #shorts #potapova_blog
00:58
Potapova_blog
Рет қаралды 3,8 МЛН
Always be more smart #shorts
00:32
Jin and Hattie
Рет қаралды 36 МЛН
Create Dynamic PDFs with Tabular Data using Power Automate
16:41
Reza Dorrani
Рет қаралды 38 М.
Power Automate: How to populate a Word Template 📃
24:10
Pragmatic Works
Рет қаралды 177 М.
Populate a Word Template table Dynamically with Power Automate
18:38
Andrew Hess - MySPQuestions
Рет қаралды 8 М.
How to do Mail Merge in Power Automate (Full Tutorial)
20:22
Anders Jensen
Рет қаралды 9 М.
Document preview in Power Apps | The easy method
1:54
Solutionm8
Рет қаралды 1,7 М.
How to Create a Document Approval Workflow with SharePoint & Power Automate
17:42
NEW FORMS Experience for Microsoft Lists | Full Tutorial
9:42
Reza Dorrani
Рет қаралды 39 М.
Power Automate - From SharePoint to Word
19:26
Enea Liçaj
Рет қаралды 38 М.
Power Apps V2 in Power Automate Populating a Word Template
8:59
Andrew Hess - MySPQuestions
Рет қаралды 7 М.
Main filter..
0:15
CikoYt
Рет қаралды 12 МЛН
iPhone 12 socket cleaning #fixit
0:30
Tamar DB (mt)
Рет қаралды 53 МЛН
YOTAPHONE 2 - СПУСТЯ 10 ЛЕТ
15:13
ЗЕ МАККЕРС
Рет қаралды 110 М.
В России ускорили интернет в 1000 раз
0:18
Короче, новости
Рет қаралды 349 М.