Learn PowerApps - Autofill Templates in Sharepoint Tutorial

[@nAhmd1]

Hi, thanks for the tutorial! It’s super useful! Quick question, How can we auto populate the Word document from radio buttons in power apps?

[@yahlibloch3267]

Hi Henry. Thank you for this tutorial! I am trying tou use PowerApps on ShairPoint. I want to make a PowerPoint tamplate but the 'Developer' in PowerPoint doesn't have the 'Design Mode' feature wuich is why I failed. Do you have an idea how to help me? or a tutorial the same as this one just with PowerPoint? Thanks again :)

[@pipelox]

its possible do the same but with a excel?

[@1200cjh]

I am looking for this function bas well. Did you get it to work?

[@pipelox]

Yes I did with power automate and function patch

[@pipelox]

@@1200cjh did you make it work?

[@1200cjh]

@@pipelox not yet, I only have a free power automate account and I've set up my one flow. I looked through and could find anything referencing excel template.

[@pipelox]

@@1200cjh sorry, that means you could not have more than one flow?

[@sebmanox]

Hi Henry. Thank you for this tutorial! This is really helpful. Do you have any tips when it comes to creating Word docs from a template that is populated with SharePoint List data? I have information stored across several lists and I'm trying to figure out how I can create a Powerapp that lets me select items from each of the lists to collate it into a word doc template I have already. My alternative approach would be to collate it all on a dedicated list, export to Excel and use that for mail merge within Word. I have several hundred itineraries to populate with varying travel details and feel there must be a way of doing this using a flow and powerapp. Any help is greatly appreciated! Thank you :)

[@Emanuel-fu4cf]

it's now a premium action :( do you know any alternatives for this?

[@henryouang]

I'm sorry, I haven't researched alternatives yet, but I'm sure they're out there. What I've found is you can keep renewing your powerapps "Trial," but that might be a problem in the future, especially for larger companies as well.

[@cambike]

Mail Merge easier and simple to do, excel spreadsheet with the addresses, create mail merge doc, hey presto

[@donjuaquin]

@@cambike did it work for you?

[@walterwego1396]

I think the premium connector is only relevant for flow. You can create a service account for your flows and purchase a single premium license.

[@Emanuel-fu4cf]

@@walterwego1396 you're right, that's what I ended up doing... thanks!!

[@pngtrips6846]

great video thanks

[@henryouang]

Hi everyone, if you want to be able to do this without PowerApps Premium, I made a new tutorial on how to do this in excel. The excel version is probably better if you follow the tutorial all the way through. The end product is: At the click of one button, you can generate 100s of PDFs from excel data (like a csv file). Check out the demonstration here! kzbin.info/www/bejne/faKnZ5Wtr7yXfqc The tutorial is the video right after my demonstration!

[@alpanapradhan2328]

Thankyou. Excellent tutorial. Short and to the point. Can you also make one with checkbox.

[@TheBigBosske]

Hi Henry, On it... Stupid question, but the form supports all characters (e.g. Chinese, Arabic)?

[@donovanbogor4730]

Thank you very much Henry. It was just the thing I was searching for. We wanted to auto fill a permit approval template with text input from the field. Greetings from Suriname. Again Thanks.

[@jjactual9321]

Hey! Very helpful video! Thanks! Just one question - I need to attach the file that's created for an email and then delete the file. Any idea how I can accomplish that? I've searched google and youtube for hours! any help is appreciated

[@Milyboy6412]

hey mate , good stuff, is there a way to store the SharePoint link for the new document in Dataverse for back office proposes , if yes , how to do that ?

[@stephenswann2661]

Thanks Henry You made my day. This was the easiest example of this I have come across.

[@henryouang]

Thank you! That is great to hear!

[@angileewelch8898]

Thanks for this great! I am having one issue. Do you have a way to contact you to help solve this my problem?

[@DrawdeThePotato]

😭 thanks!!!! Your an Angel!!!!

[@moizdankwizard]

If i want to email this created word document what should be my next step

[@catherinelizana8348]

Great video! Thank you. Can the same outcome be accomplished with a repeating table?

[@cristoumanzor3896]

I have learned something new today! Thanks a lot Henry. :-)

[@alfrednisay]

Great video. Thanks for your time! Have you tried doing this but the output is to send email using Word as template for your email? Thanks again!

[@henryouang]

That is definitely possible. I believe I have an email video, which you can connect to this action from this video!

[@miguelgallegos2302]

Se puede hacer con excel? Y se puede en el cellpohe, Can it be done with excel? And you can in the cellpohe?

[@anhhoang5346]

wonderful tutorial. thank you sir

[@user-sb5gh5qi7c]

how to add a dropdown menu to the run flow in powerapps?

[@gopikap2512]

"Ask in PowerApps" option is missing under add dynamic content option. its showing only " body". please suggest

[@mohamedyassinebaccouche7180]

same

[@amt27videos]

Good video, only works with power automate premium

[@henryouang]

Thank you! That's true. Please let me know if you find any alternatives.

[@marenhumbert4310]

Thanks Henry. Thank you for sharing. Is there also a way to get information out of an existing sharepoint-list instead of tiping "name, phone number" manually?

[@deek9400]

Thanks for sharing, very informative

[@henryouang]

Thank you!

[@vlgado3895]

Hi. Nice and usefull video, very well explained. Thanks. I have a question. How does the flow or power app (wich is the case) know what text input to use in wich place? In your example, how does it know to use text input 1 as name? I am interested for a more elaborate project with a lot of inputs. Thanks in advance.

[@venukolar7999]

Hi Henry the Video was really informative, Actually I have a similar kind of requirement like I have two resumes with the same set of fields and I have to extract the data from one resume (Source file) and I have to paste it into another Resume(Destination File) how can I achieve it using Power Automate, please help me out. I have extracted the data from resume one and after that I am not sure to proceed further. Any help would be highly appreciated. Thank you.

[@maorifulla]

Great video. Thanks for that. Instead of searching for 'Ask in PowerApps' you can also click on the 'See more' link in the 'Dynamic content' dialog to view the 'Ask in PowerApps' option.

[@masjun24]

Thankyou, definitely what I need. is it possible to give preview when you hit submit? cause I want to apply it in a longer document. thanks. subscribed!!

[@sharonworger5961]

Hi Henry Thanks so much for sharing your knowledge.

[@henryouang]

Sharon, I appreciate your kind words. Hopefully, this information gets you far! Best, Henry

[@heidilackner-vanhartrop7622]

Hi Henry, thanks very much for your clear and helpful video. Would it be possible to explain how to add a signature in a Word-template by PowerApps? Thank you in advance and best regards from Heidi

[@Samtember]

* League of Legends Folder

[@minocat23]

Nice video - I am finding the flow is not bringing the fields in in the correct order. For instance name,address,town,county,postcode in the doc but in the flow it always shows county at the top. Don't know if a bug

[@feltreter1032]

Henry, this is great tutorial! Very helpful! If the Word template is saved in local C drive, how can I enter that in location when creating a flow in PowerApps? Does the template must be in Cloud? Greatly appreciated your help/response!

[@peertube1]

Great and thanks for the nice video. I just cant get it done because of an error in the code. The , does not work for me. I can replace the , for an + sign but the error message keeps on saying 'expect 5 inputs and i get only one'. When i create a word file with just one input it works great but not with multiple inputs. Hope you can help me out.

[@hazelbutler8904]

Thank you Henry. Great video! I have two questions: - How could you make it so the user who completes the form gets to download a copy within the app? - How could you set up a rule to say if the person puts in X in the form then it inserted XXXX text in the field in Word? Thanks!

[@susanteng3592]

This is an awesome tutorial. I have a word template with check box corresponding field in sharepoint list/powerApp form is a dropdown. How I can auto check the corresponding checkbox based on the dropdown selection?

[@susanteng3592]

Your video is very helpful and easy to follow. I use your technique to create a work flow generate word document from Power App input. My generated word document saved in Sharepoint document library. I wonder how I can add a step in the work flow to send out email with the generated word document as an attachment to a distribution list (enter in Power App text input). I see you made a video about send email by Power App. Could you make an video as a next step of this video- send the generated word document as attachment, please? Also I notice if I save the generated word document in Sharepoint Document library, if I generate a file with same file name, the new file won't replace the old one. Is there a way that has a pop up ask if user wants to replace?

[@LowPain1]

Hi Henry, great video! I have a question, I have more than 5 data inputs that I want to populate from the doc but unfortunatley in the power app i dont have the option to select them all. the power app select a random 5. How can i fix it?

[@surveyreadyTX]

Hi thank you for the video! It was very helpful! I have about 12 different letter templates that I have to send to parents based on the situation. Once the 8 fields are filled in, I have to convert it to pdf and lastly email to the parent. This seems like it would be a great tool. How can you assist me with setting this up?

[@malikkfamily2577]

thanx for uploading, i am trying to create an online database where video files can be uploaded for social media accounts ,i.e facebook, twitter and KZbin with their title descriptions thumbnails and tags but they need approval prior to uploading on social media accounts, can you help.

[@plamenyordanov5236]

That is a brilliant video! Great job :-) I have one question if someone can help. How do i make it jump to the Complete screen once i fill the form? I can only do one or the other :-(

[@luqmanulhakiem3014]

Thank you so much Henry! I did a task on populating the MS Word with MS Form, that way also works!

[@andrewhill2360]

Just discovered power apps and started playing around with it today. This really helped for the use case I’m thinking of and to get me off the ground with this! Start with template, then flow, then app rather than the app first 😅

[@CC-TimesTwo]

Great content. I like how direct and to-the-point you are. Most people don't need long lectures so this is perfect. I'm going to try this tomorrow at work!

[@joelrouviere6527]

Hi Henry, This video is amazing, I was able to create a flow from my PowerApps application. Is there a way to populate fields such as dropdown list, date picker and labels?

[@belitadsouza3839]

Hi! If I have an image that needs to be converted from power apps to word, how can I do that? I used the image section on the developer mode for MS Word, but what would the code be in power apps to retrieve the image to Power Automate?

[@RafaelGonzalez-rv1iu]

Enjoy your video but what I am looking to do is to leveraging outlook contacts to use in document automation. So is there a way to combine the steps in your video with outlook contacts?

[@miguelgallegos2302]

Se puede hacer con excel?

[@jarodsmith558]

Henry, I work for a law firm and we are wanting to implement something similar that syncs with tasks by planner. Is this possible?

[@FaisalBokhowah]

Great job by Microsoft automate and powerApp Thanks to you

[@NasenErlan]

How can I add other types of Forms like Data Type or Checkbox? Flow doesn't see them

[@aliciadegouveia3229]

Hi have a question can you use the following type of steps you have done in this video. to have multiple people enter data that only they see. But that then gets submitted all to one document? hope that makes sense?

[@javiergonzalez4876]

Great job.. Can you have a solution for autofill a table in the word template from the items in a gallery of power apps?

[@guber67gaming]

Hi, is it possible to straight up put the word document into a powerapp screen and then edit the document from there?

[@thomasnieto4685]

Hi ! Thanks for this tutorial. How do you do with picture controle?

[@siamaksiamak5583]

you are just best search all internet two days and not I found exact what i was serarching

[@lisearsenault1386]

Great video. Thank you!

[@henryouang]

Lise Arsenault glad it was helpful!

[@DaxtAttack]

Thank you for the video. Great info, great job.

[@hariskarsic5638]

Thanks for a good video, is it possible to populate images as well?

[@elnadroj]

Thanks mate, I felt like I was under water but really enjoyed the content haha

[@carloreyes5023]

This is very helpful. Do you have a video how to fix the infinite loop?

[@CeceDeAnn]

Thank you! I’m going to make one tonight for work, I hate filling out repetitive paperwork

[@2nworkshop440]

Hi many thanks, this video is very useful and simple

[@bootsbax]

Super useful Henry, thanks so much !

[@fredyespinozaperez5185]

Thank you very much Henry, What parameters do I use for images?

[@paulinekayedelrosario5739]

Great video!!! Saved me from the project im doing! Do you have a video when its na image we are trying to put back in the word file?

[@lfysr8062]

Nice tutorial, thank you very much!

[@AllThingWant]

thank you

[@Emilpk]

That was well done, thank you Henry!

[@henryouang]

Thank you so much!

[@АлександрЛукашев-е1й]

Perfect

[@lagenteestaloca5875]

Great lesson Henry! Used it in my project - worked the charm. I am thrilled! Henry, a quick question. Can you help with the code to use to clear the entered data once it is submitted.. Thanks again for a great presentation!

[@pepegrillo7290]

Hi great video, I'm traying to fill a template whith image, but the flow have an error, says that I'm not using a JPG o PNG image, ¿do you know if Is possible to fill templates whith image from Powerapps? Thanks

[@belitadsouza3839]

Hi there, were you able to fix that error? I'm getting the same one :(

[@eriks707]

Thank you, this was great! I noticed if I have a text field that isn't filled out, PowerApps wont trigger the flow. As soon as i just punch some random values in the empty text field, it works. Any suggestion on how to handle this, so that "blank" text fields won't crash the execution through the button in PowerApps?

[@henryouang]

You can add in an If statement. Here's some example logic. If TextField1.Text is blank, then Run() the flow. Otherwise, do nothing (or display an error message that might have been Visible = False .. so you can set DisplayMessage.Visible = True) Something like that should work!

[@aakash13mohan35]

Great resource. Thanks. Can we populate an Excel Template the sameway? Any tips would greatly help.

[@henryouang]

Check out the new tutorial I did for excel. I think it is way better than this one, but it is totally free! I just uploaded it.

[@joels9526]

How to automate this to an email ?

[@Albertini1985]

Hello, Is it possible submit one image in powerapp and them insert in word template as image? Ty for help

[@belitadsouza3839]

Hi! were you able to do that?

[@NikolaTesla10093]

Well done mate , very well done ! Thanks for sharing

[@ezhilmclaren]

Thanks a lot Henry !

[@imankhatib132]

Great content, thank you!!!

[@yuipiyanan8073]

Thank you so much

[@Bekesam]

Thank you so very much for this video. I was searching all over to this, and finally came across your very well explained video. Keep up the great work!!!

[@henryouang]

Thank you!

[@nipun399]

Awesome video! Can we use same method to get images?

[@belitadsouza3839]

Hi, were you able to do it? I have the same problem.

[@ingee8]

I like to ask you a question. My question is. Can I

[@walterwego1396]

Can you finish a sentence? No it appears not. 😉

[@91alezander]

Great video. Thank you so much. Can you make power app get data form an excel or access document and autofill autofil an tamplets in word? Something like a trigger when I put data in excel or access to autogenerate a word tamplate?

[@henryouang]

Check out the new tutorial I did for excel. I think it is way better than this one, but it is totally free! I just uploaded it.

[@rajamahendrareddyvangala114]

@@henryouang can you post the link here. I couldn't find the video browsing your channel

[@arpghosh]

Thanks

[@Mikel0318]

So simple and so very useful! Thank you for sharing!

[@henryouang]

Mike, thank you for the feedback! I am happy to share my knowledge with you. Have a great day! Henry

[@nw6528]

Clear explanation Thank you. Is it possible to send doc as attachment once created (automatically)?

[@henryouang]

Thank you! I believe you can by "Get"ing an item from the folder you just saved the document in and then attaching it to an email user Office365() in powerapps!

[@Bekesam]

Question: If there are lets say 100 different templates, would there have to be 100 different flows? The potential is there just not sure if there is a quicker way?

[@punitharajan]

thank you for above video Could you please help me to create a pdf file from sharepoint list using power app and power automate

[@kim1217]

Very useful, but the sound of your typing is almost unbearable. 😑

[@kim1217]

can you please share how to generate multiple invoices at once off of a SharePoint list or Excel file?

[@mowtown75]

So good, rich in relevance and required detail. I will use this method to create an inspection form. May I ask how to take a photo please and hopefull have it nested or embeded in the document as a thumbnail? Thx Tim

[@belitadsouza3839]

Hi, were you able to do it?

[@mowtown75]

@@belitadsouza3839 yes, but not manually. I created the library in SharePoint online then created the power app from the library. It created the photo option all by itself.