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 flow
file properties
get file identifier
generate ROW object
row into a table
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
Hi Jessica,
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: 05396859-0362-4711-82b0-9bd26f8ae9b7"
clientRequestId is not a variable in my flow or the table.
thanks!
solved my similar problem using this solution https://powerusers.microsoft.com/t5/General-Power-Automate/Power-Automate-Add-a-Row-into-a-Table-Exc...
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!
I checked for "." or any "special character" and had none. This did not solve the issue.
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.
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?
have you tried using column names with no spacing at all and no special characters?
It is only by accident that I found my Excel action should be in a specific order which is:
Hopefully, this will you.