Populate a MS Word template with an image from SP list

[Sahlberg]

Hi

I have saved an image (signature from Power Apps) to a sharepoint list and I want to populate a word template with this signature.

I have a flow that works perfect for all the other list content but not the image.

Have saved the signature in SP both as PNG and BinaryData but I don't find out how to add it to word.

I've read lots of posts about this but I can't find a clear flow description.
Can someone help a newbie?!?!

[ChristianAbata]

hi @Sahlberg  you can follow this video Embed a CDS Image in a Word Template using Power Automate flow - YouTube

[v-dezhili-msft]

Hi @Sahlberg ,

Could you please tell me where the picture is saved in SharePoint?
Can you show the flow you have now?
The Populate a Microsoft Word template action expects the base64 data of the image.
The required data format is as follows:

or

My test:

Best Regards,

Dezhi

[Sahlberg]

Thanks, but that do not work when I have the saved image in a sharepoint list.

[v-dezhili-msft]

Hi @Sahlberg ,

Is your picture saved in the image column or the attachment column?

Best Regards,

Dezhi

[Sahlberg]

I have the image in a image column as a png.

I tryed also to save it in a "Multiple lines of text" column as base64

[Sahlberg]

Thanks Dezhi

Looks gereat!

I built a flow as your exaple but got error alredy in "Get file content" about file content.

In what format must the image be stored in sharepoint?

About the two Compose: shall I have both or just one?

[v-dezhili-msft]

Hi @Sahlberg ,

I did another test for your reference.

body('Send_an_HTTP_request_to_SharePoint')?['d']?['results']

concat(json(item()?['Img'])?['serverUrl'],json(item()?['Img'])?['serverRelativeUrl'])

Best Regards,

Dezhi

[Sahlberg]

Hi Dezhi

I put your flow into mine but got problems with "Send an HTTP..." Uri.

Tryed tu use: _api/Web/List/getByTitle('Entreprenader')/items?$filter=ID eq id&$select=Grundsignatur

id from a earlier step in my flow.

Error Details:

Cannot find resource for the request List.
clientRequestId: 3b95b27f-c70e-4f10-b217-034e6a3e12a0
serviceRequestId: 4d1ea1a0-f0e2-6000-483b-3ed7e7bf44de

Can you help me to solve this?

[v-dezhili-msft]

Hi @Sahlberg ,

You're just missing an "S".

_api/Web/Lists/getByTitle('Entreprenader')/items?$filter=ID eq id&$select=Grundsignatur

Best Regards,

Dezhi

[Sahlberg]

Thanks Dezhi

I must be blind!?

But when  I fixed that i got a strange error: 

"The field or property 'Grundsignatur' does not exist.
clientRequestId: fd61b3db-76de-4181-b838-6bf2d2f1d8f3
serviceRequestId: 5652a1a0-9061-6000-483b-3909dbf72a4c"

The column does exist, I did even copy the name from SP to be shure.

And it is a Image column looking like this in settings:

Grundsignatur

Thumbnail

[v-dezhili-msft]

Hi @Sahlberg ,

Try to check whether your image column is in the body without using the query condition.

Best Regards,

Dezhi

[Sahlberg]

Thanks DeZhi

I run that and coud see that the name of th file was "Grundsign" not "Grundsignatur"

Rememer i shanged that a while ago, but thats strange that the old name is kept!

But still problems: The action "Send an HHP request" runs for ever and do not give an ansver or error message.

Can it depends on that i just wrote "ID eq id" and that it do not rekognise this "id"?

Shall I put some action before "Send an HTTP" to be sure that I can use "id"?

[v-dezhili-msft · Accepted solution]

Hi @Sahlberg ，

You could try hardcoding an ID test that already exists in your list.

Best Regards,

Dezhi

[Aaron13]

 Hi Dezhi,

I can get this to work with multiple images ( signatures).  I have a power app that is a sign off sheet for 15 people. if only 3 people sign on i get errors for images 4-15. is there a function i can use in the word template step of the flow that if there isn't an image it stays blank?  I keep getting an error if there is no image.