Power Apps V2 in Power Automate Populating a Word Template

Рет қаралды 7,504

Күн бұрын

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

Пікірлер: 57

@andrewhess123 7 ай бұрын

PowerAppsV2 is not premium, using a MS Word Connection is Premium

@elainechang9107 7 ай бұрын

Thank you so much for sharing!!A timely rain for my work!🤩

@andrewhess123 7 ай бұрын

Perfect timing 😀

@dsonoma 2 ай бұрын

This was a HUGE help in my efforts. Thank you very much!

@andrewhess123 2 ай бұрын

Thank you for watching SIMMONSFOREX!

@GuilhermeDSa 7 ай бұрын

OMG, I was needing this this month in my work, thanks Andrew, a big thanks😁😁😁

@andrewhess123 7 ай бұрын

Woooo! Big win!

@GuilhermeDSa 7 ай бұрын

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😁

@andrewhess123 7 ай бұрын

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

@mauricioetienne3379 7 ай бұрын

Haven’t seen it and already liked it! 🙌🏻

@andrewhess123 7 ай бұрын

Thanks Mauricio! Go with the gut instincts 😄

@vivek8237 Ай бұрын

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.

@andrewhess123 Ай бұрын

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

@sistex3729 Ай бұрын

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.

@andrewhess123 Ай бұрын

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.

@TalalAlShareef 7 ай бұрын

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")?

@andrewhess123 7 ай бұрын

Probably could of, if that works 😀 Just how my brain thought to do it at that moment 😆

@user-dr9kd5em8k 4 ай бұрын

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?

@Sam-ty4kh 5 ай бұрын

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

@Allison-jg1qu Ай бұрын

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.

@andrewhess123 Ай бұрын

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: kzfaq.info/get/bejne/qZx-lKyKtZmRj6s.html&t

@Allison-jg1qu Ай бұрын

@@andrewhess123 Thank you for the video link! Have you done one with Power Apps v2 by any chance?

@Allison-jg1qu Ай бұрын

NM - I figured it out. Thanks again!

@andrewhess123 Ай бұрын

@@Allison-jg1qu Nice glad you got it Allison! Thanks for watching!!

@ldebski4 7 ай бұрын

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 :)

@andrewhess123 7 ай бұрын

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

@legendgod 4 ай бұрын

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".

@convenientlyconfused264 7 ай бұрын

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?

@andrewhess123 7 ай бұрын

The idea to work around would be combine inputs with a comma and then split them in Power Automatee

@tylerhoffman9856 5 ай бұрын

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.

@andrewhess123 5 ай бұрын

Noice! Lemme know!

@moeking5601 7 ай бұрын

Great video 👍, only issue with power app v2 it only allows 20 inputs 😑, is their a work around using compose?

@andrewhess123 7 ай бұрын

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.

@convenientlyconfused264 7 ай бұрын

Did you ever find a work around for this?

@luisenriquebaldovinomartin8689 5 ай бұрын

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?

@andrewhess123 5 ай бұрын

Yes, that sounds right. Text should probably work just fine

@luisenriquebaldovinomartin8689 5 ай бұрын

@@andrewhess123 I already tried it and if it worked.

@andrewhess123 5 ай бұрын

Nice! @@luisenriquebaldovinomartin8689

@dhananjaysinhrayjada6471 24 күн бұрын

Unable to see power automate flows in power app eventhough used manual trigger as per your video

@StanOlbrot 7 ай бұрын

Can you write any link to video witch describe "MS Word Template" from this video ?

@andrewhess123 7 ай бұрын

I will create a new video soon, on how to create MS Word Template

@Elwood55312 5 ай бұрын

Does the Word template require the document property inserts like you created in your V1 trigger video?

@Elwood55312 5 ай бұрын

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.

@andrewhess123 5 ай бұрын

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

@Elwood55312 5 ай бұрын

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.

@andrewhess123 5 ай бұрын

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

@Elwood55312 5 ай бұрын

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.