so I've created a flow which puts answers that were submitted in a MS Forms into a SharePoint List. After that it "scans" the answers and creates a endresult depending on them.
There are multiple questions with the same selection of answers. There are 4 in total:
3. Not applicable
4. Not reviewed yet
And 3 different endresults:
2. Not approved
3. Approved but revisit
The way the endresults are supposed to work is like this:
1. If all the answers are "yes" or "Not applicable" -> Approved
2. If there is one or more "no" answer -> Not approved
3. If there is one or more "Not reviewed yet" answer -> Approved but revisit
In this case the "no" has a higher priority than the "Not reviewed yet".
The 2. and the 3. endresults are working. I also managed to make the flow put the "approved" endresult in when every answer is yes. But I didnt make it work for answers when there is e.g. "yes" in 3 answers and "Not applicable" in the other one.
This is how my flow looks:
The "If yes" part looks the same as the other connectors . It is clear to me that this is wrong but , I just testet some things out here.