Unanswered

Populate a MS Word template with an image from SP list

(1) Share

Report

Posted on by Sahlberg

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

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Sahlberg 16 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Sahlberg ,

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

Best Regards,
Dezhi

Was this reply helpful? Yes No
Sahlberg 16 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sahlberg 16 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (1)

Report
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

Was this reply helpful? Yes No
Sahlberg 16 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Hi @Sahlberg ,

You're just missing an "S".
_api/Web/Lists/getByTitle('Entreprenader')/items?$filter=ID eq id&$select=Grundsignatur

Best Regards,
Dezhi

Was this reply helpful? Yes No
Sahlberg 16 on at

Like (0)

Report

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

Was this reply helpful? Yes No