Extract negative responses from Microsoft Forms

Viktoriia Moskalenko 0 Reputation points
2025-05-06T15:20:16.33+00:00

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

User's image

Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.Publishing: The process of preparing, producing, and releasing content for distribution or sale.
688 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.