Populating Word Template with Images in Power Automate & Power Apps
Vložit
- čas přidán 25. 07. 2024
- The previous video on how to set up the Word Template is here: • Populating Word Docume...
This video does use 1 premium license with a Word Connector to Power Automate. Once again we use a scheduled flow to keep license costs lower.
We first populate an image in a template using the Picture Content Control in Microsoft word. Then we hook that Flow up to a Power App which finally pulls in the picture name and populates are template dynamically. No base64, no conversion, just get the file path and write our documents to SharePoint.
Thank you all for watching my name is Andrew Hess!
Chapters:
0:00 Introduction
0:59 Setting up the Template
2:30 Simply do in Power Automate
5:10 Let's Use Power Apps to Populate our Document
8:49 Update Power Automate to use Power Apps data
10:21 Changing the Datacard to a Combobox
13:00 Previewing the Image in Power Apps
14:00 Conclusion - Věda a technologie
Great Video ! It really helped me. Is there any way i can do this with multiple imiges and texts ? I want to create a Word Document with an unknown amount of Pictures and Texts.
Nice one
Thank you Praveen! Thanks for watching 😃
Great Video Andrew! I can manage to get the List data in the word document, now could you please advise to get the Multiple images from SharePoint List to Word document through Automate. Many Thanks🙂
Just now seeing your message Purnachandu, I'll write this one down.
thank you very much. Yet i would have like to have your advice for populating Word document with images stored in Sharepoint List, for example an inspection with observations, within the form there are 3 observations (text field), and 3 images per observation. I can manage to get the text data in the word document, now could you please advise to get the image from SharePoint List to Word document through Automate, Many thanks in advance.
Really This was helpful! I have multiple images in SharePoint lookup column from Picture library, may be 2, 3 or more images.How should I handle this in Word template using power automate?
Hi Priyanka, I would stay away from the SharePoint LookUp column and directly link to the picture library and pull the pictures from there in Power Apps.
Thanks for this, however the image somehow get rotated.. any tip to avoid this?
Great Video Andrew!!! What about if you would have to populate Word table with "n" images from your Sharepoint list (where n is a variable value). Can you give us an example of that?
Hi Armando, is "n" a random number of images, or is "n" 1 random image of many images that you may have?
@@andrewhess123 First option we would be adding a bunch of images to include in a Word Table
This is helpful thank you, but if we are receiving the image from the users, we don't know the aspect ratio of the image they are uploading.
The picture control ends up stretching the image to the fixed size of the control.
Is there any way we can make the picture control dynamic so that it can preserve the original image's aspect ratio?
A little bit it depends on how the pictures are viewed and some of the code, with HTML and CSS you can adjust the aspect ratio. But the way HTML is read through the browser of Outlook and the client is different. There are options like:
imagekit.io/blog/how-to-resize-image-in-html/
You would need to experiment which option works best for you, you can also do percentages instead of exact width and height too.
do you know if it is possible to insert images stored as Base64 string in the repeating section of the Word template? I am trying now and they all result in blank squares
So it looks like you can not do Base64 in Word. According to this article: learn.microsoft.com/en-us/answers/questions/1324557/is-word-document-read-base64-image-format
I believe if you tried a pdf it might work? Or maybe there is some way to convert it with Power Automate before reaching word.
Incredible, I am impressed that all that I need to my work project, U just make a video. This help a lot, thank U so much for all the help.
I have a question about this word template. In my project I have a list of records, that increases with new records all the time.
I want put all theses record in the word template. How can I do it? Because it's unknow how many records will be, so I don´t know how proceed.
If U coulde give me a light. Thank U
I have an idea, but it might be a 3rd party tool. So it may cost more. But II have an idea! Thanks for watching Guiherme!
@@andrewhess123 Thank you for a great video. Yes I'm a big fan of Shane's so it was great that you referenced his videos. If you are ok with mentioned another content provider I'd recommend Power Automate - Populate Word Template (Convert to PDF) by Ben Fetters. If not, please just delete this comment but I went through powerusers_microsoft_com, ChatGPT, etc. and several other resources and videos on repeating content control and how to handle project specific needs including Boolean fields [wich do not work between Power Automate and Word (booo as Shane would say)]. Anyway I iterate (Apply to each [P.Auto.] & Repeating Section Conent Control [Word]) to do what I believe @GuilhermeDSa wants to do primarily utilizing the content from Fetters' video. Thanks again. Great video. Love how you build to more advanced use cases. I wish more content providers took that approach. Well done!
is it possible to place an image in a text control ?
I don't think so, although I have never tried. It could be possible if the file was .html instead of .docx then you convert it from html to docx.
@@andrewhess123
Thanks will try that
I cant understand till now there is no way to print invoices natively, other than going to premium license etc. and my understanding is Microsoft want to force user to buy premium license that's all.
Probably true, I do have that other video creating templates without premium but it is limited in functionality. But you can run a premium flow on a schedule with 1 account. And then repurpose that account for many flows. So then you can try to get your money's worth. 😀