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

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

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?

[CamiloLuque]

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.

[Kmmille25]

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.

[CamiloLuque · Accepted solution]

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. 

[Kmmille25]

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!