cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hiroyalty
Frequent Visitor

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

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 flowGeneral flowfile propertiesfile propertiesget file identifierget file identifiergenerate ROW objectgenerate ROW objectrow into a tablerow into a tableset variable.png

10 REPLIES 10
v-JessicaG-msft
Community Support
Community Support

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" . set variable.png

Anonymous
Not applicable

@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
Helper I
Helper I

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
Frequent Visitor

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

 

emcaleer
Frequent Visitor

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
Frequent Visitor

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
Helper I
Helper I

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

runn_on
Frequent Visitor

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

runn_on_0-1664288742866.png

runn_on_1-1664288772304.png

Hopefully, this will you. 

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,263)