Fill and Sign a Word Document with Power Apps and Power Automate without using any premium actions

Рет қаралды 22,154

3 жыл бұрын

In this video I demonstrate how it is possible to fill and sign a Word document using a #PowerApps Pen Input and a couple of text fields to trigger a #PowerAutomate Flow which will create the document with the input from Power Apps without the use of any premium actions or connectors. Check out this blog post to see how the Zip section of the flow is done:
www.tachytelic.net/2021/07/po...
Let me know how you get on in the comments if you try this!
If you found this solution useful, I'd appreciate a donation to the channel:
www.buymeacoffee.com/paulie

Пікірлер: 67

@thegame4988 3 жыл бұрын

This is a real eye opener for everyone. Brilliant video and as always, inspirational. You always come up with solutions on topics not many people would even think about as being a possibility. Love it! Thank you.

@Mx81 3 жыл бұрын

Damn. I don’t find the time to learn all your stuff you “teach”. Please don’t delete the videos in the near future! 😎 Great content. Love it! Thanks

@RT-yi6te 3 жыл бұрын

Fantastic. Your channel is great. Not the trivial usual content. Very inspiring

@PaulieM 3 жыл бұрын

Really appreciate the feedback. I do try to cover things from a different angle, think I’m getting better at filming too. Glad you find it useful. 👍🏻 😊

@user-vo8kt2yn8g 6 ай бұрын

You are a genius. Thank you so much for this approach. It is gold.😄

@markushahner Жыл бұрын

Very interesting approach, many thanks for the video and the many explanations. Thank you!

@CustersBart 3 жыл бұрын

Excellent hack! Thanks for sharing!

@SilentGenY2060 Жыл бұрын

Thank you Paulie this is very useful! I was looking for word document edit options (without Premium) and looks like this is the only way. Cheers

@PracticantecorporativoCOMPAS 20 күн бұрын

kzfaq.info/get/bejne/qZx-lKyKtZmRj6s.html

@columbinemulcahy5025 2 жыл бұрын

Thank you so much, linking a few of your videos and blogs together, I can now pass a dynamic file from Power Apps, to a flow which then converts the word document to a zip, then extracts the zip, dynamically replaces content controls in the header and footer then recreates the document. All within SharePoint. thank you for your tenacity.

@PaulieM 2 жыл бұрын

Really happy to hear this feedback. Well done, sounds like a great solution.

@dr.g5043 10 ай бұрын

You, sir, are a magician! Thank you for such a wonderful tutorial and sharing the source code. It made it quite easy to replicate your process. Subscribed!

@PaulieM 10 ай бұрын

Glad it helped! It is a neat solution.

@user-my9ul2ul1m 3 жыл бұрын

Awesome.... Can you please try to add repeating table content... It would be helpful for invoice generation

@feideng6764 2 жыл бұрын

This is very helpful! I am not sure is there anyway to deal with repeatable table in word template?

@CSparkles-w9f Ай бұрын

Thank you for this content. I successfully created a flow based on this not long after you created it. I have modified the flow a little as we required it. e.g loop through all documents in a library and change the company name within the document. One thing I haven't been able to work out is URLs. I can change the URL front face but not the URL back in the xml.res file. Would love to know if you have done this.

@paulmungai21 2 жыл бұрын

nice video do i need to combine the both replaced texts on create file only one get created in my word document

@jayantkhushalani8639 2 жыл бұрын

Many thanks for the video paul, However, you have just replaced one field in word document but i would want to replace multiple fields and then create one file. How can i do that?

@DeShonClark 3 жыл бұрын

My hero!!!

@PaulieM 3 жыл бұрын

Ha ha, you were the inspiration - Thank you for the video idea. That was a tough one to crack!

@DeShonClark 3 жыл бұрын

I would have never guessed that a word document was a zip file. This opens up a whole new set of possibilities with word templates. This is fantastic! I have to play around with it and see how it really works. Thank you so much I really do appreciate all your help. I will message you on LinkedIn to set up the session for Saturday.

@PaulieM 3 жыл бұрын

All office documents are zips. Try renaming an excel doc for example.

@Mx81 3 жыл бұрын

@@PaulieM next step: change the ribbon menu in office documents via flow. 😎 looking forward to that video. 🤓

@user-vo8kt2yn8g 3 ай бұрын

This video is a big help. Thank you. I have a question. Can you , please, tell me can I convert the xml file to word or pdf?☺

@muratesen288 7 ай бұрын

Hi I've tried to do as much as zip, I didn't understand the problem I had, I would like you to explain as clear as zip.

@iaa9874 2 жыл бұрын

It's a brilliant video indeed, did anyone manage to copy multiple fields? I'm still struggling, tried everything still no luck. Instructions on copying the second field isn't clear though!

@leandrozaccari3193 Жыл бұрын

I've got the signature already as attachment in sharepoint list. How I can take them into the word document?

@FranciscoLegonDev Жыл бұрын

This is good if you just need a visible signature, because it's a PDF, but It is not equivalent to using DocuSign or Adobe Sign because those implement digital signatures, an encrypted tech associated with digital certificates. Do you know how to apply that kind of signatures through a flow without premium connectors?

@jamiecruz5042 3 жыл бұрын

Hello Sir. I have a question about power automare visual and sharepoint list. i want to create chart visuals from sharepoint list data to share with hr team. but i want to hide some colums as thye do not need access to them as the data is private. can i do this with power automate visual or you have better idea sir? thank you sir

@pedrohenriquefontesleitao9750 Жыл бұрын

Great video!! My problem started when I couldn't convet my template (.docx) to .zip Do you know why?

@user-bz6cw6gi9k 5 ай бұрын

This is great information and almost exactly what we are looking for. How can I hire you to complete a project similar to this?

@PaulieM 5 ай бұрын

Please use the get in touch form on my blog tachytelic.net

@enzoclaro7556 Жыл бұрын

Thank you Paulie for the video and dedication to presenting this alternative! I need help for a project very similar to the one in the video, but with the difference of collecting two signatures instead of one. When I run the flow and the docx is generated, in place of the images a white box appears with a line of text written: "Cannot display this image". Do you know what I could be wrong? I really appreciate who can help me! :)

@PaulieM Жыл бұрын

I can help, get in touch via my blog please!

@luis_ffernando 2 жыл бұрын

Hello @Paulie M!! Very interesting... and I wondering if is possible to send by mail instead to save the final file. Is it possible?? How can we do it?

@rockabillyron Жыл бұрын

Try to add the "Send an Email (V2)" action, expand the "Advanced options" and for the attachement, use the dynamic content from "Create Word Doc". F.E. File name "Create Word Doc --> File Name" and content "Create Word Doc --> File content".

@yayak.9726 Жыл бұрын

thanks for video, it is really helpful, just one question. is there anyway to include rich text to word! I have html text field and I need to import it to word with the exact format. if not is there any work around for this. specially it is not converted to pdf as it has special characters that not supported in pdf! thanks

@PaulieM Жыл бұрын

I don't know of a way that this would be possible. Sorry.

@monsalveclashroyale2766 9 ай бұрын

Hi Paulie! Thank you for this solution; it's perfect! I have one question. I created a flow to receive three signatures from PowerApps. It works fine, but when the JSON is empty, the flow doesn't run. There are times when only one or two people sign, so how can I ensure that the flow continues to execute even if someone doesn't sign?

@PaulieM 9 ай бұрын

You’ll have to check if the input is empty and if it is then substitute the image for the base64 of a blank image.

@gabetuaputrasimbolon1354 3 ай бұрын

Help mine error when setting input library path

@liangjb10 3 жыл бұрын

It's awesome, how did you come up with these methods?

@PaulieM 3 жыл бұрын

Tenacity, not talent :D

@basehumax Жыл бұрын

Hello Paul, Thank so much for the video mate, I have an issue which I unable to add an extra fields on my word doc, some of the field working fine when run flow but like this field replace(outputs('ReplaceName'), 'address12345', triggerBody()['text_3']) not passing to word doc, can you correct me please thanks

@basehumax Жыл бұрын

Paul can you please help am stuck?

@mikevanlierde2310 2 жыл бұрын

Perfect way to avoid premium. But i have a problem replacing the date. The exacte format of the replace expression for the date in not completely visible in the video. I use - replace(outputs('ReplaceName'), 'date12345', triggerBody()['text_1']) - but this does not replace the date and i don't get any errors. any help?

@PaulieM 2 жыл бұрын

That is the correct expression. Double check the content of document.xml to make sure it contains that string. Word can do funny things if you apply any formatting by accident etc,

@int_x Жыл бұрын

Receiving the 'Sorry, this document can't be opened for editing'. Anyone know how to fix?

@bethedmondson6584 Жыл бұрын

We are having the same problem. It's related to carriage returns on our one.

@Damski748 2 жыл бұрын

Great video but for the life of me I can't get this to work, with some modification of your process, I'm taking a word doc, turning it into a zip, extracting the contents, using your process to download the extracted contents as a zip and renaming as a docx to return the document to a word doc. It sounds pointless but once I have the process working I'll replace elements of the doc whilst extracted but for now the docx is always corrupted, any advice as to where to look?

@PaulieM 2 жыл бұрын

It sounds as though you are doing everything right. When you zip it up, before you rename it, is the zip file valid and can you explore it etc?