Unanswered

Getting Sharepoint image and displaying in Word template

(0) Share

Report

Posted on by Albertax

111

Hi, I am having issue with my Flow where i cannot get my image from a SP list to display within the word document. It just outputs the string.

This is my flow below

When an item is created
Get the items
Compose > Take the image from the SP List and put it into a Base64 string
Output it within my Popuplate Microsoft Word Template

Screenshot 2023-05-10 at 9.27.33 AM.png

This is where i put it into the Word template:

This is what my end result is - I get the base64 string under Contact details

Where as ideally i want the image from the Sharepoint list to output

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

HenWang Microsoft Employee on at

Like (0)

Report
Hi @Albertax ,

If you are trying to get the image to display in your word template, you need the file content value to put inside this word template.
Demo flow:

1. you need to add an image control into your word template so that it can display the image:

2. Send an HTTP request to SharePoint:

Uri:
_api/web/Lists/getByTitle('test')/items(@{triggerBody()?['ID']})?$select=image

You can just copy and paste it in your flow, but please be noted that the image string after "$select= " is actually the logic name of my image column in SP list, please change it according to your own image column name.

3. Initialize variable:

json(body('Send_an_HTTP_request_to_SharePoint')?['d']['Image'])['fileName']

4. get file content using path
Fiel path:
/SiteAssets/Lists/List_id/@{variables('image name')}
You can find the list id value in any flow run history, for example, you can find it in the input of your trigger:

5. populate the word:

Hope this can help.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Albertax 111 on at

Like (1)

Report

@HenWang Thank you for taking the time to do such a detailed explanation, and for your response.

I have been debugging this flow more most of morning, and am struggling to get past this step :
Unable to process template language expressions in action 'Initialize_variable' inputs at line '0' and column '0': 'The template language expression 'json(json(body('Send_an_HTTP_request_to_SharePoint')?['ID']['Images'])['fileName'])' cannot be evaluated because property 'Images' cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.

Any ides?

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report
Hi @Albertax ,

After checking, you will need to use "Image" instead of "Images" in the json expression from your side.

Also, please delete the first json in your expression.

This is your expression:
json(json(body('Send_an_HTTP_request_to_SharePoint')?['ID']['Images'])['fileName'])

And below is the correct expression that you can directly copy and paste in your flow:
json(body('Send_an_HTTP_request_to_SharePoint')?['d']['Image'])['fileName']

Was this reply helpful? Yes No
Albertax 111 on at

Like (0)

Report

Thanks again for your reply, I am getting back an error:
The image is not of type PNG or JPG. Please provide an image of type PNG or JPG.
clientRequestId: 5eae9a7f-6de2-4499-a587-545e3c64192b

I have attempted to change the variable to Object, as suggested in another post. To no luck. And i've also attempted to see where i output the variable to only grab the first, and it doesn't seem to do anything.

I'm at a loss here. Should I be converting the image to a base64 image?

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report

Hi @Albertax ,

For this error, do you have the image column in your sharepoint list?

According to the error, it seems that the image you write into the list is not with type PNG or JPG. Maybe you can check the above two points to further decide what is next step for you.

By the way, which action get failed in your flow? is it the initialize variable action?

Best Regards,
Hen Wang

Was this reply helpful? Yes No