Пікірлер
@eternalnullity
@eternalnullity 9 күн бұрын
That piece of random gibberish you removed is actually a HTML code for "space" :D
@rameshkanason4577
@rameshkanason4577 12 күн бұрын
Saved me after 3years...great
@stevenmicah8558
@stevenmicah8558 25 күн бұрын
You're a life saver! This is the best tutorial: Clear, gives a lot of context to help understand why the system does what it does, and easy to follow! Thanks to you, my flow now works like a charm! Thank you so much!! Subbed!
@sovereignsp
@sovereignsp 22 күн бұрын
Yay! That's the best thing to hear. So glad it helped! :)
@Henriquez3100
@Henriquez3100 Ай бұрын
Hi! Not necessary copy file?
@sovereignsp
@sovereignsp Ай бұрын
Hello! If I understand you correctly, are you asking if you can copy the file that the Populate a word template creates?
@ederjimenez8
@ederjimenez8 Ай бұрын
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
@sovereignsp Ай бұрын
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
@ederjimenez8 Ай бұрын
@@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
@sovereignsp Ай бұрын
@@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
@ederjimenez8 Ай бұрын
@@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
@sovereignsp Ай бұрын
@@ederjimenez8 Yay! Awesome. Glad it worked out!
@samimirza2506
@samimirza2506 Ай бұрын
how do we insert attached file link hyperlink to view file inside the word document which we are populating
@sovereignsp
@sovereignsp Ай бұрын
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?
@mattramsey5885
@mattramsey5885 3 ай бұрын
Easy to follow! Thanks for the video.
@sovereignsp
@sovereignsp 3 ай бұрын
You bet, glad you liked it!
@BalakrishnaMarothu
@BalakrishnaMarothu 3 ай бұрын
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.
@JessicaEricaPrudencio
@JessicaEricaPrudencio 3 ай бұрын
how about getting a file from a link
@s961201
@s961201 4 ай бұрын
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
@sovereignsp 4 ай бұрын
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?
@JeevanKumar-ir3io
@JeevanKumar-ir3io 5 ай бұрын
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.
@TheJohnForrest
@TheJohnForrest 5 ай бұрын
Essentially the same solution as many other written examples except this one made sense!!! Thank You!!!
@sovereignsp
@sovereignsp 5 ай бұрын
Huzzah! Glad it helped!
@nodens30
@nodens30 5 ай бұрын
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
@sovereignsp 5 ай бұрын
Great point, should've mentioned that!
@DamiensRegicide
@DamiensRegicide 3 ай бұрын
This other guy explained without the premium. kzfaq.info/get/bejne/qZx-lKyKtZmRj6s.htmlsi=scKMh8V2z7h2I8dW
@hannahdaisy6905
@hannahdaisy6905 5 ай бұрын
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
@sovereignsp 5 ай бұрын
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. :)
@Alex-dk1um
@Alex-dk1um 5 ай бұрын
Legit was looking to figure this out and your video popped up! :D
@sovereignsp
@sovereignsp 5 ай бұрын
Nice!
@mattb4172
@mattb4172 6 ай бұрын
Thanks heaps, mate.
@sovereignsp
@sovereignsp 6 ай бұрын
You bet, glad it was helpful!
@rehanzahid759
@rehanzahid759 6 ай бұрын
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
@sovereignsp 6 ай бұрын
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!
@rehanzahid759
@rehanzahid759 6 ай бұрын
Amazing video.
@katielux357
@katielux357 6 ай бұрын
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
@sovereignsp 6 ай бұрын
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 [email protected] if you'd like anymore guidance with that and I'd be happy to help. :) Sounds like a fun project!
@xichen2617
@xichen2617 7 ай бұрын
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
@sovereignsp 7 ай бұрын
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.
@goatchart
@goatchart 7 ай бұрын
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
@sovereignsp 7 ай бұрын
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
@lawrencefriedman1924 7 ай бұрын
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
@sovereignsp 7 ай бұрын
Yes! Totally possible and very easy to do. Reach out to me at [email protected] if you have any questions on doing that. :)
@riaanthiart1173
@riaanthiart1173 8 ай бұрын
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
@sovereignsp 8 ай бұрын
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 :)
@jessandrews9576
@jessandrews9576 8 ай бұрын
fab! easy to follow! thank you
@sovereignsp
@sovereignsp 8 ай бұрын
Oh good! Glad you liked it!
@shadowmage19
@shadowmage19 9 ай бұрын
Does this work with o365 security groups? or just groups created in your sharepoint environment
@sovereignsp
@sovereignsp 6 ай бұрын
It should just work with the groups created in your SharePoint environment, good question!
@RachelVHill
@RachelVHill 9 ай бұрын
I couldn't follow this... There's no "Developer" tab in Word Online. Now what?
@RachelVHill
@RachelVHill 9 ай бұрын
got it! @@sovereignsp
@s961201
@s961201 4 ай бұрын
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.
@GamingisourDestiny
@GamingisourDestiny 9 ай бұрын
Hi there, Watched your video regarding breaking the inheritance. And wanted to tell you it was really helpful to me. But i've a question regarding this. i wanted to know if it's possible to break the inheritance for owners too. For example: Owners have full control but I want their permissions to read only for a particular item in the list.
@GamingisourDestiny
@GamingisourDestiny 9 ай бұрын
@@sovereignsp Thanks for the reply, Ben.
@davebrew8224
@davebrew8224 10 ай бұрын
Your video was so helpful, thanks so much. I really like the gospel library icon on the toolbar :)
@notorioussamurai1671
@notorioussamurai1671 10 ай бұрын
Hello, have you tried changer flow which changes all users of the file from Edit to View permissions? It seems to work way from View to Edit but doesnt do ANYTHING from edit to view. And Powerautomate doesnt write an error it grants the View permission in the flow... Any ideas? I tried Stop sharing in the loop, but we have many persons on one file and then the loop doesnt work for this case.
@abdielruiz1332
@abdielruiz1332 10 ай бұрын
just in case you want to do this effect on an image all you have to do is go to the image Transparency property and go like this: 1- (timer1.value/timer1.duration) it took me like 2 hours to figure this out... hope it helps
@zhelinwang1716
@zhelinwang1716 10 ай бұрын
Hi Ben , it is so great job . I have a question ,is there a solution to add more dynamic images in the table .thanks .
@qww760
@qww760 10 ай бұрын
You deserve more subscribers!
@bobbirowlett6728
@bobbirowlett6728 10 ай бұрын
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
@bobbirowlett6728 10 ай бұрын
Thanks - I will try that next week at work, Thanks so much for taking the time to help! @@sovereignsp
@firmhand
@firmhand 10 ай бұрын
pretty cumbersome to do it for every flow, I wish there was a real dashboard with notification capabilities. Something that looks like the one build it from the beginning of the video
@juniorjose06
@juniorjose06 11 ай бұрын
Thank you so much!!.
@aabestebreurtje
@aabestebreurtje 11 ай бұрын
Works perfect! Thanks!!
@DeceptiveDesigns1
@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
@robertobirrer9976
@robertobirrer9976 Жыл бұрын
Great Video - helped a lot! Thank you very much 🙂
@thabisoshai
@thabisoshai Жыл бұрын
thank you! super helpful
@sonalichoudhury_jobseeker
@sonalichoudhury_jobseeker Жыл бұрын
it was the simple yet effective procedure.. thanks for sharing 🤩🤩
@patrickleavydatadrivenfina1491
@patrickleavydatadrivenfina1491 Жыл бұрын
Thank you! this sorts out my power automate flow - very helpful!
@lukaszsl
@lukaszsl Жыл бұрын
Thanks, still relevant ;)
@dummy020
@dummy020 Жыл бұрын
Spent a week figuring out links in Power Automate and this is the only solution that worked. Thank You!!!
@kathyrowland8751
@kathyrowland8751 Жыл бұрын
Hey Ben! I came across your very helpful video when looking for a way to change permissions for a SharePoint group across multiple sites. I have about 40 sites where a SP group is used on all those sites. Currently the group has Edit rights and I want to change to Contribute rights. The change is not specific to a list or library, but everywhere that SP group is used. I set the workflow to use a manual trigger. Using the HTTP Request, I was able to get the ID of the group (_api/web/sitegroups/getbyname('Group Name Members')), use a Parse JSON to extract the ID, and then finally use a second HTTP Request to Post the change (_api/web/roleassignments/addroleassignment(principalID=@{body('Parse_JSON')?['body']?['d']?['Id']},roledefid=1073741827), but am getting the error "web/roleassignments/addroleassignment(principalID=,roledefid=1073741827)" is not valid. In the error message, the principalID is blank. Do you have any recommendations?
@pamelabrownfield5145
@pamelabrownfield5145 Жыл бұрын
Great video/ excellent content/ one question? How do I store new pdf back to share point
@pamelabrownfield5145
@pamelabrownfield5145 Жыл бұрын
Great that worked 🎉
@pamelabrownfield5145
@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?
@mirrrvelll5164
@mirrrvelll5164 Жыл бұрын
Is there any workaround if I receive a downloadable link in Outlook and then to open it (save it) in certain folder? Or if you know some links where I can find it. Thx
@user-hs1re2sz7h
@user-hs1re2sz7h Жыл бұрын
Good afternoon, how can I add an image to the repeating area of my Word template?
@julioalmeida7858
@julioalmeida7858 Жыл бұрын
Very good!
@beaucopeland243
@beaucopeland243 Жыл бұрын
Is there a way to automate the "folder name" the file is being created within?
@entrepreneur-income
@entrepreneur-income Жыл бұрын
Hello Ben, How to translate an eBook Word file while keeping all the images in place?