cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Resolver IV
Resolver IV

Re: Adding image from url onto excel

Hi @Anirudh230 

 

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

 

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

View solution in original post

Highlighted
Community Support
Community Support

Re: Adding image from url onto excel

Hi @Anirudh230,

 

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

5 REPLIES 5
Highlighted
Resolver IV
Resolver IV

Re: Adding image from url onto excel

Hi @Anirudh230 

 

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

 

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

View solution in original post

Highlighted
Community Support
Community Support

Re: Adding image from url onto excel

Hi @Anirudh230,

 

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

Highlighted
Frequent Visitor

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!

Highlighted
Frequent Visitor

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

Highlighted
New Member

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.

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (7,766)