Please continue to create content like this! I really appreciate your efforts & passion to teach people that there is always gonna be an easier way to do stuff without spending much on it. Your innovation is very inspiring. Thank you so much!
DeShon, I wanted to extend a big thanks for this genius work. Too many “marketing” videos trying to push premium connectors when there exist the possibilities to run this all without the extra expense. Bravo !! Subscribed !!
Awesome! Thanks for watching! In this day and age, we have to make sure our solutions are cost effective. I am working on a model that when a premium connector is needed, we can contain it to a service account and not for all users using the solution...more on this soon.
Your instruction was the only one that got my flow right! Thank you!!! Now I have to figure out if QuickParts can apply Rich Text formatting, but it's at least working.
Thank you so much for this tutorial! So far I found that I can only create an html file then convert it to pdf. This tutorial saved my day. There is one limitation: the API does not accept text longer than 255 characters. I added a Sharepoint "update item" step to add multiline, long text to a field (e.g., "comments") of the Sharepoint list prior to the send email step. It worked. Note: if you open the docx in Sharepoint, it does not show the values of the fields. Open it in standalone MS Word (or from the email), the values will be visible.
This was so incredibly helpful, clear, and amazing!! Thank you so much for sharing! I have paid for courses that taught me .08% of what you taught me in this one video. APPRECIATE IT!
Great walkthrough. I'm especially thankful that you leave the typical MS-Quirks in. I tend to begin to doubt myself whenever I need four tries to make powerautomate accept my inputs...Good to know that I'm not the only one...😂
You're welcome! I'm glad you found the idea of using word templates to create PDFs helpful. It can definitely be a simpler and more straightforward approach compared to using HTML templates. Let me know if you have any other questions or need further assistance!
I always can appreciate different approaches to solutions. I might use this for lower volume lists I manage to be able to offload the cloud flow to other users but in my case, I had to request the Premium add-on for Power Automate due to the amount of API calls we are projecting to use.
He DeShon, this is a great video and I want to thank you for making it. For me, it enables me to make my Power Automate perform very dynamic. Great stuff.
Thank you for making this video. I’m having trouble understanding how to get the dynamic content “make” , “model”, etc. from sharepoint to add to their respective fields when updating the template file data.
Thank you so much for your kind words! I'm glad that the video was helpful for you. I'll definitely keep creating more content, so stay tuned for more. Take care as well!
Hi, Thanks a lot for this amazing video. I have some questions: 1 - Sometime i have a yellow message error: "a proper required property missing or invalid" but i still don't understand why 2 - If i want to add a new control, i need fist to add a column in my sharepoint list then add my template in this library, open the template and the new control ? then i have to save my template ? Thanks a lot
Wow, thanks for this video Clark. This one helped me a lot. However I have one issue, my template has a repeating table, so how should my SP library look like? Should I have another library for the repeating table and connect that with main library using lookup columns?
@@DeShonClark Thanks for the reply. BTW I found a solution using the inbuilt experimental PDF function in powerapps, you may want to check that out it is pretty easy.
I'm getting a lot of feedback that the values in the SharePoint library are not showing up in the word template. This happened to me when I was using word online versus the word application, I mean desktop app. Let me take a look and to confirm this approach still works with the latest updates
This is one of the most common ask...images and tables...this technique does not support them, that would require a premium connector to use the Word Template proper
Hello, did you ever work out if this is possible? I am trying to find a way to insert an image into my document but all my research points towards using the word connector which is now a premium feature
@@steviedb9 I spent days on Google trying to find out how to do this with no luck. Eventually I decided to tackle it a different way, hopefully this overview of my solution helps you. I have an audit in Powerapps; when a picture is taken it populates a corresponding Site Column which is formatted as "Multiple lines of text" in SharePoint. These fields are included in my Word doc template. When an audit is completed Power Automate populates the Word doc template and saves it to a library (and emails me). I manually download the populated Word doc and then run the following Macro ( I could probably automate this process but it's not crucial for me). As explained in the notes in the Macro the first step is to convert the Content Controls (Merge Fields) to plain text (if you don't do this step 2 doesn't work). Then it finds the image URL's, downloads the imges and resizes them. I have extra functionality in the Macro which handles various formatting tasks but no doubt you'll want a different look to what I want so I have left this out. Good luck. Dave Sub Convert_Content_Control_to_PlainText() 'Convert Content Controls (Merge Fields) to plain text Application.ScreenUpdating = False Dim i As Long With ActiveDocument For i = .ContentControls.Count To 1 Step -1 With .ContentControls(i) .LockContentControl = False .Delete False End With Next End With Application.ScreenUpdating = True 'Find the URL's - download and embed the iamges and then resize them Selection.HomeKey Unit:=wdStory With Selection.Find .ClearFormatting .Text = "http*jpg" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True Do While .Execute Dim imagePath As String imagePath = Selection.Range.Text imagePath = Right$(imagePath, Len(imagePath) - InStr(1, imagePath, ":\") + 2) Dim SHP As InlineShape Set SHP = Selection.InlineShapes.AddPicture(FileName:=imagePath, LinkToFile:=False, SaveWithDocument:=True) SHP.LockAspectRatio = True SHP.Height = InchesToPoints(6) If SHP.Width > InchesToPoints(6) Then SHP.Width = InchesToPoints(6) End If Loop End With End Sub
@@davidlacey7572, thanks for sharing! I will try to go for an alternative, like exporting to PDF and them converting the PDF manually to Word. If I can make it work will let yall know
Great video DeShon, this has really helped me with my current flow and have used your convert to a PDF instructions also. I noticed in a previous comment some months ago you suggested you used an expression to remove the template value (document property) if the field is not populated, I have tried a few expressions but have had no luck, could you please share the expression you use to make the value blank/empty?
Hey Rob, hope all is well....on the update properties action this is what we are using...obviously update with your respective prop name: if(empty(outputs('Get_item_-CustomerNumber')?['body/CustomerNumber']), ' ', outputs('Get_item_-_Item_Order')?['body/CustomerNumber'])
Thank you so much for your kind words! I'm glad you found the video easy to follow and learn from. I appreciate your support and encouragement! If you have any questions or need further assistance, feel free to let me know. Keep learning and have a great day!
It tooks me hours to solve (I am new to PA!), but I'm almost there thanks to this video! Thanks @Deshon Clak. I have one minor problem though, I can't seem to work around: My final file get's created and updated BUT if I open it with Word in browser, it just shows the copied template start-point, however, when I open the very same file in Word desktop app it shows the correct populated data entries. How can that be? (I am thinking the best way around this is just to set the library to open files in desktop app as default). KR
First thanks for watching, this is a major power Automate for a first go around...kudos to you!!! This is a known issue and this is why we convert to PDF so the experience stays in the browser. You are working fine, this is a known issue
@@DeShonClark Great, I'll have a look at your pdf-video in that case! Only have one problem with this whole flow now, and that is multiple choice answers from the Forms submission doesn't transfer that well to list/doc. It bungles several answers into one choice, and then I manually have to change it form the choice dropdown and delete the bungled data. Any info/video or ideas how to get around this issue? (I can't seem to find anything useful in this regard on the microsoft forums).
Great Video, thanks. Would this work if you had multiple rows you needed to add to the word template rather than the single inserted row? let's say the insert was five rows with multiple times and dates and space requirements.
thanks for watching multiple rows and dynamic tables is a no-go for this. I would recommend going premium for those requirements and images. Note: you can design this is a way to where the premium is only required for the svc account and not all of the users of the solution
Hello, thanks for the great video. I have a problem I cannot solve, and maybe you can help me. I inserted 's date in my word template. The problem is that the date doesn't update. In practice, when I generate the PDF, the
Thank you so much for your kind words! I'm glad you found the video helpful. If you have any questions or need further assistance, feel free to let me know. I'm here to help!
Hi, Deshon, Thanks for youe great video, but I could not figure it out how you et up those customized properties /Fields in the quick access tool bar and also how it coudl show in properties field, for me it only shows the built in properties.
Nice video... congrats... One question: How can I insert gallery data to the word model? For example: Imagine I want to see in the same ticket, a list of the last 3 users that used the slot... However, the question is: How to fill a list of data in Word templates?
Thanks for watching, this is an interesting scenario. Let me take a look and see if I can determine the best approach, we actually may need the premium connector for this. More to come soon.
@@DeShonClark Hi DeShon did you find a way to do this without the premium Connector? I am trying to populate an invoice request and need to be able to handle an array of objects for the billing items properties. Thanks for the great videos. Please keep up the great work.
Hi Deshon, thanks a lot for this brilliant tut! Any ideas on how to do it (editing and adding Document Properties) on Word for Mac? Because the toolbar is different and there's no button to do it... :(
Brilliant, just what I need. Is it possible to add a table to the word document and populate it with dynamic table data from a flow/sharepoint list using this method?
Hey DeShon, great content!! This has been super helpful. I was wondering, if I wanted to use Multiple Line Text instead of single line text, let's say for addresses or for open ended questions for something like a Mid-Year/End of Year Review, would I run into errors? Just wondering, what issues could the multiple line text option for a few site columns cause?
@@DeShonClark After some tinkering, it would appear that "Word Online" does not show MLT mapped values, single line works fine though. If you download the file then the MLT content does appear just fine. It's annoying that word online doesn't support these types of columns as it means my users have to download the documents to see all the values :( If you had any ideas on this, it would be greatly appreciated
Thanks DeShon for the amazong trick... however I'm stuck because the Quick Parts in Word isn't recognizing the fields from the SharePoint list, any thoughts on that? Thanks again!
hey Marius, make sure you are using Word desktop app...not the Word online...then you should see the site columns pop-up when under Quick Parts. When clicking on the word file from within SharePoint document library...use the open in Desktop App...i think you should be good Bro
This is great, DeShon. Do you know if you can insert images in templates with QuickParts (or, in generale, without using the Word Online premium connector)?
hey Riccardo, this is one of the most common ask, but I have not found an "easy" way to accomplish this. inserting images and tables within a template may require the premium connector
@NICOLAS CORREA CAVIERES hey Nicolas, I got your message on ALL media outlets :-) I'll have to take a look, I assumed images and dynamic tables we just plug-n-play with the premium connector..let me try one.... do you have a usecase you would like me to use...you can keep it generic
Great video, thanks for putting this up. When i move my template docx file from the document library where the "v" columns are create to the shared document library, the tokens are no longer available. any suggestion?
hi thank you for the video very informative, is it possible to use the same approach for table and repeated headers, lets say the ItemLines will be also a single text and we can make it as repeated line in the template if we created a table?
thank you for watching...I have not tried this with tables, my gut says this will be a premium connector. Tables and embedded images prove to be a true challenge.
Thanks Edirin, that is a twist...we have several looking into this, but so far seems like the premium connector may be the easiest way, but we're still digging
Thank you for your comment! Yes, this method can work with a repeated section on the Word template. You would just need to set up your SharePoint site columns and map them to the placeholders in the template for each repeated section. The process would be the same, where you get the template content, create a new file, update the file properties, and then send the file as an attachment. Let me know if you have any further questions!
it's not working for me :( it's updating only the properites of the columns in the library but not the details in the template. May it be that sth has changed and the function is not working anymore?
are you mapping the properties using MS Word desktop? then saving the document (not uploading to the doc library)? I used this feature recently...still works, but the properties must be mapped using MS Word desktop app
Can this be done with JSON data passed from powerapps? For example have the template uploaded like you do, then on the press of a button pass the data from 10 or so fields in JSON to power automate, then use that data to populate the fields in the template?
This works best with document properties in Word. I assume technically you could use Json and a find and replace, but you would need to "break open" the word file (aka the zip)
You're welcome! I'm glad you found the video helpful. Regarding your question about including a dynamic field for an image, that's definitely possible. In the same way that we used site columns to create placeholders for text fields, you can also create a site column that stores the URL of an image. Then, in your Word template, you can add an image placeholder and use the document property option to replace it with the dynamic image URL from the site column. Let me know if you have any further questions!
DeShon This is amazing, thank you! is there any other way to add document properties (i.e. vMake, vModel, etc) without creating the columns? I know there will be more fields I need to add after I get this working.
Thanks for checking this out. Adding the needed columns and mapping them to the template will be the ongoing maintenance story moving forward. It's not that bad, but definitely something I don't look forward to doing...just ensure ample testing when making changes post production
The columns *are* the document properties, or rather they're what make those properties available for the document. It's a drag but it's so worth it. If you add fields, remember to resave your "base" document ("the meat") back to the library so it can "see" the new fields.
I have not been able to crack the code on rich formatting and images piece. Signatures and dynamic images is a common ask. I think premium may be the way to go in those scenarios...just cleaner and easier to maintain. Note: you can centralize the process to where you only need premium for the svc account vs. everyone user of the app
really good solution for my application, you know if have a way to insert an image on this template? cause im trying to convert base64 to img based on a sharepoint column but till the moment i dont find this type of function
He DeShon, one question could we also do something similar with HTML files when it comes to injecting the values from the columns? So instead of a Word document we have a HTML file with placeholders. Hope you find the time to answer this question, thanks in advance.
Hey Paul, thanks for watching. I don't see any technical reason why you couldn't use the same for an HTML file. Because this process just deals with files in general. You may need to change it a bit to deal with the "content" of the file ..vs the metadata of the file ..that will be the main difference...hope this clarify the approach. Let m know how it goes.
@@DeShonClark didn't work out for me to get this working with a html file. With Word you have the quickparts through which you can map the fields, but in html offcourse not. Would you be willing to take a peak at this and see if you are able to make this work? I would be so gratefull if you could ;-)
Hi there.. Have used your fab instructions a number of times now but have hit a problem with 1 tenant. Every time I open the document in word it tells me it had unreadable content and asks if I want to recover the doc but even saying yes this fails. Ive opened a ticket with MS but was hoping you may have come across this before ?
Does this work with a standard Microsoft 365 subscription? I’m not running a business but would like to use this to collect data for planning a family reunion trip.
Hi, Thanks for sharing the idea, I followed all the steps but my new documents is the same as the template, no properties got filled in. Do you have any idea?
Hi Clark. So I did get this working beautifully for a couple of years, but then for some reason the "File Content" parameter doesn't stay put for the create file connector. It changes to "body" and the word template no longer gets populated with data. The file is being generated and attached in email, it's just not populated with the data. Is this a bug in the O365 environment ?
Did you figure this out yet? I'm facing the same problem over here. Whenever I "redo" this, it works for a couple of times. But then the data just gets added to the properties of the file, without the file using the properties...
Thanks, however the approach doesn't work for word online, because they still do not support quick parts. Liked the video though, learnt from it- but doesn't meet our needs May follow an alternate approach or stupid VBA
I know this is a late question but here goes. I'm trying to create a Standard Operating Procedure type document set. The body of the document is series of steps to be completed, each step in a different row of a table. Depending on the SOP this can be two steps or twenty. The data is to be stored in Excel online or lists. How do I generate a document that does not have the one-to-one field relationship as with this example, but with part of the document having one-to-many steps? Is this even possible? I'm thinking we need a step to generate a table in memory and somehow insert that table into the word document. Any thoughts?
thanks for watching. I love the idea. This would be so much simpler using the premium connector...just note, you can design this in a way to where the premium connector is contained to a single svc account (vs. every user of the app).
thanks for watching. Repeating tables are tricky. I plan to ask Paulie M on the LIVE Q&A session this Saturday. Check out the video for 7/31 and see if Paulie can share some insight on this
@@DeShonClark Any luck with this? I've checked out the videos but couldn't find anything. This would be incredibly helpful. Also, your videos are amazing.
Thanks for watching. Great question, I've actually haven't tried adding images using this pattern. I know that may be useful for other scenarios like signatures...I'll give it a try
@@DeShonClark Hello, excellent video, thanks for your dedication, I wanted to request help how to place an image within the word with the same method shown, please your answer, a greeting from Chile.
Great tutorial. Thanks for sharing this knowledge. I do not think HTML is supported in this format. If you are using plain text it is great but not for very complex template. Repeating table is also not supported using this logic.
Thank you for your comment! I appreciate your feedback. You're correct that this method is best suited for simpler templates without complex formatting or repeating tables. If you need to create more complex templates with HTML or repeating tables, you would need to explore other options or premium connectors. Let me know if you have any other questions!
What if instead of emailing the file you just want to save the file to sharepoint? I follow along until the email portion and the file that is created is a word doc with none of the Document Properties filled out.
I am trying to do this too. I tried "on new email receipt" - get attachment- attachment content- create file (file content = attachment content) But this returns the original template without the metadata added.
I'm actually saving the file to a doc library...which is how I am able to email it. I actually delete the file from the Lib after the email is sent. Also note: the document will NOT display metadata when launched in the browser...desktop app only for showing the doc with the metadata....or convert the file to PDF ua-cam.com/video/iW3J7RAyxOo/v-deo.html
Thank you for sharing that tip! That's a great way to save time and add the "Document Property" option to the ribbon for quick access. I'll definitely keep that in mind for future videos. Thanks again for watching and for your comment!
Hi, thanks for the video, very helpful. I tried this by creating a document library in sharepoint and was able to see document properties. I ended up using Microsoft lists instead (capturing form responses in a list). When I edit the columns in MS Lists it doesn't let me see these as document properties in word unfortunately. Any tips for doing this from lists?
First, thank you for watching. In order to get this to work for word documents inside of a template using site columns, the site columns must be on the document library. I think this is where you may need to change the approach a little bit. You can still use the SharePoint list to capture the data from a form, but copy the properties into a document library
I've done the same thing where a list triggers the flow and populates the data. I'm able to create the new document, and update the doc library meta data not the actual doc. The new doc isn't getting updated and keeps creating a blank new doc.
Darn! Doesn't work for me. I have a document library with a lot of columns, but when I create a new Word document inside that library, I don't see the columns listed under Quick Parts > Document Property. Any advice?
Yes, but I'm not sure if all the formatting gets pulled in like tables, bullet list, formatting, etc...i use it to bring in large text (over 256 chars)
DeShon you are now my first go to for PA solutions, amazing solution. Please continue with your innovation.👍
glad it help....welcome to the channel
This is such an innovative approach, thanks for sharing - avoiding premium connectors is so critical for my small company!
Awesome, thanks for watching. Glad it was helpful
Please continue to create content like this! I really appreciate your efforts & passion to teach people that there is always gonna be an easier way to do stuff without spending much on it. Your innovation is very inspiring. Thank you so much!
Thank you Ryu! I appreciate it
This is complicated as heck but I got it working. Thank you so much for these videos.
DeShon, I wanted to extend a big thanks for this genius work. Too many “marketing” videos trying to push premium connectors when there exist the possibilities to run this all without the extra expense. Bravo !! Subscribed !!
Awesome! Thanks for watching! In this day and age, we have to make sure our solutions are cost effective. I am working on a model that when a premium connector is needed, we can contain it to a service account and not for all users using the solution...more on this soon.
You are a life saver!! Works perfectly, and probably helped me to save few thousand dollar by not requiring the premium connector
Glad it worked out! Cheers
Your instruction was the only one that got my flow right! Thank you!!! Now I have to figure out if QuickParts can apply Rich Text formatting, but it's at least working.
awesome @Dale, glad it is working
Thank you so much for this tutorial! So far I found that I can only create an html file then convert it to pdf. This tutorial saved my day.
There is one limitation: the API does not accept text longer than 255 characters. I added a Sharepoint "update item" step to add multiline, long text to a field (e.g., "comments") of the Sharepoint list prior to the send email step. It worked. Note: if you open the docx in Sharepoint, it does not show the values of the fields. Open it in standalone MS Word (or from the email), the values will be visible.
awesome!
This was so incredibly helpful, clear, and amazing!! Thank you so much for sharing! I have paid for courses that taught me .08% of what you taught me in this one video. APPRECIATE IT!
I appreciate the feedback
This.Is.AWESOME!!! Exactly what I needed to do! Appreciate your ingenious work-around of premium connectors. Thank you!
thanks Sheila for watching!
Great walkthrough. I'm especially thankful that you leave the typical MS-Quirks in. I tend to begin to doubt myself whenever I need four tries to make powerautomate accept my inputs...Good to know that I'm not the only one...😂
thanks for the feedback....yes, it takes me several cycles to get it right.
Thank you so much for the idea....using word templates to create PDF is much easier than using HTML templates which I have done before!
You're welcome! I'm glad you found the idea of using word templates to create PDFs helpful. It can definitely be a simpler and more straightforward approach compared to using HTML templates. Let me know if you have any other questions or need further assistance!
Can you add images from image columns?
Wow! Thank you for this very helpful video. Incredibly useful for adapting to suit so many scenarios.
Glad it was helpful!
Thanks DeShon, you explained the whole thing even a newbie like me can understand.
Awesome! Thanks for watching
just discovered you - Excellent. Very clear, very helpful and thanks for focusing on non-premium solutions!!!!!! subscribed!!
Welcome aboard! thank you for watching
Thank you! This worked like a charm and saved me a HUGE amount of time fruitlessly looking for other solutions. Liked and Subscribed!
Thanks for the sub!
Awesome tutorial ! Thanks bro
Glad you liked it!
Is it possible to use Repeating control on Template this way?
Do you have an answer for this??
Thank you so much! This is exactly what I needed! You're amazing!!
You're so welcome!
I always can appreciate different approaches to solutions. I might use this for lower volume lists I manage to be able to offload the cloud flow to other users but in my case, I had to request the Premium add-on for Power Automate due to the amount of API calls we are projecting to use.
You made a very important distinction... there's no "one size fits all" when it comes to this stuff...thanks for watching.
Deshon, cant say thank you enough for this great video! Really helped me out, awesome stuff.
Awesome Anthony! Thanks for watching
He DeShon, this is a great video and I want to thank you for making it. For me, it enables me to make my Power Automate perform very dynamic. Great stuff.
awesome Paul! thanks for watching. I am checking out your channel man...great stuff
Thank you for making this video. I’m having trouble understanding how to get the dynamic content “make” , “model”, etc. from sharepoint to add to their respective fields when updating the template file data.
Hi Aaron, did you figure it out? Let me know if you want to jump on a screen-share...DM me on LinkedIN
Simply amazing and thorough. Thanks for sharing!!
thanks for watching
Amazing job ,Thanks from Syria .
thanks for watching!
Dude, this is so awesome! You rock! Thank you!
thank you for watching! I really do appreciate it Daniel!
Awesome video, DeShon. Was of GREAT help to my work. Keep it going and take care!!
Thank you so much for your kind words! I'm glad that the video was helpful for you. I'll definitely keep creating more content, so stay tuned for more. Take care as well!
Thanks for this. Very useful and informative.
Thanks for watching, I really do appreciate it
came for a tutorial, stayed for the vibe
Lol
That is way cool. Love your video format. thank you!!!
thanks G Mooney! I really do appreciate the feedback
Thank you! Great Video ... Exactly what I was looking for!
Hi DeShon - Love the solution. Question - Can you do this for repeating sections in the Word file?
This was extremely helpful! Thank you so much for this video.
Thanks for new way to create documents from power automate!
Thanks for watching
TY for the critical step of telling it to make a ".docx file"!
yes, a tricky one...mostly overlooked
Hi,
Thanks a lot for this amazing video.
I have some questions:
1 - Sometime i have a yellow message error: "a proper required property missing or invalid" but i still don't understand why
2 - If i want to add a new control, i need fist to add a column in my sharepoint list then add my template in this library, open the template and the new control ? then i have to save my template ?
Thanks a lot
Wow, thanks for this video Clark. This one helped me a lot. However I have one issue, my template has a repeating table, so how should my SP library look like? Should I have another library for the repeating table and connect that with main library using lookup columns?
Thanks for watching.... unfortunately this pattern does not support repeating sections at the moment
@@DeShonClark Thanks for the reply. BTW I found a solution using the inbuilt experimental PDF function in powerapps, you may want to check that out it is pretty easy.
Great video! Thanks. My only issue is that it creates the file, but does not update the content at all. Not sure if you could guide me?
I'm getting a lot of feedback that the values in the SharePoint library are not showing up in the word template. This happened to me when I was using word online versus the word application, I mean desktop app. Let me take a look and to confirm this approach still works with the latest updates
Thanks DeShon, great content! It helped a lot!!! ... quick question for you.. Can you include a dynamic field for an image as well?
This is one of the most common ask...images and tables...this technique does not support them, that would require a premium connector to use the Word Template proper
Great video. Thank you so much!!
thank you for watching
Thank you SO MUCH! This is a huge help!!
Glad it helped!
Can this process be used to add an image to the document? or does it only accept text.
Hello, did you ever work out if this is possible? I am trying to find a way to insert an image into my document but all my research points towards using the word connector which is now a premium feature
@@steviedb9 I spent days on Google trying to find out how to do this with no luck. Eventually I decided to tackle it a different way, hopefully this overview of my solution helps you. I have an audit in Powerapps; when a picture is taken it populates a corresponding Site Column which is formatted as "Multiple lines of text" in SharePoint. These fields are included in my Word doc template. When an audit is completed Power Automate populates the Word doc template and saves it to a library (and emails me). I manually download the populated Word doc and then run the following Macro ( I could probably automate this process but it's not crucial for me). As explained in the notes in the Macro the first step is to convert the Content Controls (Merge Fields) to plain text (if you don't do this step 2 doesn't work). Then it finds the image URL's, downloads the imges and resizes them. I have extra functionality in the Macro which handles various formatting tasks but no doubt you'll want a different look to what I want so I have left this out. Good luck. Dave
Sub Convert_Content_Control_to_PlainText()
'Convert Content Controls (Merge Fields) to plain text
Application.ScreenUpdating = False
Dim i As Long
With ActiveDocument
For i = .ContentControls.Count To 1 Step -1
With .ContentControls(i)
.LockContentControl = False
.Delete False
End With
Next
End With
Application.ScreenUpdating = True
'Find the URL's - download and embed the iamges and then resize them
Selection.HomeKey Unit:=wdStory
With Selection.Find
.ClearFormatting
.Text = "http*jpg"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = True
Do While .Execute
Dim imagePath As String
imagePath = Selection.Range.Text
imagePath = Right$(imagePath, Len(imagePath) - InStr(1, imagePath, ":\") + 2)
Dim SHP As InlineShape
Set SHP = Selection.InlineShapes.AddPicture(FileName:=imagePath, LinkToFile:=False, SaveWithDocument:=True)
SHP.LockAspectRatio = True
SHP.Height = InchesToPoints(6)
If SHP.Width > InchesToPoints(6) Then
SHP.Width = InchesToPoints(6)
End If
Loop
End With
End Sub
@@davidlacey7572, thanks for sharing!
I will try to go for an alternative, like exporting to PDF and them converting the PDF manually to Word. If I can make it work will let yall know
Great video DeShon, this has really helped me with my current flow and have used your convert to a PDF instructions also. I noticed in a previous comment some months ago you suggested you used an expression to remove the template value (document property) if the field is not populated, I have tried a few expressions but have had no luck, could you please share the expression you use to make the value blank/empty?
Hey Rob, hope all is well....on the update properties action this is what we are using...obviously update with your respective prop name:
if(empty(outputs('Get_item_-CustomerNumber')?['body/CustomerNumber']), ' ', outputs('Get_item_-_Item_Order')?['body/CustomerNumber'])
@@DeShonClark Perfect Thankyou
Great work and thanks for the effort. Great media voice as well. So easy to keep up with you and learn.
Thank you so much for your kind words! I'm glad you found the video easy to follow and learn from. I appreciate your support and encouragement! If you have any questions or need further assistance, feel free to let me know. Keep learning and have a great day!
Genious. Thanks a lot!
It tooks me hours to solve (I am new to PA!), but I'm almost there thanks to this video! Thanks @Deshon Clak. I have one minor problem though, I can't seem to work around: My final file get's created and updated BUT if I open it with Word in browser, it just shows the copied template start-point, however, when I open the very same file in Word desktop app it shows the correct populated data entries. How can that be? (I am thinking the best way around this is just to set the library to open files in desktop app as default). KR
First thanks for watching, this is a major power Automate for a first go around...kudos to you!!! This is a known issue and this is why we convert to PDF so the experience stays in the browser. You are working fine, this is a known issue
@@DeShonClark Great, I'll have a look at your pdf-video in that case! Only have one problem with this whole flow now, and that is multiple choice answers from the Forms submission doesn't transfer that well to list/doc. It bungles several answers into one choice, and then I manually have to change it form the choice dropdown and delete the bungled data. Any info/video or ideas how to get around this issue? (I can't seem to find anything useful in this regard on the microsoft forums).
Did you get this figured out...there is an option on the field to accept a collection.vs a single item for a multi select choice option
Amazing tips, man!! Thankssss
Thanks for watching
Thanks again for your great work
Thanks for watching I really do appreciate it
Great vid. Appreciate the share!
Thanks for watching!
Great Video, thanks. Would this work if you had multiple rows you needed to add to the word template rather than the single inserted row? let's say the insert was five rows with multiple times and dates and space requirements.
thanks for watching multiple rows and dynamic tables is a no-go for this. I would recommend going premium for those requirements and images. Note: you can design this is a way to where the premium is only required for the svc account and not all of the users of the solution
Hello, thanks for the great video. I have a problem I cannot solve, and maybe you can help me. I inserted 's date in my word template. The problem is that the date doesn't update. In practice, when I generate the PDF, the
Can you pass in today's date from power automate? Using the power automate expression?
Great Video, thanks a lot for your work and time.
Thank you so much for your kind words! I'm glad you found the video helpful. If you have any questions or need further assistance, feel free to let me know. I'm here to help!
Hi, Deshon, Thanks for youe great video, but I could not figure it out how you et up those customized properties /Fields in the quick access tool bar and also how it coudl show in properties field, for me it only shows the built in properties.
Nice video... congrats... One question: How can I insert gallery data to the word model? For example: Imagine I want to see in the same ticket, a list of the last 3 users that used the slot...
However, the question is: How to fill a list of data in Word templates?
Thanks for watching, this is an interesting scenario. Let me take a look and see if I can determine the best approach, we actually may need the premium connector for this. More to come soon.
@@DeShonClark Hi DeShon did you find a way to do this without the premium Connector?
I am trying to populate an invoice request and need to be able to handle an array of objects for the billing items properties.
Thanks for the great videos.
Please keep up the great work.
Beatiful!
Thank you! I'm glad you found the video helpful. If you have any questions or need further assistance, feel free to let me know.
Excelente información, me funciono perfecto, saludos desde Colombia
Gracias mi amiga, me alegro de que haya funcionado para ti!
Hi Deshon, thanks a lot for this brilliant tut! Any ideas on how to do it (editing and adding Document Properties) on Word for Mac? Because the toolbar is different and there's no button to do it... :(
I'm not 100% on how to pull this off on Word for MAC...I just assume the tool bars would be the same...sorry
Thank you for uploading this video. Very useful information :-)
Thanks for watching
Brilliant, just what I need. Is it possible to add a table to the word document and populate it with dynamic table data from a flow/sharepoint list using this method?
Creating a table inside of a word document, may require the premium connector for word. I will have to take a look and let you know
Hey DeShon, great content!! This has been super helpful. I was wondering, if I wanted to use Multiple Line Text instead of single line text, let's say for addresses or for open ended questions for something like a Mid-Year/End of Year Review, would I run into errors? Just wondering, what issues could the multiple line text option for a few site columns cause?
Yes you can! MLT is totally supported, and in most cases the formatted transfers over just fine. Jump in with both feet and give it a try
@@DeShonClark After some tinkering, it would appear that "Word Online" does not show MLT mapped values, single line works fine though. If you download the file then the MLT content does appear just fine. It's annoying that word online doesn't support these types of columns as it means my users have to download the documents to see all the values :( If you had any ideas on this, it would be greatly appreciated
Thanks DeShon for the amazong trick... however I'm stuck because the Quick Parts in Word isn't recognizing the fields from the SharePoint list, any thoughts on that?
Thanks again!
hey Marius, make sure you are using Word desktop app...not the Word online...then you should see the site columns pop-up when under Quick Parts. When clicking on the word file from within SharePoint document library...use the open in Desktop App...i think you should be good Bro
This is great, DeShon. Do you know if you can insert images in templates with QuickParts (or, in generale, without using the Word Online premium connector)?
hey Riccardo, this is one of the most common ask, but I have not found an "easy" way to accomplish this. inserting images and tables within a template may require the premium connector
@NICOLAS CORREA CAVIERES hey Nicolas, I got your message on ALL media outlets :-) I'll have to take a look, I assumed images and dynamic tables we just plug-n-play with the premium connector..let me try one....
do you have a usecase you would like me to use...you can keep it generic
Great video, thanks for putting this up. When i move my template docx file from the document library where the "v" columns are create to the shared document library, the tokens are no longer available. any suggestion?
Miguel, did you get this figured out?
Thank you for this. I don't get why Microsoft is seeing this as a premium connector
ikr, thanks for watching
hi thank you for the video very informative, is it possible to use the same approach for table and repeated headers, lets say the ItemLines will be also a single text and we can make it as repeated line in the template if we created a table?
thank you for watching...I have not tried this with tables, my gut says this will be a premium connector. Tables and embedded images prove to be a true challenge.
Life and job saver.
thanks for watching Opeyemi...glad it helped
Great video. Just what i needed. But to be Oliver Twist, is there any way to append images/pen input signatures using this method?
Thanks Edirin, that is a twist...we have several looking into this, but so far seems like the premium connector may be the easiest way, but we're still digging
Very useful process! Thanks! When the one to convert to PDF?
I'll get the converted PDF video drop soon.... stay tuned
nice one, Thank you Sir !
thanks Patrick, I really do appreciate the feedback!
Great Video! Thanks. But does it work with a repeated section on the word template?
Thank you for your comment! Yes, this method can work with a repeated section on the Word template. You would just need to set up your SharePoint site columns and map them to the placeholders in the template for each repeated section. The process would be the same, where you get the template content, create a new file, update the file properties, and then send the file as an attachment. Let me know if you have any further questions!
it's not working for me :( it's updating only the properites of the columns in the library but not the details in the template. May it be that sth has changed and the function is not working anymore?
are you mapping the properties using MS Word desktop? then saving the document (not uploading to the doc library)?
I used this feature recently...still works, but the properties must be mapped using MS Word desktop app
Can this be done with JSON data passed from powerapps? For example have the template uploaded like you do, then on the press of a button pass the data from 10 or so fields in JSON to power automate, then use that data to populate the fields in the template?
This works best with document properties in Word. I assume technically you could use Json and a find and replace, but you would need to "break open" the word file (aka the zip)
Thanks DeShon, appreciated! Can you include a dynamic field for an image as well?
You're welcome! I'm glad you found the video helpful. Regarding your question about including a dynamic field for an image, that's definitely possible. In the same way that we used site columns to create placeholders for text fields, you can also create a site column that stores the URL of an image. Then, in your Word template, you can add an image placeholder and use the document property option to replace it with the dynamic image URL from the site column. Let me know if you have any further questions!
DeShon This is amazing, thank you! is there any other way to add document properties (i.e. vMake, vModel, etc) without creating the columns? I know there will be more fields I need to add after I get this working.
Thanks for checking this out. Adding the needed columns and mapping them to the template will be the ongoing maintenance story moving forward. It's not that bad, but definitely something I don't look forward to doing...just ensure ample testing when making changes post production
The columns *are* the document properties, or rather they're what make those properties available for the document. It's a drag but it's so worth it. If you add fields, remember to resave your "base" document ("the meat") back to the library so it can "see" the new fields.
Nice video! Is it possible to do paragraphs, images, rich text etc. using this method?
I have not been able to crack the code on rich formatting and images piece. Signatures and dynamic images is a common ask. I think premium may be the way to go in those scenarios...just cleaner and easier to maintain. Note: you can centralize the process to where you only need premium for the svc account vs. everyone user of the app
really good solution for my application, you know if have a way to insert an image on this template? cause im trying to convert base64 to img based on a sharepoint column but till the moment i dont find this type of function
Thanks for watching...we have several people in the community trying to figure this out. I will keep trying when time permits
Hi Bro, Is it possible to add image using quick parts?
I'm planning to automate the signatures using this.
I have not explored this yet ..my guess is that you have to go premium connector with the Word action
He DeShon, one question could we also do something similar with HTML files when it comes to injecting the values from the columns? So instead of a Word document we have a HTML file with placeholders. Hope you find the time to answer this question, thanks in advance.
Hey Paul, thanks for watching. I don't see any technical reason why you couldn't use the same for an HTML file. Because this process just deals with files in general. You may need to change it a bit to deal with the "content" of the file ..vs the metadata of the file ..that will be the main difference...hope this clarify the approach. Let m know how it goes.
@@DeShonClark didn't work out for me to get this working with a html file. With Word you have the quickparts through which you can map the fields, but in html offcourse not. Would you be willing to take a peak at this and see if you are able to make this work? I would be so gratefull if you could ;-)
awesome! thanks
You're welcome! If you have any other questions or need further assistance, feel free to ask. I'm here to help!
Hi there.. Have used your fab instructions a number of times now but have hit a problem with 1 tenant. Every time I open the document in word it tells me it had unreadable content and asks if I want to recover the doc but even saying yes this fails. Ive opened a ticket with MS but was hoping you may have come across this before ?
Hi Deirdre, thanks again for watching...I have not hit this issue, can you please keep me posted? Thanks
Does this work with a standard Microsoft 365 subscription? I’m not running a business but would like to use this to collect data for planning a family reunion trip.
Hi, Thanks for sharing the idea, I followed all the steps but my new documents is the same as the template, no properties got filled in. Do you have any idea?
Thanks for watching...did you map them using Word desktop app (not Word in the browser)
Thank you very much ,
You are welcome!
What are the properties in the Document library for: 1. to create the properties in the word document or 2. to store data?
These are all site columns on the document.library
Fantastic!!! I really want to know how to convet to a pdf
Thanks for watching, the PDF conversion video was out... check it out
Hi Clark. So I did get this working beautifully for a couple of years, but then for some reason the "File Content" parameter doesn't stay put for the create file connector. It changes to "body" and the word template no longer gets populated with data. The file is being generated and attached in email, it's just not populated with the data. Is this a bug in the O365 environment ?
there may have been a changes in Power Automate...did you get this figured out?
Did you figure this out yet? I'm facing the same problem over here.
Whenever I "redo" this, it works for a couple of times. But then the data just gets added to the properties of the file, without the file using the properties...
Thanks, however the approach doesn't work for word online, because they still do not support quick parts. Liked the video though, learnt from it- but doesn't meet our needs
May follow an alternate approach or stupid VBA
check out Paulie M's video on this...he's a genius
ua-cam.com/video/dHW-rAqx7qM/v-deo.html
Cool. Love it.
Thank you! Cheers!
I know this is a late question but here goes. I'm trying to create a Standard Operating Procedure type document set. The body of the document is series of steps to be completed, each step in a different row of a table. Depending on the SOP this can be two steps or twenty. The data is to be stored in Excel online or lists. How do I generate a document that does not have the one-to-one field relationship as with this example, but with part of the document having one-to-many steps? Is this even possible?
I'm thinking we need a step to generate a table in memory and somehow insert that table into the word document. Any thoughts?
thanks for watching. I love the idea. This would be so much simpler using the premium connector...just note, you can design this in a way to where the premium connector is contained to a single svc account (vs. every user of the app).
@@DeShonClark I’m looking forward to this as a new video. There will be many who could use this functionality in their workflows.
Does anyone know a way to insert a Document Property as a hyperlink?
I haven't tried that one
DeShon, how can you get the document properties to show the value sections if you are using Word on a Mac? It does not show on the insert tab
Yikes!!!!! I'm not that familiar with Word capabilities on Mac....thought this would be feature parody with Word across platforms...
Hi! Nice! How populate repeating section (table multiple rows)?
thanks for watching. Repeating tables are tricky. I plan to ask Paulie M on the LIVE Q&A session this Saturday. Check out the video for 7/31 and see if Paulie can share some insight on this
@@DeShonClark Any luck with this? I've checked out the videos but couldn't find anything. This would be incredibly helpful. Also, your videos are amazing.
Thanks for the video. I have a question, can images be added without premium connectors?
Thanks for watching. Great question, I've actually haven't tried adding images using this pattern. I know that may be useful for other scenarios like signatures...I'll give it a try
@@DeShonClark Did you get a chance to look at it yet? Also curious if this works with images and signatures. Great content. Cheers from Norway.
@@DeShonClark Hello, excellent video, thanks for your dedication, I wanted to request help how to place an image within the word with the same method shown, please your answer, a greeting from Chile.
Great tutorial. Thanks for sharing this knowledge. I do not think HTML is supported in this format. If you are using plain text it is great but not for very complex template. Repeating table is also not supported using this logic.
Thank you for your comment! I appreciate your feedback. You're correct that this method is best suited for simpler templates without complex formatting or repeating tables. If you need to create more complex templates with HTML or repeating tables, you would need to explore other options or premium connectors. Let me know if you have any other questions!
the flow is really good, but it is showing me "invalid template" save error.
Ganesh, did you figure this out?
What if instead of emailing the file you just want to save the file to sharepoint? I follow along until the email portion and the file that is created is a word doc with none of the Document Properties filled out.
I am trying to do this too.
I tried "on new email receipt" - get attachment- attachment content- create file (file content = attachment content)
But this returns the original template without the metadata added.
I'm actually saving the file to a doc library...which is how I am able to email it. I actually delete the file from the Lib after the email is sent. Also note: the document will NOT display metadata when launched in the browser...desktop app only for showing the doc with the metadata....or convert the file to PDF
ua-cam.com/video/iW3J7RAyxOo/v-deo.html
Oh and btw: select a property and then right click on the 'save to gallery', then you can add it to the ribbon :)
Thank you for sharing that tip! That's a great way to save time and add the "Document Property" option to the ribbon for quick access. I'll definitely keep that in mind for future videos. Thanks again for watching and for your comment!
Hi, thanks for the video, very helpful. I tried this by creating a document library in sharepoint and was able to see document properties. I ended up using Microsoft lists instead (capturing form responses in a list). When I edit the columns in MS Lists it doesn't let me see these as document properties in word unfortunately. Any tips for doing this from lists?
First, thank you for watching. In order to get this to work for word documents inside of a template using site columns, the site columns must be on the document library. I think this is where you may need to change the approach a little bit. You can still use the SharePoint list to capture the data from a form, but copy the properties into a document library
I've done the same thing where a list triggers the flow and populates the data. I'm able to create the new document, and update the doc library meta data not the actual doc. The new doc isn't getting updated and keeps creating a blank new doc.
@@gabrielvazquez81 Hitting the same snag. Were you able to get past this?
Darn! Doesn't work for me. I have a document library with a lot of columns, but when I create a new Word document inside that library, I don't see the columns listed under Quick Parts > Document Property. Any advice?
Try opening with desktop app of word
@@DeShonClarkThank you! That did the trick.
Should this work with list that have enhanced rich text?
Yes, but I'm not sure if all the formatting gets pulled in like tables, bullet list, formatting, etc...i use it to bring in large text (over 256 chars)
Thanks!@@DeShonClark