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?
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.
I have added the screenshot of the "varIdentifier" here, also I do not have any variable or column name "clientRequestId" .
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 is not a variable in my flow or the table.
I am getting the same error as you got in the 2-15-2022 post. Were you able to find a solution for:
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.