Hi @M3vswrld ,
I found a solution I wrote awhile back that is really close to your scope of work. Here's the flow.
My first condition (which may not be applicable to yours, is to check if one of the form answers was Supplier. I'm going to describe all the steps even if they don't specifically match yours so you understand the entire flow. But I do cover update a row or add a row...
Let's assume that the form response was Supplier, so on this side of the conditional block, I have this group of actions. Here I want to check if the company name is already in my excel sheet. So the first action is to list rows present in a table (I want all rows).
Next in my Condition 2 action, if the form response question Enter your company name = the excel column "Company Name" ...
I will update a row or if not found, add a row.
Now, on the Update a row action, you need to specify a Key column. I used Company name. From here, it's just populating both actions with the dynamic content from your Get responses action, shown below.
To summarize, you don't need the first conditional action that has the "Supplier", you would not need that one. Your conditional action to check Regs numbers would go where I check the company name (Condition 2).
