Insert JPG file (Picture) from HTTP Request in Word document

[seryil]

Hi all,

I have an HTTP Request in my cloud flow where I get data (JSON format) from a third-party API. In my response, I have a field with a URL to a specific picture (JPG format). I have created a Picture Content Control inside the Word document, and I need to insert the picture into this control.

I don't want to save the picture in OneDrive or SharePoint. I want to insert it directly.

I hope someone can help 🙂

[fchopo]

Hello @seryil 

The image should be converted to base64 before passing its value to Word. So the steps would be:

Hope it helps!

Ferran

[seryil]

Hi @fchopo,

Thank you for your reply. I tried it and it doesn't work. Will this method work for URL images? And how would you do it if it was through SharePoint (saving the image in SharePoint)?

[Paulie78]

If I understand your question properly, you don't receive the image in your API response, only a URL. You will need to use the HTTP action first, with the URL that you receive in your API response to download the content of the image into your flow. You can then use the content from the HTTP request in your word connector and follow the instructions provided by @fchopo . Does that help? (The HTTP action is premium, so you will need a premium license).

[seryil]

Hi @Paulie78,

The HTTP request is not a problem. I've fixed that.

[seryil]

@fchopo @Paulie78 

The picture is inside of a repeating section content control in the Word Document. Could that be why it doesn't work?

[fchopo]

Hi @seryil 

I don't really know the answer to your last question, but I would try the same flow and using another simple Word document, where time image control is not in a repeating section.

Please, let us know if that's the problem!

Regards,
Ferran

[seryil]

Hi @fchopo 

It seems that Word doesn't support images within a repeating section content control: Support Image Controls within the Repeating Sectio... - Power Platform Community (microsoft.com).

But I think I can make a work around by saving the image in SharePoint and then replace the text in the table with the image stored in SharePoint. But I can't save the image I get from my API (URL image) in SharePoint. Is it something you can help me with?

I get the following message:

Do I need to convert the URL to Base64?

[fchopo]

Hello @seryil 

You should use dataUriToBinary function. Have a look at this sample (although I know your image is coming from an API and not from Power Apps): Taking a picture with PowerApps and sending to SharePoint with just Flow — John Liu .NET

Hope it helps!

Ferran

[seryil]

Hi @fchopo ,

But shouldn't I convert the URL to dataUri first, before I can convert it to Binary?

This is what I get from my JSON (string type):

"value": "https://test.cloudfront.net/test.jpg"

And I want to save this image to SharePoint 🙂

[fchopo]

Hi @seryil 

I've done this test on my side, and it's working:

Hope it helps!

Ferran