To begin, you may run into an issue of updating your target Excel file if the form triggers multiple times quickly, one instance of the flow will have the target Excel open for editing and the next won't be able to open it and will fail. So we'll need to adjust the trigger to make sure only one instance of the flow runs at a time. Let's do that part first!
On your trigger action, open the Settings
and make sure Split On is enabled (this will allow multiple triggers at the same time if forms are rapidly completed) AND that Concurrency Control is on and set to 1 (this will require one flow instance to complete before the next begins)
Alright, with that out of the way let's get into the meat and potatoes of the issue.
Checking the output of a form completion, we see the results are in an object (not an array) we can work with:
Now let's get into the rest of the flow:
First we're creating an Array variable to store the answers. This is because we have to extract the answers from our object into an array we can iterate through. Then we loop through that array, with a Condition checking:
for the value we're seeking (in my case, Option 5, in your case, Not applicable) and take the appropriate actions based on that outcome.
If this comment resolved your issue, please remember to mark it as the answer.
