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
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
hello I think PowerApps v2 has 20 input limitation do you know how can I get more than 20 inputs you seem to know something pls hlp I'm stuck for a while now can't find anything
Hi paolovr, great question. I would think so you just have to point it in the right direction and use that template. I have not done this yet though, but I do think it should be possible. Here was an aritcle i found that may be helpful. www.reddit.com/r/Office365/comments/pequlq/is_there_a_way_for_users_to_have_access_to/?rdt=44280 I see something aboutr installing .dotx file on the library's site pages. I have not done this, but I think it would be extremely important! Thank you for the question.
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.
I don't think so, not sure of a use case for that. You could add more steps to the power automate and change the format to send it to somewhere else? But not sure about inside the document.
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
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?
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 :)
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
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".
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.
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.
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?
PowerAppsV2 is not premium, using a MS Word Connection is Premium
Haven’t seen it and already liked it! 🙌🏻
Thanks Mauricio! Go with the gut instincts 😄
Thank you so much for sharing!!A timely rain for my work!🤩
Perfect timing 😀
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
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
hello I think PowerApps v2 has 20 input limitation do you know how can I get more than 20 inputs you seem to know something pls hlp I'm stuck for a while now can't find anything
This was a HUGE help in my efforts. Thank you very much!
Thank you for watching SIMMONSFOREX!
Hi Andrew! Do you know how to remove blank spaces in Word Document if the content controls value is null or empty?
That's a good question. I wonder if there is some command in Word that can act as a backspace or something.
@@andrewhess123 Thank you!
I will check that 😊
Thanks, very useful, I ask but can the Word template be a shared template?😊
Hi paolovr, great question. I would think so you just have to point it in the right direction and use that template. I have not done this yet though, but I do think it should be possible. Here was an aritcle i found that may be helpful. www.reddit.com/r/Office365/comments/pequlq/is_there_a_way_for_users_to_have_access_to/?rdt=44280
I see something aboutr installing .dotx file on the library's site pages. I have not done this, but I think it would be extremely important! Thank you for the question.
Unable to see power automate flows in power app eventhough used manual trigger as per your video
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.
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
Is there a way to change the format of the data after it has been sent to the word doc template?
I don't think so, not sure of a use case for that. You could add more steps to the power automate and change the format to send it to somewhere else? But not sure about inside the document.
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
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
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
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
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!!
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".
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?
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 😆
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!
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.
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?
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