Power Platform Community Forum Thread Details

Hello,

I am needing some help building a Power Automate Flow. I am running into a persistent error, which is using the "Invoke an HTTP Request" connector.

"The number of rows or columns in the input array doesn't match the size or dimensions of the range.",
 
My goal is sending rows to an Excel Table using an API call. I am following the documentation HERE, and HERE.
 
My Excel Table is of range A1:E2 -
 
I am using a Select to grab the records I need.
 
 
This is the input:
If you expand the Select Output, it looks like this:
{

    "values":  [[["Large Cantaloupes","1","FirstName LastName","2024-02-14","NA"],["Large Cantaloupes","10","FirstName LastName","2024-02-14","NA"]]]

}
 
This is a concatenated version of the real output, it is maybe a thousand records long.
 
I added the last "NA" because I do not wish to fill the E Column with this Flow, and I assumed the reason I was getting the error was I had only 4 values for a 5-column table.
 
I have also tried putting "" and a null expression. All result in the same error. Removing the 5th value in the Select Array also results in the same error. In fact, no matter what I do, I get the same error. At this stage I can only believe that the error I'm getting is not the real issue, but I have no idea what is: everything looks to be according to the documentation. Any help would be very much appreciated. Below is the full error.
{
    "statusCode": 400,
    "headers": {
        "Cache-Control": "no-cache",
        "Transfer-Encoding": "chunked",
        "Vary": "Accept-Encoding",
        "Strict-Transport-Security": "max-age=31536000",
        "request-id": "776564e0-475c-446f-a22c-96069533dc91",
        "client-request-id": "776564e0-475c-446f-a22c-96069533dc91",
        "x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"East US\",\"Slice\":\"E\",\"Ring\":\"5\",\"ScaleUnit\":\"003\",\"RoleInstance\":\"BL6PEPF0000F2F3\"}}",
        "x-ms-tenant-id": "f337e457-c830-4e93-a876-88edf099e715",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Thu, 15 Aug 2024 20:30:19 GMT",
        "Content-Type": "application/json",
        "Content-Length": "523"
    },
    "body": {
        "error": {
            "code": "InvalidArgument",
            "message": "The number of rows or columns in the input array doesn't match the size or dimensions of the range.",
            "innerError": {
                "code": "invalidArgument",
                "message": "The number of rows or columns in the input array doesn't match the size or dimensions of the range.",
                "date": "2024-08-15T20:30:19",
                "request-id": "776564e0-475c-446f-a22c-96069533dc91",
                "client-request-id": "776564e0-475c-446f-a22c-96069533dc91"
            }
        }
    }
}
 

Categories:

General topics

Update - leaving this here in case anyone else encounters this.

Unfortunately, I could not get this to work as the documentation suggested it might, which was to dump all the rows with one request.

The error comes from attempting to put in more than one row at a time. Reducing the API call to only one row by enumerating it through an Apply to Each resolved my issue, although did not improve performance much over the "Add Rows" Excel Connector.

However, it is MUCH more reliable than the "Add Rows" Excel Connector, and did generate all 2500 records into the Table without randomly stopping or getting hung for no reason. So I will still be using this method, even though it did take probably a half hour to create the records.