Add Row To Table Excel Block

[varex_mike]

I'm having trouble with an automation the deletes and rebuilds an Excel file on SharePoint. This is my flow:

The "Add Row To Table" gets this error:

I'm not sure which property is wrecking it. Maybe the Row? I've entered the names of the columns of the table.

Material, Material Description, Total Open Qty, Inventory Qty, Build Qty

any ideas?

Thanks!

Mike

[priscilarubim]

Hi @varex_mike ,

Could the issue be related to the file recreation? When the Excel file is deleted and rebuilt from scratch, the table needs to be recreated as a named Table object inside Excel...just having the data in the spreadsheet is not enough. If the "Add Row To Table" block runs before the table is properly created and named, it won't find what it's looking for and will return that error.

Another possibility: have you checked if the column names in the Row field match exactly the table headers, including spaces and capitalization?

Just a guess though!