Action add a row into a table failed, A value must be provided for item. clientRequestId

[hiroyalty]

I am trying to create a record in Excel on a JotForm submit,  but I am getting errors "Action 'Add_a_row_into_a_table' failed" and Error details: "A value must be provided for item. clientRequestId".

As show in the attached images, I generate the Excel file name dynamically and using the get file Properties I was able to get the file Identifier and insert a formated ROW object which I am inserting to the Excel file.

I use some default values in places with empty values, but still not working.

Please what am I doing wrong?General flowfile propertiesget file identifiergenerate ROW objectrow into a table

[v-JessicaG-msft]

Hi @hiroyalty ,

Could you show me a screenshot of set the "varIdenififier" variable? You could check if the value of the "clientRequestId" item is empty or not recognized in the flow.

Best Regards,

Jessica Gu

[hiroyalty]

Hi Jessica,

I have added the screenshot of the "varIdentifier" here, also I do not have any variable or column name "clientRequestId" .

[Anonymous]

@v-JessicaG-msft 

Are you able to provide any more help on this? I'm getting the same error and there don't seem to be any posts answering this question.

"A value must be provided for item.
clientRequestId: 05396859-0362-4711-82b0-9bd26f8ae9b7"

clientRequestId is not a variable in my flow or the table.

thanks!

[vernariesaco]

solved my similar problem using this solution https://powerusers.microsoft.com/t5/General-Power-Automate/Power-Automate-Add-a-Row-into-a-Table-Exc... 

[runn_on]

I am getting the same error as you got in the 2-15-2022 post. Were you able to find a solution for:

"clientRequestId: 05396859-0362-4711-82b0-9bd26f8ae9b7"

Thank you!

[runn_on]

I checked for "." or any "special character" and had none. This did not solve the issue.  

[emcaleer]

Hi - I was wondering if this was ever resolved? I am having the same issue. There are no special characters in my data, and it updates to another excel fine but when I go to add it to a dynamic table that has more columns, it has the same error. I can't seem to find a solution anywhere. 

[vookie]

I have exactly the same issue, all columns have proper names, I've checked it few times already.

Did anybody managed to resolve the issue?

[vernariesaco]

have you tried using column names with no spacing at all and no special characters?

[runn_on]

It is only by accident that I found my Excel action should be in a specific order which is:

Hopefully, this will you. 

[JeffreyJ1]

Change your variable from "String" to "Object." Also make sure your JSON keys match your column names exactly. 

Here's what worked for me:

1) Initialize variable outside your loop. (Name: ROW DATA; Type: Object; Value: (leave blank))

2) Set variable inside loop (select "ROW DATA" - the var you just created in Step 1 - and for Value, enter JSON with key/value pairs matching column names and dynamic data. Use spaces, Capital Letters, I even have a column named "Deposited?" and included the ? in my JSON as shown below  -- just type keys exactly as your column is named in Excel). Also, for me, I did not need quotes around the values/dynamic data. For example:

{

 "Name": dynamic value,

 "Column Name2": dynamic value,

 "Third Column?": dynamic value

}

3) Complete "Add row to table" step as normal, using your "ROW DATA" 

[blini]

this solved my problem