Unanswered

Get Microsoft Forms responses - only branched answered questions

(0) Share

Report

Posted on by JM16

Hello,

I created a form with approximately 60 questions, multiple branches and sections. Is it possible to get the answers of only the branched questions answered using power automate? Have the answers (only the questions answered on each submission) go into an excel, pdf, or email.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @JM16

By default the Get response details captures answer to all questions, when branched question is not answer- the dynamic content of that response would be empty

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
JM16 2 on at

Like (0)

Report

Yes, I know but is it possible to only pull the answers to the questions that were answered without having to show all the blanks? I don't have a way of knowing which questions the user will answer because it will depend on the branching. I want to know if it's possible with power automate to get responses for only the questions answered every time there is a submission and create a file or excel.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @JM16

With current power automate actions - it won't be possible to get the values for those only answered in ms forms.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No