1

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!

Aaron Palazon
  • 43
  • 5

2 Answers2

1

I found the solution and here it is.

Steps:

enter image description here

Now the specifications:

enter image description here

Parse JSON schema

{
"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"

}

enter image description here

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

Aaron Palazon
  • 43
  • 5
0

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 enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

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

RajkumarPalnati
  • 541
  • 2
  • 6
  • 1
    Hello! Thank you for your answer but I cound't do it well :( Instead off, I found another solution wich I will publish in another answer. – Aaron Palazon Jun 13 '22 at 11:05