Populating Word Template with Images in Power Automate & Power Apps

No video

Populating Word Template with Images in Power Automate & Power Apps

Рет қаралды 7,124

Күн бұрын

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

Пікірлер: 24

@praveeng3921 7 ай бұрын

Nice one

@andrewhess123 7 ай бұрын

Thank you Praveen! Thanks for watching 😃

@Manu-st3zu 4 ай бұрын

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.

@purnachandupippirisetti2421 6 ай бұрын

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🙂

@andrewhess123 3 ай бұрын

Just now seeing your message Purnachandu, I'll write this one down.

@yocopop 6 ай бұрын

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.

@knightfury13 2 ай бұрын

Thanks for this, however the image somehow get rotated.. any tip to avoid this?

@priyankaahinave9606 6 ай бұрын

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?

@andrewhess123 6 ай бұрын

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.

@armandoita5774 6 ай бұрын

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?

@andrewhess123 6 ай бұрын

Hi Armando, is "n" a random number of images, or is "n" 1 random image of many images that you may have?

@armandoita5774 6 ай бұрын

@@andrewhess123 First option we would be adding a bunch of images to include in a Word Table

@DaniOdicho 4 ай бұрын

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?

@andrewhess123 4 ай бұрын

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.

@GuilhermeDSa 7 ай бұрын

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

@andrewhess123 7 ай бұрын

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!

@djstone5518 5 ай бұрын

@@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!

@RADUCI1968 3 ай бұрын

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

@andrewhess123 3 ай бұрын

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.

@Lokesh.Singara 4 ай бұрын

is it possible to place an image in a text control ?

@andrewhess123 4 ай бұрын

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.

@Lokesh.Singara 4 ай бұрын

@@andrewhess123 Thanks will try that

@basehumax 7 ай бұрын

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.

@andrewhess123 7 ай бұрын

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. 😀