Unanswered

Adding image from url onto excel

(0) Share

Report

Posted on by Community Power Pla...

I am trying to make a flow where, on submission of a Microsoft form (which contains text and pictures) all the data is added to an excel sheet based on specific user inputs to on my OneDrive business folder. The issues are

1) All the images appear in url formats (Would like a solution or workaround so that the urls can directly be placed as images with specified length and breadth)

My workaround was to integrate a macro to run, unfortunately flow doesn't support macros yet.

Another idea of mine is to use [Step1] MS forms functions "Get response details" and from there use [Step2] the OneDrive functionality 'upload file from url' and [Step3] append it to the excel sheet via 'add a row into a table'

I am facing an issue where the output of Step1 is a mix of image name and other detail:

[{"name":"Sketch_anonymous4.png","link":"blahblahblah","id":"01Y36AVBWQRVMU5OICULRMH","type":null,"size":187170,"referenceId":"01Y3L6J2XFMN6JFYDCYYVUEBOSEA","driveId":"b!1Rb8u9oIBkaS4c6swILxkmJsj8ehx1mFYlbVTI21yrgRKfh","status":1,"uploadSessionUrl":null}]

and this input for Step2 brings up an error where the image cannot be retrieved properly.

Any workarounds or a solution to the provided issue will be of great help for me

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

Gareth1 308 on at

Like (1)

Report

Re: Adding image from url onto excel

Hi @Anonymous

In regards to Step1 the response for the file upload is JSON and needs to be parsed before it can be used.
A couple of months ago I uploaded a video to YouTube and recently put together an article with some additional information. Which can be found at the link below

https://garethhunt.io/index.php/2019/12/29/saving-attachments-with-microsoft-forms-and-power-automate-flow/

The only part I am not sure on is adding the image to an excel file

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (1)

Report

Re: Adding image from url onto excel

Hi @Anonymous,

You could get file content after you get response details of MS Form according to @Gareth1 's method, and if you want to upload the file to the excel file, you can create share link of the file, then update a row of the Excel file, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Adding image from url onto excel

Hi @Gareth1 and @v-litu-msft

Your video was very helpful and the link has been extracted as expected. Thanks for the tip @Gareth1 !

The second step as suggested by @v-litu-msft has yielded results but in an unexpected way!
Which I will elaborate in a reply to @v-litu-msft
Thanks guys!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Adding image from url onto excel

Hi @v-litu-msft

The below images depict my situation as of now, Any help which helps me add the url directly instead of the "question mark" will help my situation!
The solution works as expected, under the same conditions you've postedImage is viewed as depicted

Was this reply helpful? Yes No
GFernandez94 2 on at

Like (0)

Report

Re: Adding image from url onto excel

Hi! Did you find a solution? I'm facing the same issue here. I can paste the URL of the image on an Excel table, but I can't paste the actual image.

Was this reply helpful? Yes No
dga 20 on at

Like (0)

Report

Re: Adding image from url onto excel

Hi,

Did you manage to find the solution?

Di

Was this reply helpful? Yes No
Zrl 3 on at

Like (0)

Report

Re: Adding image from url onto excel

Hi,

I encountered the same problem. did you find the solution?

Was this reply helpful? Yes No
dga 20 on at

Like (2)

Report

Re: Adding image from url onto excel

No, I have stopped looking now, am satisfied with a link instead.

Was this reply helpful? Yes No
Andry 2 on at

Like (0)

Report

Re: Adding image from url onto excel

Hi, I have flow that use direct link.. but since it have been retired. I tried to replace it with get file content and my data are uploaded to excel except for image url, I get an error respond is not JSON format (In want to upload image url in excel from form responses). Does anybody have idea how to do it?

Was this reply helpful? Yes No