Power Apps V2 in Power Automate Populating a Word Template
HTML-код
- Опубликовано: 4 июл 2024
- So this question has been coming up and that is how to use PowerAppsV2 trigger in a Power Automate flow. Actually Microsoft did a great job with this new V2 trigger. It is now easier than ever!
Instead of clicking "See More" and trying to find all of your fields, now you define your fields at the beginning of your Power Automate Flow.
In this video we populate a MS Word Template and save the file to SharePoint. With a very simple Power App we collect 3 data fields from a text, date, and dropdown. Then populate our Word Template with the click of a button!
Come check it out and Thank you for Watching!
My name is Andrew Hess please like and subscribe!
Chapters:
0:00 Introduction
0:54 Creating the Power Automate
4:05 Adding the Power Automate to Power Apps
8:04 Testing the Flow for the Document Template 
Наука
PowerAppsV2 is not premium, using a MS Word Connection is Premium
Thank you so much for sharing!!A timely rain for my work!🤩
Perfect timing 😀
This was a HUGE help in my efforts. Thank you very much!
Thank you for watching SIMMONSFOREX!
Haven’t seen it and already liked it! 🙌🏻
Thanks Mauricio! Go with the gut instincts 😄
OMG, I was needing this this month in my work, thanks Andrew, a big thanks😁😁😁
Woooo! Big win!
Btw, is there a way to take if the Power Automate was completed? I have a Power Automate that create 200 itens in a list of SharePoint, and I want to disable the button that start this power automate until the previous one is completed. Is there any way?
PS: I did it that thing about multiples filters using check boxes values, thanks for the advice😁
Hi Guilherme, that's a good question, I'm not sure about that one. Not sure if you could disable the button, maybe! It depends on where the button is. @@GuilhermeDSa
I can't thank you enough for the videos. Speaking of MS Word, without using a third party connector, is it possible to consolidate ms word files in a SharePoint document library to a one file?
Hi Andrew Thanks for such wonderful lesson, I have created and connected with Power automate , it is actully working and creating Document in word format. I have one issue with this "how to clear fields when we click button" means what should I write in button query onselect to clear field and show new one form.
Hi Vivek, there is not 1 specific way to do this. There are many ways. When you do a custom form you need to tell the screen whether you are in a new screen or edit screen. So you can use a variable to reset the fields.
I would navigate to a new screen when you click submit. Then navigate back, and on the button for "New" form set all the default properties and defaultselecteditems.
It is not just one button there are many places that need to be editted and with new formulas.
Hope this helps, hard to say over a comment
Thank you Andrew for this training. I'm curious, can you accomplish the same results to create a new word document from a SharePoint template in Power automate using Create File? I'm trying to avoid using the Premium license.
In order to do this without Premium and just use a SharePoint word template you need to just use content types and quick parts in a Word Document. The Connector for Word is a premium function whether it is Power Automate or Power Apps. But neither is actually 100% necessary.
Excellent video. I was looking for this exact solution. Many thanks!
Regarding the date issue, why didn't you just used Text(Date, "YYYY-MM-DD")?
Probably could of, if that works 😀 Just how my brain thought to do it at that moment 😆
Hi andrew, I have a form with several data types and almost 100 fields. How can I create a button to insert all the data from that form into a word template? It would be much too time consuming to list them all in the PowerApps V2 inputs. For some clarity, we are looking to create a form for technicians to fill out which is then auto-populated into a nicley formatted word document.
any help is massively appreciated!
Cheers
Is it possible to change the font size, font weight or color of the populating content? For example, the font could change to red color if the result is "fail".
Hey Andrew, is it possible to send a tabel collection from PowerApps via this new connector? I think about button with flow that send tabel or csv. file with collection data from application on mail or to a SP folder :)
Hey! I think this is where you would format as JSON and send the collection to Power Automate that way, then you can Parse the JSON as you need
Unable to see power automate flows in power app eventhough used manual trigger as per your video
Fabulous videos! I'm new to Power Apps, and even I can follow them! Is there a way to do this without using the Word premium connector? I saw the one for Power Apps v1, but am not sure how to do a similar flow with V2. I'm sure you have another video I haven't found yet.
Power Apps v1 is deprecated, or should now not be used. But you can do this without premium connectors it gets a bit more complex though and using site content types, here is a video: ruclips.net/video/s6NaIYP3-_w/видео.html&t
@@andrewhess123 Thank you for the video link! Have you done one with Power Apps v2 by any chance?
NM - I figured it out. Thanks again!
@@Allison-jg1qu Nice glad you got it Allison! Thanks for watching!!
Hey Andrew, following along here and it looks like the Power Apps V2 only allows for 19 inputs.. I need many more. Any ideas for a work around?
The idea to work around would be combine inputs with a comma and then split them in Power Automatee
Great video 👍, only issue with power app v2 it only allows 20 inputs 😑, is their a work around using compose?
Good question! I didn't know this limitation actually... I suppose you could input single line text columns with delimiter(like a comma) and then break them up in Power Automate.
Did you ever find a work around for this?
Hi Andrew, In PoweApps, configuring the button that triggers the power autómate flow, I don’t see the option enebled .Value after entering the name of the Text Input, can I use the option .Text?
Yes, that sounds right. Text should probably work just fine
@@andrewhess123 I already tried it and if it worked.
Nice! @@luisenriquebaldovinomartin8689
Does the Word template require the document property inserts like you created in your V1 trigger video?
Sorry. Just rewatched and you do have the properties added. Another issue...my form inputs in my powerapp are not inputting into the Word template when I click the submit button to run the flow. The Word template gets created, but the data isn't there.
Hi Gerald! Hmm I'm assuming you did add the Plain Text Controls to the template, and you see all your fields in the "Advanced parameters" part when you go to power automate? Like @3:43@@Elwood55312
I have the plain text controls in the Word template and all of the fields display in advanced parameters in the flow. It looks like its an issue with SharePoint. The file gets created from the PowerApp with the flow connection and appears in the SharePoint document library. However, the library columns are not populated. When you open the document and the Word application opens, the data that was entered in the PowerApp form does not display until you refresh the Word document (a warning appears in Word that the document requires refreshing). When it is refreshed, the data appears in the Word document but does not update the SharePoint properties.
I feel like we are confusing 2 different flows or maybe I was confusing it with 2 different flows. In this one I am not connecting the document properties to the SharePoint library columns, I do have another video where I do this using site columns and site content types. Now I am wondering if you can connect the document properties using this type of flow with the V2 trigger and the plain text controls. Hopefully this helps some, I feel like I need another whole new video on doing documents again? @@Elwood55312
Yes. I am trying to do both...use the V2 trigger with the premium connection, which I have, and connect to the SharePoint library columns. Since it is not working, I am wondering if there is another step in the flow I am missing.
So I have to wait until I’m back at work tomorrow, but I think this just solved problem. I’m trying to pass info through and the holdup is the date.
Noice! Lemme know!
Can you write any link to video witch describe "MS Word Template" from this video ?
I will create a new video soon, on how to create MS Word Template
Do I need premium license for this one? I mean to use populate word on Power automate
To use the Word Connector this way, you need a premium Power Automate license. I have other videos where you do not.
Thank you😊
Thank you too foolycooly! Love the Name 😁@@bestfriend4488
You really should put this is a premium feature in the title so people don't waste their time.
Sure, sorry about that, it was more about PowerAppsV2 which is not Premium
I don't know if that would be confusing in the title or not... PowerAppsV2 isn't premium, but MS Word is
Unable to see power automate flows in power app eventhough used manual trigger as per your video