Hello,
I have a flow built to automatically add some characters in front of a form response as soon as a new response is submitted to my form. My problem is that in my testing the flow will work correctly some of the time, but it seems like it fails if I submit two or three responses to the form in quick succession. Only having correctly edited the first form response. The error that I get is that the unique serial number that I want to edit cannot be found, however when I check my excel table with the form responses, the serial number is there. Why can my flow not find the new numbers after a couple quick form responses have been submitted?
Here is my flow:
This is my flow, below is basically a rerun of the first sequence, set up to run after the first "update a row" fails, however it does not help the problem.
The second get response details, is set to re run after the first one fails, however it does not help.
The error code I get
The results table where I can always clearly find the Registration Number in the table that the flow cannot find.
This is the results table, for example, flow will error and tell me that registration number 29483939 cannot be found if it was submitted in quick succession after the previous form response.
