Logic app Excel online - add a row into a table connector - 400 error 'a value must be provided for item'

Question

Logic app Excel online - add a row into a table connector - 400 error 'a value must be provided for item'

Oscar Pickering 1

I have a logic app that has 3 instances of the excel add a row into a table connector. They add a row into a table in a .xlsx file created earlier in the logic app based on 1 of 3 templates .xlsx files, all with tables set up in them. They are all populated by the same variables (that are set to differing values based on the preceding logic app actions). 2 of the 3 connectors function completely fine, however 1 constantly returns the error in the title -
{
"status": 400,
"message": "A value must be provided for item.\r\nclientRequestId: 2b07c89d-4d9a-4316-aff1-df269785ff52",
"error": {
"message": "A value must be provided for item."
},
"source": "excelonline-we.azconn-we.p.azurewebsites.net"
}

The inputs are all valid values and none of the table items are missing. The set up between the 3 connectors is effectively identical, barring the specific content in the body, which as mentioned does not have any invalid or missing values, so I do not understand why this one connector won't work.

Any advice or suggestion to get around this error would be greatly appreciated. Thanks.

Ryan Hill 30,326 Reputation points Microsoft Employee Moderator

2021-11-24T14:39:46.337+00:00

Can you include a screen shot of your Logic app model @Oscar Pickering ? My initial guess is that your issue is either a concurrency issue or a read/write lock.
Oscar Pickering 1 Reputation point

2021-11-26T10:39:50.157+00:00

This is the connector that's failing.

And this is one of the two that isn't. They're both nested in identical until loops, so no concurrency settings. They both write to the same sharepoint location, just using slightly different file templates. As mentioned above, there's effectively no difference between them bar the body, which is valid for both.

Your answer

Ryan Hill 30,326 Reputation points Microsoft Employee Moderator

2021-11-24T14:39:46.337+00:00

Can you include a screen shot of your Logic app model @Oscar Pickering ? My initial guess is that your issue is either a concurrency issue or a read/write lock.
Oscar Pickering 1 Reputation point

2021-11-26T10:39:50.157+00:00

This is the connector that's failing.

And this is one of the two that isn't. They're both nested in identical until loops, so no concurrency settings. They both write to the same sharepoint location, just using slightly different file templates. As mentioned above, there's effectively no difference between them bar the body, which is valid for both.

Share via

Logic app Excel online - add a row into a table connector - 400 error 'a value must be provided for item'

Your answer