This is an excellent tutorial. Thank you so much for creating it!
@chrismolyneux4577
Жыл бұрын
Great video makes simple sense 😃 Do you know how to do this for images that are uploaded via a Microsoft forms submission? I have been struggling with solving this bit 🙃
@charlesdawnbeltran9603
Жыл бұрын
Very well done and easy to follow. I just a question. Is it possible to populate sharepoint picture attachments into the table cells?
@davebrew8224
11 ай бұрын
Your video was so helpful, thanks so much. I really like the gospel library icon on the toolbar :)
@rreukauf
Жыл бұрын
Hi Ben, great video. I am new to Power Automate so this is extremely helpful. I have stored images (2 image fields for each record (Before and After)) in a sharepoint list that I would like to add to my word document (and PDF). I am struggling to understand how I can grab those because they don't show up in the dynamic content.
@BalakrishnaMarothu
4 ай бұрын
This is really helpful. Though the input for the repeating content control is sorted, the control is displaying the data in random order. Could you please let me know how we can make it order.
@josephbeaulieu4093
Жыл бұрын
Really great work here. Thank you for the insight!
@ShogaZerihun
2 жыл бұрын
Ben thank you for sharing this tutorial. But for some reason, Word couldn't get the data from the SharePoint list with a drop-down for multiple selections. Any idea about that?
@DeceptiveDesigns1
Жыл бұрын
I have a PDF Form, I want to add drop down menus to it, and based on the selection it only gives certain answers in other sections, or autofill's sections based on answers
@ronnapoj
Жыл бұрын
How to create your "Invoice" power apps in the last of your video to fill data in your share point?
@zhelinwang1716
11 ай бұрын
Hi Ben , it is so great job . I have a question ,is there a solution to add more dynamic images in the table .thanks .
@navarrocloud
Жыл бұрын
Very good info, thanks for sharing.
@JeevanKumar-ir3io
6 ай бұрын
Hi Great video and thanks for the detailed explanation. However, could you please explain how to convert populated word document in SharePoint to Pdf. I tried with "Convert Word Document to PDF" and it is not working. Kindly help.
@rehanzahid759
7 ай бұрын
I have few questions and I will be highly obliged if you answer those questions. 1. What if we need to populate a word document template from excel. Based on excel cell values, we need to skip few pages from the word document template. Is it possible to do using Power Automate? 2. Is it possible to do this using word document template residing in desktop and excel file residing in desktop instead of sharepoint. Thanking you in anticipation.
@sovereignsp
7 ай бұрын
Great questions! As long as you add the fields as I do in the video, it doesn't matter where they are in the document, so yes, it "skip a few pages". As for the excel file, you'd technically need to use a desktop flow to get data from an excel file that is on your desktop, but you could use OneDrive instead of SharePoint and still do a Cloud flow (the type of Power Automate flow I use in the video). let me know if you have any other questions or need anymore help on this, I'd love to help!
@manilaabrham191
2 жыл бұрын
this just doesn't work. i select the site where i saved the word document. but i couldn't find the list. either you skip a very important part in this video or i do not understand..... i was very excited to try this.... :(
@ederjimenez8
2 ай бұрын
Hi! I´d like to know if I can do the same with Power Automate Desktop version, I´m traying to replicate the same example but repeating section does not appear on populate word template action on PA Desktop. Thanks for your help
@sovereignsp
2 ай бұрын
Great question! I would imagine it would be a little difficult then with desktop, I’ll look into that and will let you know, but is there a reason you can’t/don’t want to use a cloud flow to do this instead?
@ederjimenez8
2 ай бұрын
@@sovereignsp thanks for your answer, the main reason is because I need to generate many dynamics pdf files with a SQL query and putting those files on a onpremise location.
@sovereignsp
2 ай бұрын
@@ederjimenez8 Oh okay, well awesome! Here are my thoughts, hopefully they are helpful: - one option is to use html and create an html file that contains all the data that you would need, then convert that into a PDF. Might take a little more work, but you can make the files how you would need them, with repeating sections/table in html. There's been a few times when I've had to go this route and it works great once you get the html right. - You've probably tried this, but creating a onpremise gateway connection with Power Automate? That could help solve some of the issues related to storing data on premise. Hopefully this is helpful! If you have any more questions, I'd be happy to help.:) Best of luck!
@ederjimenez8
2 ай бұрын
@@sovereignsp Yes, I have an onpremise getaway connection with PA. I ended up solving by using the same way you described on this video. The difference is that my data source is an SQL storage procedure. Of course on cloud version it takes much longer to complete the entire flow. In addition, I had to create a very short PA Desktop flow to download PDF files previously generated. Finally I only need to delete pdf files from OneDrive, cuz I’m not interested in keeping them. THANKS A LOT FOR YOUR SUPPORT👏🏼👍
@sovereignsp
2 ай бұрын
@@ederjimenez8 Yay! Awesome. Glad it worked out!
@A-broken-clay-jar
11 ай бұрын
You deserve more subscribers!
@markherman9561
Жыл бұрын
For whatever reason, image control as a form field does not work in the header. So I just created multiple versions of the word template. In the Populate thte Template action, when you use a variable value for the file, you have to create a dynamicFileSchema since PA doesn't know what fields are being served up.
@goatchart
8 ай бұрын
Thanks for the video Ben. Can you help explain how I can include the same value multiple times in the same document? I have given fields the same name in the document but don't want to have to enter each one several times.
@sovereignsp
8 ай бұрын
Great question! You might just have to enter the same value, but I think you may be able to use bookmarks in word to reference a piece of info in your document. I'm imagining you have a ton of the same field value, so I would add one text input control, set it as a bookmark, then reference that bookmark everywhere else that you need to display that information. I believe that should work, let me know if it doesn't! :)
@lawrencefriedman1924
9 ай бұрын
Hi - I want the user to be able to create their own text via a power app UI and to populate a word document. Some of the text will have numerical values. Is that possible?
@sovereignsp
8 ай бұрын
Yes! Totally possible and very easy to do. Reach out to me at ben.fetters@sovereignsp.com if you have any questions on doing that. :)
@riaanthiart1173
9 ай бұрын
Great video Ben. One question, when creating the Word template and adding the content control properties, you did not use the “Tag” property- other videos I have seen they always recommend adding the same name in the “Tag” property. What is the Tag property used for? Thanks!
@sovereignsp
9 ай бұрын
Thanks! Good question. Usually word will automatically change it to what you name it if you leave it blank, but I believe it shows up in the hint text on the populate a word template action. Either way, I’ve never encountered any troubles with adding it or not if that’s helpful :)
@s961201
5 ай бұрын
Great video - thanks a lot! I have several .jpg files as attachments to my sharepoint list item. Let's say it is photo copy receipts of travel expenses for my travel expense report. Or som photos documenting your invoice lines in this video. Do you know if it would be possible to loop through the attachments and populate the jpeg as a repeating table of pictures?
@sovereignsp
5 ай бұрын
Thanks! Great question and great scenario! images don't work in repeating sections to my knowledge :( But, you can use Adobe Merge PDF and possibly convert the images into a pdf, then merge them all together along with your populated word template if that makes sense?
@paulpattinson2992
Жыл бұрын
I got this working up to a point... all the rows seem to show the first record from the array? Although the array that is being built in the power automate has a different record? Whats going wrong here?
@Unleashedxpower
Жыл бұрын
Hey Ben,when i try to convert the file to PDF in my flow I get a bad request error saying that it could not open the file in order to convert it. Do you know why this may not be working properly? Thank you
@katielux357
7 ай бұрын
HI Ben, thanks for this! do you happen to know how to do this with something that needs to print multiple instances per page? Something like name badges or barcode images.
@sovereignsp
7 ай бұрын
Great question! The repeating section control could possibly handle what you're wanting to do, but I would perhaps try using the Print() or PDF() function in Power Apps. That would more likely be able to handle something complex like that. Feel free to email me at ben.fetters@sovereignsp.com if you'd like anymore guidance with that and I'd be happy to help. :) Sounds like a fun project!
@GagandeepSingh-lz5bg
Жыл бұрын
Is there way to generate rows in word template based on a value of one of the other fields. For example "How many servers required? 2", If value is 2, then I want to show "Server1: test server 1 Server2: test server 2" But if value is 1, then I just want to show "Server1: test server 1".
@xichen2617
8 ай бұрын
is there a way to make "Rich Text Content Control "work in power automate? I want to pass over the rich text from app to word. Thanks.
@sovereignsp
8 ай бұрын
As of right now, I don't believe there is a way! Hopefully one day they'll add that functionality. But, if you're using Power Apps, Power Apps does now have a PDF() and a Print() function if you didn't know all ready, which would allow you to do some formatting etc.
@hannahdaisy6905
6 ай бұрын
I am using the 'convert word document to PDF' action as my document is saved in a SharePoint folder. I'm then using body/itemid to look up the dynamic file but the flow failed at this stage because it could not find the file. Any ideas?
@sovereignsp
6 ай бұрын
I believe you'll just need the file identifier if I remember right instead of the file id (go figure). Let me know if that doesn't work. :)
@hectormorenor.2957
Жыл бұрын
Could you please help me, I want to develop an app like this one, but how did you do that? I mean, do you have another video explaining how to develop the app that trigger the flow? Pleaseee
@bobbirowlett6728
11 ай бұрын
Hi Ben - This is so helpful. Thank you! Along with taking your list items and eventually putting to a PDF - I need to also translate Spanish into English for the PDF. Where would you do that? Would it be in a flow before creating the documents or after they're created? I also need to file the pdf in a specific folder for each list item. Can you help me with these challenges?
@bobbirowlett6728
11 ай бұрын
Thanks - I will try that next week at work, Thanks so much for taking the time to help! @@sovereignsp
@juniorjose06
Жыл бұрын
Thank you so much!!.
@samimirza2506
2 ай бұрын
how do we insert attached file link hyperlink to view file inside the word document which we are populating
@sovereignsp
2 ай бұрын
Are you asking how you can insert a link to a different document? Right now, really the only way to do it is to at the text control and put the link into the control. You can format the text so that it is blue and underlined so that it looks like a link. But, if you convert the document to a PDF, the link will still work really well. Was that what you were asking or am I off?
@frankibarra589
Жыл бұрын
How did you add and remove items to the table from your power apps application. I think you do it with a form based on a sharepoint list. But how did you do that functionality to see the items you added?
@rehanzahid759
7 ай бұрын
Amazing video.
@davidoddy4668
Жыл бұрын
The premium connector for word and pdf. Is this a user account upgrade ? What's the average cost of the sub for office365 with this premium access?
@user-hs1re2sz7h
Жыл бұрын
Good afternoon, how can I add an image to the repeating area of my Word template?
@entrepreneur-income
Жыл бұрын
Hello Ben, How to translate an eBook Word file while keeping all the images in place?
@RachelVHill
10 ай бұрын
I couldn't follow this... There's no "Developer" tab in Word Online. Now what?
@RachelVHill
10 ай бұрын
got it! @@sovereignsp
@s961201
5 ай бұрын
right click on the ribbon and select "edit ribbon settings" or something like that (not sure what it's in English). There you can check off the Developer.
@tonya3308
Жыл бұрын
Does anyone know if there is a limit to the number of repeating controls permissible in a MS Template and Power Automate? I have a need to insert six small tables; however, when I add the Populate MS Word Online template connector in Power Automate it will only allow two of the tables/arrays to be used in the template even though I have six in the template. The total length of the document with all data populated is four pages so its well below the 10MB limit. There isnt any rich text or anything exotic - it would be like in this video example if there were like six categories to include in the invoice template.
@VerenaW-js9gw
Жыл бұрын
Hi Ben, thanks for the tutorial, worked all fine - but I have an issue with the fonts of my word template. As I am using CI confirm fonts, they are gone when word is converted to PDF. Any solution for that? Thanks, V
@alifpurnama3298
Жыл бұрын
in my case error in convert file. id not found from create file
@cl4773
2 жыл бұрын
Hi Ben, Thanks for the tutorial,, its great however I'm not able to test this, because suddenly we are at 29:38, could you make a tutorial or just explain a bit more in detail how you got there? Regards
@cl4773
2 жыл бұрын
@@sovereignsp thanks it worked! But how do I calculate the total amount since I have multiple rows in my invoice-items?
@dellboysnr
2 жыл бұрын
How do you get the Populate Microsoft Word Template (Premium) for PowerApps please
@pamelabrownfield5145
Жыл бұрын
Great video/ excellent content/ one question? How do I store new pdf back to share point
@pamelabrownfield5145
Жыл бұрын
Great that worked 🎉
@pamelabrownfield5145
Жыл бұрын
Could I ask another question? I have a SharePoint form that has attachments in it and I would like to add the link to that attachment into the word template and than to the pdf . Have you done this?
@Henriquez3100
2 ай бұрын
Hi! Not necessary copy file?
@sovereignsp
2 ай бұрын
Hello! If I understand you correctly, are you asking if you can copy the file that the Populate a word template creates?
@maxgrispen9670
Жыл бұрын
Thank you for the tutorial. I have a small problem when my table is bigger than one page. Than the table is splitted in header on first page and table on second page. is there a fix for that?
@maxgrispen9670
Жыл бұрын
Found a fix ;)
@benf2057
2 жыл бұрын
Thx Ben I’m Ben too , seems like most Ben like to be lazy 😂
@nodens30
6 ай бұрын
Great tutorial, but wish you had saved me 20 minutes by saying it needed a premium plugin, that isn't an option for me as I work for a public body.
@sovereignsp
6 ай бұрын
Great point, should've mentioned that!
@DamiensRegicide
4 ай бұрын
This other guy explained without the premium. kzitem.info/news/bejne/1GyEx32PiWVekqwsi=scKMh8V2z7h2I8dW
Пікірлер: 72