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

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.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (4,368)