Unanswered

MS Forms + Power Automate: Emailing Incorrect Answers

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I have created a flow that takes my Forms Quiz responses and emails them out to different people depending on the location selected in the quiz.

The form I have created is an audit form of sorts that is littered with 141 yes/no questions. I am hoping that the body of the email can show only the wrong answers. Here is how it's currently set:

Under 'Findings' I would like to avoid listed every single answer and only display the questions they got wrong. How can I go about doing this?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You could try something like this:

concat( if(equals(Q1,'true'),'Q1:false',''), if(equals(Q2,'true'),'Q2:false',''), if(equals(Q3,'false'),'Q3:true',''), ..... )

Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for that, @v-bofeng-msft.

Unfortunately, I get an error when testing that out. I copied/pasted what you wrote and replaced the 'Q1', etc. with the actual questions and it came back as an invalid expression when using 'concat'.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you please show me your expression and the error?

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Here's what I'm putting:

concat(if(equals(outputs('Get_response_details')?['body/r15fc1d75a9bc4eb2b5372b875ed89ce8'],'true'),'outputs('Get_response_details')?['body/r15fc1d75a9bc4eb2b5372b875ed89ce8']:false
Thanks for your patience and working with me on this, @v-bofeng-msft !

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please try:

concat( if( equals(outputs('Get_response_details')?['body/r15fc1d75a9bc4eb2b5372b875ed89ce8'],'true'), 'Q1:False' ) )

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I was able to paste the code and save the flow; however, an error popped up while running it:

Thoughts?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please try:

concat( if( equals(outputs('Get_response_details')?['body/r15fc1d75a9bc4eb2b5372b875ed89ce8'],'true'), 'Q1:False', '' ) )

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Apologies for the delay in response.

It did let me use the code without error; however, it didn't show the failed item. Am I to replace the 'Q1' with the question or leave it as is?

Was this reply helpful? Yes No