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.
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.
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.
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. 👍🏻 😊
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!
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?
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".
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?
@@PaulieM there isnt a download i mean, the download you have linked it was the zip part, was wondering if you could share a full end to end flow that does what you showed in the video
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?
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
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
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.
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! :)
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?
Hi Paulie, Excellent video. Quick question at 5:45 minutes you talk about the Powerapps Name, Date and Image. What are these referring to in your power app? I am trying to use it but I am only using text fields at the moment on my Power App. but on the button I am getting an error "invalid number of arguments ". I am putting it down to what I have in the Flow PowerApp action. Cheers John.
@@JohnBrines1969 The fields referred to in the video can be anything you like really. They are the trigger parameters that you’ll pass through from PowerApps. So you could just have one or several. When you add the flow to your powerapp it will prompt you to fill in those values. Does that make sense?
@@PaulieM Sorry I didn't explain myself very well here. I understand the Power App and Automate part but it's the Word Fields I am struggling with. I have looked at inserting a field in word but so many options to choose from. Which ones did you use and when I did choose one it didn't look the same way your field looked.
@@PaulieM I have worked out the word fields now and have my document.xml working as it should. I am now struggling to understand the link between the Power App and the PowerApps(V2) inputs, sorry it I am missing something here. J
@@PaulieM I worked the fields out just took a bit of head scratching. I wonder if you can help me with the app I am creating using. So in the 2nd input I am replacing text. So I use the formula "replace(outputs('ReplaceRecipient')?['body'], 'project1234', triggerBody()['text']) " but it isn't working. What formula woul I need to replace the 'project1234! Again sorry for all the questions John.
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
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!
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?
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?
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,
As Paul ignored me for help anyone else can help please all I need is, if I need to add another field on doc what to use in the flow to pass the doc, The exact format of the replace expression Name and date is working fine but needed for the added field replace(outputs('ReplaceName'), 'address12345', triggerBody()['text_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.
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
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.
Really happy to hear this feedback. Well done, sounds like a great solution.
You are a genius. Thank you so much for this approach. It is gold.😄
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.
Very interesting approach, many thanks for the video and the many explanations. Thank you!
Fantastic. Your channel is great. Not the trivial usual content. Very inspiring
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. 👍🏻 😊
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
ua-cam.com/video/s6NaIYP3-_w/v-deo.html
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!
Glad it helped! It is a neat solution.
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?☺
This is great information and almost exactly what we are looking for. How can I hire you to complete a project similar to this?
Please use the get in touch form on my blog tachytelic.net
This is very helpful! I am not sure is there anyway to deal with repeatable table in word template?
Great video!!
My problem started when I couldn't convet my template (.docx) to .zip
Do you know why?
nice video do i need to combine the both replaced texts on create file only one get created in my word document
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?
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".
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?
are you able to share the full solution?
Is there a part missing?
@@PaulieM there isnt a download i mean, the download you have linked it was the zip part, was wondering if you could share a full end to end flow that does what you showed in the video
@@officialnbk there isn't anything you can download, but you can follow the video and build it.
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?
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.
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
I don't know of a way that this would be possible. Sorry.
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
Paul can you please help am stuck?
It's awesome, how did you come up with these methods?
Tenacity, not talent :D
My hero!!!
Ha ha, you were the inspiration - Thank you for the video idea. That was a tough one to crack!
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.
All office documents are zips. Try renaming an excel doc for example.
@@PaulieM next step: change the ribbon menu in office documents via flow. 😎 looking forward to that video. 🤓
Excellent hack! Thanks for sharing!
Awesome.... Can you please try to add repeating table content... It would be helpful for invoice generation
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! :)
I can help, get in touch via my blog please!
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?
I've got the signature already as attachment in sharepoint list. How I can take them into the word document?
Hi Paulie, Excellent video.
Quick question at 5:45 minutes you talk about the Powerapps Name, Date and Image. What are these referring to in your power app? I am trying to use it but I am only using text fields at the moment on my Power App. but on the button I am getting an error "invalid number of arguments ". I am putting it down to what I have in the Flow PowerApp action.
Cheers
John.
I think it is to do with my fields, I think I have the wrong fields. Can you tell me how you created the fields
@@JohnBrines1969 The fields referred to in the video can be anything you like really. They are the trigger parameters that you’ll pass through from PowerApps. So you could just have one or several. When you add the flow to your powerapp it will prompt you to fill in those values. Does that make sense?
@@PaulieM Sorry I didn't explain myself very well here. I understand the Power App and Automate part but it's the Word Fields I am struggling with. I have looked at inserting a field in word but so many options to choose from. Which ones did you use and when I did choose one it didn't look the same way your field looked.
@@PaulieM I have worked out the word fields now and have my document.xml working as it should. I am now struggling to understand the link between the Power App and the PowerApps(V2) inputs, sorry it I am missing something here. J
@@PaulieM I worked the fields out just took a bit of head scratching. I wonder if you can help me with the app I am creating using. So in the 2nd input I am replacing text.
So I use the formula "replace(outputs('ReplaceRecipient')?['body'], 'project1234', triggerBody()['text'])
" but it isn't working. What formula woul I need to replace the 'project1234!
Again sorry for all the questions
John.
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
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!
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.
Receiving the 'Sorry, this document can't be opened for editing'. Anyone know how to fix?
We are having the same problem. It's related to carriage returns on our one.
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?
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?
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?
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,
Hi Paulie, would this work for embedding a youtube video?
I didn’t even know you could embed a UA-cam video in word. But if it’s just the URL you need to replace then it might.
@@PaulieM will give your video suggestion a go with the URL and let you know how it goes
Help mine error when setting input library path
As Paul ignored me for help anyone else can help please all I need is, if I need to add another field on doc what to use in the flow to pass the doc, The exact format of the replace expression
Name and date is working fine but needed for the added field replace(outputs('ReplaceName'), 'address12345', triggerBody()['text_3'])
Hi basehumax I’m facing the same issue. If you have already resolved it then it would be great if you can also help me further with this TIA
@@urvashithareja3978 Hi, Still same issue actually I have deleted this flow as is not what Paulie M saying on the title and he wanted a view hit only.
This is not clear. Can you make step by step video please