
Hi, I have a flow that adds a row to an Excel table from a jotform submission. But that form then can be edited with additional information added. How can I then update the row in Excel? The closest I've gotten just adds a new row with the complete information but then I have 2 rows for the same submission, one complete, one half complete. Is there a way of replacing the half completed row or deleting it, thereby just leaving the complete one? They have a unique ID.
Hi @DEBS1644
Once the response is submitted, then you can use Get Row action where you need to pass the unique ID
So, you need to place a condition that if that finds a row in the excel go to update a row or else go to Add a row in table
For reference, check below post
If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION
Thanks,
Srini