You’re offline. This is a read only version of the page.
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
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?
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.
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 posted
Image is viewed as depicted
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!
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.
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
The only part I am not sure on is adding the image to an excel file
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (