Filter answered questions in Microsoft Forms

(1) Share

Report

Posted on by _maaaaavs_

125

Hello! I need help with filtering all the answered question in my Forms.

I have over 20 questions in my Forms, but due to branching, the user wont be able to asnwer all of that.

Is there a way to filter only all answered questions in my Forms using Power Automate?

Also, In the future, I will use the Start and Wait for Approval action and I would like to put all answered questions in body of the email.
In theory, it would look like this:

Question 1: Answer 1
Question 2: Answer 2
Question 3: Answer 3
Question 4: Answer 4

Is it possible? Hoping you can help me guys. Thank you so much.

Categories:

Business Process Flows

All responses (3)

Answers (0)

Suggested answer

trice602 10,944 on at

Like (0)

Report

Filter answered questions in Microsoft Forms

Hi,

You can but not sure I understand why. It's 6 of one or 1/2 dozen of the other. Simply put, you could write a loop that checks each answer and appends another variable ~ it' going to achieve the same thing and the amount of expression development doesn't really change.

On that note, if you don't want your answers all on new lines in an approval or email; write the expressions back-to-back on a single line (with a space in-between) so if someone answers questions, 1, 4, 8, 11, 15, and 20 - all 6 responses are written on a single paragraph or collection of responses.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn
_maaaaavs_ 125 on at

Like (0)

Report

Filter answered questions in Microsoft Forms

Hi, @trice602

Thank you for answering. But is there a way to put it a single expression? What I'm trying to achieve is to not put it one by one. Is it possible?
Suggested answer

trice602 10,944 on at

Like (1)

Report

Filter answered questions in Microsoft Forms

Hi,

This is perfect (the formatting) but works well. The key here is to check if the question output is empty, if true, return nothing, if not empty concat the question label 'Question1: ' with the output from the question.

In my test, I didn't answer question 2 or 4. Email results:

Here's the expression:

if(empty(outputs('Get_response_details')?['body/r5472ee9200824079934861ed707ba64d']),'',concat('Question1: ',outputs('Get_response_details')?['body/r5472ee9200824079934861ed707ba64d']))

Above you replace outputs('Get_response_details')?['body/r5472ee9200824079934861ed707ba64d'] with the dynamic content of question1 (in my example). Repeat the if(empty()) expression for questions 2, 3, and 4 shown below.

So then from there, you can also put these expressions into your approval flow and if the question was answered, they will appear in the approve content.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn