cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sudosaurus
Post Prodigy
Post Prodigy

Forms with excel attachment to SP List Http request failed

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.

 

sudosaurus_0-1614765014106.png


This is my flow:

sudosaurus_1-1614765073214.png


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

sudosaurus_2-1614765106246.png

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


applytoeach.png

listrows.png

4 REPLIES 4
Mira_Ghaly
Dual Super User II
Dual Super User II

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

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

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

sudosaurus_0-1614766677785.png

 

Mira_Ghaly
Dual Super User II
Dual Super User II

@sudosaurus

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

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

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?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,722)