Unanswered

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

(0) Share

Report

Posted on by 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 🙂

I have the same question (0)

All responses (10)

Answers (0)

fchopo 8,001 Moderator on at

Like (1)

Report

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

Hello @seryil

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

Hope it helps!

Ferran

Was this reply helpful? Yes No
seryil 18 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Paulie78 8,418 Moderator on at

Like (0)

Report

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

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).

Was this reply helpful? Yes No
seryil 18 on at

Like (1)

Report

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

Hi @Paulie78,

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

Was this reply helpful? Yes No
seryil 18 on at

Like (0)

Report

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

@fchopo @Paulie78

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

Was this reply helpful? Yes No
fchopo 8,001 Moderator on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
seryil 18 on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No
fchopo 8,001 Moderator on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
seryil 18 on at

Like (0)

Report

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

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 🙂

Was this reply helpful? Yes No
fchopo 8,001 Moderator on at

Like (0)

Report

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

Hi @seryil

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

Hope it helps!

Ferran

Was this reply helpful? Yes No