Answered

Power Automate: Insert image from a SharePoint list into a field for a Microsoft template

(0) Share

Report

Posted on by CE-16101943-0

Every day several people will walk a process line at our site and complete audits. The results of these audits are saved to a SharePoint list and then with a Power Automate flow that triggers on item (Audit) created/update. If the audit is complete the information is copied into a word template and emailed out to the necessary parties.

The issue I am having is including the SharePoint list image into the word template. The error I continue to see is the file is not of type jpeg or png. The forum I found on this is here:

How to: Add images to a Word Template using MS Flow (bythedevs.com)

It seems to align with what is said on Microsoft's Documentation. Word Online (Business) - Connectors | Microsoft Learn

The only difference I can see is that my file content comes from the SharePoint "get file content" rather than the one drive "get file content". I can successfully embed the image in an email so I can at least verify that the SharePoint "get file content" is successful, but I can't put it in the word template.

Does anyone know the method to do this?

Categories:

General topics

All responses (3)

Answers (1)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@ce_PowerPlay

Construct a compose and add the below mapping

{
"$content-type": "image/jpeg",
"$content": " SharePoint Image encoded blob"
}

Finally map the output compose to your word template.
CE-16101943-0 81 on at

Like
a
(0)

Report
Copy link

Link copied!

I created an object variable and set the value, but no change. One thing I do notice is that for the word template field under dynamic options the object variable is not present.
Verified answer

CE-16101943-0 81 on at

Like
a
(0)

Report
Copy link

Link copied!

I was able to work out the solution. As you said I had to construct a "compose" not "set variable". The only additional action I had to do was convert the file content to a base64 encoded string. To summarize the full solution of taking a SharePoint list image and using it in a Microsoft word template:
1. Review this forums step by step instructions on how to get an image from a SharePoint list: Get SharePoint List Image in Power Automate - Torben Pedersen
2. Once you have the image file content construct a compose as SudeepGhatakNZ said. The base64 function looks like this-> base64(body('Get_file_content'))
3. Put the compose output into the Microsoft Image Field.