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

BadRequest on create table action

On my Excel Create table action, I am getting a "BadRequest" error when the workflow is run:

 

sudosaurus_1-1647974043989.png

sudosaurus_2-1647974063836.png


Output Body >

{
  "status": 400,
  "message": "The argument is invalid or missing or has an incorrect format.\r\nclientRequestId: a64d7e6a-7d3e-41eb-9393-79498449def2\r\nserviceRequestId: b6e32cce-df35-487b-a6f8-5dcbc45885c9;06939309-6560-4502-acef-9c323bdd38ce",
  "error": {
    "message": "The argument is invalid or missing or has an incorrect format."
  },
  "source": "excelonline-uks.logic-ase-uksouth.p.azurewebsites.net"
}

 This is my action:

sudosaurus_3-1647974166131.png

 

This was previously working, before I added additional columns today of TrimmedPersonReference;Position;Level3Structure;Exec DirectorEmail;

All the other columns were already there and working - the Table range used to be "StaffDeclarations!A1:K90" however I've extended this to A1:O90 due to the additional columns being added.

 

Not sure if anyone can work out what's up with this?

4 REPLIES 4
Swarna
Microsoft
Microsoft

For static directly we can provide the table range.

Try adding quotes : You need to specify the number of rows in the table range

Swarna_0-1647977321000.png

 

sudosaurus
Post Prodigy
Post Prodigy

@Swarna I can't use 'Name' as the first part of that as there's nothing to get "Name" from as Create Table is the first action in the workflow with the SharePoint When a file is added being the trigger.

 

Like I said, this was working earlier with these settings so I'm not sure what has changed?!

 

Raw Input

{
    "method": "post",
    "queries": {
        "source": "sites/ondomain.sharepoint.com,8eee44d7-c244-43fc-8926-22c12434fbb0,afa5791e-9246-4caf-86c8-1862fdc5e862"
    },
    "path": "/drives/b%2110TujkTC_EOJJiLBJDT7sB55pa9Gkq9MhsgYYv3F6GK1xKLly_PuS7jlROhDhwQU/files/Shared%25252bDocuments%2525252fiTrent%2525252fColleagueDataMarch18.xlsx/tables",
    "host": {
        "connection": {
            "name": "/subscriptions/b87b5098-699e-4b1a-abef-b7b89e4d3a80/resourceGroups/RG-App-Support-Dev/providers/Microsoft.Web/connections/excelonlinebusiness"
        }
    },
    "body": {
        "ColumnsNames": "PersonalReference;Email;PreferedName;Manager;JoiningDate;LeavingDate;BirthAbsenceStart;BirthAbsenceAnticipatedEnd;LongTermSickAbsenceStart;LongTermSickAbsenceAnticipatedEnd;Exec Director;",
        "Range": "Sheet1!A1:K90",
        "TableName": "iTrentData"
    }
}

 

sudosaurus_0-1647987596681.png

sudosaurus_1-1647987627983.png

Raw Output

{
    "statusCode": 200,
    "headers": {
        "Pragma": "no-cache",
        "Vary": "Accept-Encoding",
        "x-ms-request-id": "233bb576-2500-48aa-9fb3-3cce7edbdcac;62535d11-158b-43dd-a18b-cc068e3a62cb;1b62cac4-5d2b-4ff3-852c-4584f44f35c2;01a46a50-707b-423a-b28f-24a797cfcfab;d1b219dc-e051-46fa-9fd0-f7627a110924;d1cc9106-8d6e-4cda-9e6b-5a447bea3128;2eedae17-0cac-41e9-8f04-f8e63b5589c4;f0efba32-3bd5-4f3f-8c57-2356f539be5b",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "Cache-Control": "no-store, no-cache",
        "Set-Cookie": "ARRAffinity=4327f3090a5b43f7b4821c2374826cd7a580e763791307bcfff20f84a98b5c22;Path=/;HttpOnly;Secure;Domain=excelonline-uks.logic-ase-uksouth.p.azurewebsites.net,ARRAffinitySameSite=4327f3090a5b43f7b4821c2374826cd7a580e763791307bcfff20f84a98b5c22;Path=/;HttpOnly;SameSite=None;Secure;Domain=excelonline-uks.logic-ase-uksouth.p.azurewebsites.net",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "x-ms-apihub-obo": "true",
        "Date": "Fri, 18 Mar 2022 14:26:45 GMT",
        "Content-Type": "application/json; charset=utf-8",
        "Expires": "-1",
        "Content-Length": "2739"
    },
    "body": {
        "name": "{F7537351-D439-4E01-8256-DCA838404037}",
        "title": "iTrentData",
        "x-ms-permission": "read-write",
        "x-ms-capabilities": {
            "sortRestrictions": {
                "sortable": true
            },
            "filterRestrictions": {
                "filterable": true
            },
            "filterFunctionSupport": [
                "eq",
                "ne",
                "substringof",
                "contains",
                "startswith",
                "endswith"
            ]
        },
        "schema": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "PersonalReference": {
                        "type": "string",
                        "title": "PersonalReference",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    },
                    "Email": {
                        "type": "string",
                        "title": "Email",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    },
                    "PreferedName": {
                        "type": "string",
                        "title": "PreferedName",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    },
                    "Manager": {
                        "type": "string",
                        "title": "Manager",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    },
                    "JoiningDate": {
                        "type": "string",
                        "title": "JoiningDate",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "format": "date-time",
                        "x-ms-permission": "read-write"
                    },
                    "LeavingDate": {
                        "type": "string",
                        "title": "LeavingDate",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    },
                    "BirthAbsenceStart": {
                        "type": "string",
                        "title": "BirthAbsenceStart",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    },
                    "BirthAbsenceAnticipatedEnd": {
                        "type": "string",
                        "title": "BirthAbsenceAnticipatedEnd",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    },
                    "LongTermSickAbsenceStart": {
                        "type": "string",
                        "title": "LongTermSickAbsenceStart",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    },
                    "LongTermSickAbsenceAnticipatedEnd": {
                        "type": "string",
                        "title": "LongTermSickAbsenceAnticipatedEnd",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    },
                    "Exec Director": {
                        "type": "string",
                        "title": "Exec Director",
                        "x-ms-sort": "none",
                        "x-ms-capabilities": {
                            "filterFunctions": [
                                "eq",
                                "ne",
                                "substringof",
                                "contains",
                                "startswith",
                                "endswith"
                            ]
                        },
                        "x-ms-permission": "read-write"
                    }
                }
            }
        }
    }
}

 

Swarna
Microsoft
Microsoft

What if you specify the sheets in single quotes on table range

KvB1
Solution Sage
Solution Sage

Weird, 

 

What I would do is remove the columns you added, see if it works, then re-add them one by one

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,489)