Extract negative responses from Microsoft Forms
Hello Community, I have a task and not sure how to complete: Microsoft form has 3 branches, starting point is from Q1: morning, afternoon, evening , Each of this section (morning, afternoon, evening) has inside 15-17 questions, completely different from morning, afternoon and evening. The answers only: Yes and Other (manual input from user) for all questions. The admin should recieve a notification for Q1 (for example morning) and answers with questions which only marked Other: user`s manual input. (e.g: Q2. Did you have breakfast? Yes , I had a cereal with tea)
I have set var for : morning, afternoon, evening. It is populating fine. There is an issue to extract almost 50 answers on 50 questions, I have used compose to see if the manual input values could append there (but it works only with Yes option); Current logic is quite inproductive: if Q1 == morning, admin recieve all answers to the email address, but admin required to see only manual input. I will be grateful for an advice, maybe someone resoved similar issue recenly.
Best regards, Vi