cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Adding image from url onto excel

 

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

 

 
2 ACCEPTED SOLUTIONS

Accepted Solutions
Gareth1
Resolver IV
Resolver IV

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

View solution in original post

v-litu-msft
Community Support
Community Support

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:

Annotation 2020-01-09 151047.png

 

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.

View solution in original post

9 REPLIES 9
Gareth1
Resolver IV
Resolver IV

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
Community Support
Community Support

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:

Annotation 2020-01-09 151047.png

 

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
Not applicable

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
Not applicable

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 postedThe solution works as expected, under the same conditions you've postedImage is viewed as depictedImage is viewed as depicted

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
Frequent Visitor

Hi,

 

Did you manage to find the solution?

 

Di

Zrl
Frequent Visitor

Hi, 

 

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

dga
Frequent Visitor

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

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?WhatsApp Image 2022-01-20 at 16.00.18.jpeg

 

 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,874)