Forms with excel attachment to SP List Http request failed

[sudosaurus]

Hello,

I am having trouble getting data from an excel document into a SharePoint list and am receiving this error on my workflow:
The workflow seems to work as far as creating the file in a SharePoint document library however fails on the list rows present in table action. As ideally I want to copy data from the rows into a SharePoint list - any pointers on getting this working would be awesome! Thanks 🙂

Http request failed: the content was not a valid JSON.

This is my flow:

The next step, parses JSON from the File attachment item in the Microsoft Forms form.

JSON:

{

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

}

[Mira_Ghaly]

@sudosaurus

So if you are getting the file from the response details it is not giving u the direct url so you need to get the url part only of the file without the name part.

Try passing the link for example from parse json output. 

[sudosaurus]

This is the full output of a test run. So it does everything up to the point of "List rows present in a table".

[Mira_Ghaly]

@sudosaurus

So list rows in a table is reading the file you have created on the previous step?

[sudosaurus]

Yeah, sorry just corrected my flow to look at the file created in SharePoint and now the excel row action is presenting this error:

No table was found with the name 'Table1'.
clientRequestId: db80284a-5440-418b-8148-0c80457e4a3b
serviceRequestId: 81bc923c-cbe2-4115-97cc-d427b9d56f62

I can see the table name is there in the document so I'm not sure why it says it cant find it?