I've been having problems with update row not being able to find row ID even though the value was present in the Excel file.
I have two forms. The first form generates an application ID which is added to the table and is sent to the person entering the second form, which they enter into the form. This helps match up to separate forms with new information.
On my automation I set up a dynamic key value that populates from the second form entry. But no matter what I try it can't find the row ID. I've tried debugging this with AI for about a year, and it still doesn't work. Even when I manually enter in the value rather than have a dynamic value it still won't find it.
I've tried creating new tables in case the formatting was wrong, I've tried generating application codes that contain letter not just numbers, get row, delete row. Nothing works
Please help I am getting desperate.... But I just can't give up! It will save me so much time if I can get this to work.