Adding image from url onto excel

[Anonymous]

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

[Gareth1 · Accepted solution]

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

[v-litu-msft · Accepted solution]

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.

[Anonymous]

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!

[Anonymous]

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

[GFernandez94]

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.

[dga]

Hi,

Did you manage to find the solution?

Di

[Zrl]

Hi, 

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

[dga]

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

[Andry]

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?