Answered

MS Forms Submitting Image into MS Lists as an image (In an image column)

(0) Share

Report

Posted on by Kmmille25

Good afternoon!

I'm working on a flow that allows internal users to submit a helpdesk ticket using an MS Form. The last item on the form is a file upload that allows the user to submit images for error messages, screenshots, etc.

MS Form.png

I have already built a flow that takes the input from the user and pushes it into the designated MS List.

One of the columns in the helpdesk MS List is an Image column. I'd like to get the images displayed in that column instead of a link to attachments stored on my OneDrive.

Is something like this possible?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

CamiloLuque 157 on at

Like (1)

Report
Hi @Kmmille25, try to change the list for a library. The flow will copy the file content from OneDrive to the library in SharePoint. See the pic.

In the "Parse JSON" action use substring expression to extract the JSON to obtain the name and id of the file.

Substring expression:

substring(outputs('Get_response_details')?['body/rc51aa6a9845a4d0eb8246f863e7cfd30'],1,sub(indexOf(outputs('Get_response_details')?['body/rc51aa6a9845a4d0eb8246f863e7cfd30'],']'),1))

Schema JSON:

{ "type": "object", "properties": { "name": { "type": "string" }, "link": { "type": "string" }, "id": { "type": "string" }, "type": {}, "size": { "type": "integer" }, "referenceId": { "type": "string" }, "driveId": { "type": "string" }, "status": { "type": "integer" }, "uploadSessionUrl": {} } }

You can use the last action in the 1st pic to update the columns in your library.

Was this reply helpful? Yes No
Kmmille25 52 on at

Like (1)

Report

Thank you for the information!

This information is actually going into a Microsoft List, so I don't have the option to change it to a document library, unfortunately.

I was able to pull the attachments into the list using the following guide: Save Forms Attachments to List but unfortunately, it doesn't appear in the actual list itself, but rather in the edit pane.

Was this reply helpful? Yes No
Verified answer

CamiloLuque 157 on at

Like (1)

Report

Hi @Kmmille25, MS Lists has an Image column type, this column display a thumbnail. From Power Automate you can’t reach this column, so you can test using Power Automate Desktop.

Was this reply helpful? Yes No
Kmmille25 52 on at

Like (0)

Report

I'm afraid you're correct. I need to learn more about what PAD can do and how the two tools can work together.

Thank you for your input and help!

Was this reply helpful? Yes No