Logic app how to get a file uploaded in microsoft forms

Question

I have a microsoft form where I attach a file (an excel) and I want to get this file and parse the content in Logic App. When I get the file, I receive an array like this:

{
  "name":"FileName.xlsx",
  "link":"https://xxxx-my.sharepoint.com/personal/xxx/_layouts/15/Doc.aspx?sourcedoc=xxxx",
  "id":"the Id",
  "type":null,
  "size":10310,
  "referenceId":"the reference Id",
  "driveId":"the drive Id",
  "status":1,
  "uploadSessionUrl":null
}

I don't know if I can get from this link the document or if there is another way to get the excel content uploaded in the microsoft form. Please, help me!

Answer 1

Reproduced the same issue and it's working fine, follow the below steps to get the content of uploaded file

An overview of the complete azure logic apps procedure

In SharePoint you can go and check your files in the list you have created.

Answer 2

I found the solution and here it is.

Steps:

Now the specifications:

{
"items": {
    "properties": {
        "driveId": {
            "type": "string"
        },
        "id": {
            "type": "string"
        },
        "link": {
            "type": "string"
        },
        "name": {
            "type": "string"
        },
        "referenceId": {
            "type": "string"
        },
        "size": {
            "type": "integer"
        },
        "status": {
            "type": "integer"
        },
        "type": {},
        "uploadSessionUrl": {}
    },
    "required": [
        "name",
        "link",
        "id",
        "type",
        "size",
        "referenceId",
        "driveId",
        "status",
        "uploadSessionUrl"
    ],
    "type": "object"
},
"type": "array"

}

That gives you an output JSON with the excel table data. I hope it helps! Regards!