web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / forms with multiple qu...
Power Automate
Unanswered

forms with multiple question, output to HTML - need to exclude non-answered questions in the HTML report.

(0) ShareShare
ReportReport
Posted on by 9

Hello Experts,

 

I created a flow that send a notification to the responder's email when a new response is submitted in Forms, get the answers, create a HTML file with all Questions and answers in it, save it in the SharePoint, then send an email to the responders with the HTML file. All this works so far.

 

Woking HTML flow.PNG

 

What I am trying to do is to exclude the questions that are not answered. 

At this point with the html code, I am including all items, but how to exclude the non-answered question from the output ?

Flow with HTML.PNG

I've tried with condition, but I have 30 questions and require to add this in 1 single file.

Here how it looks, but not working as per expectation, so there should be another option.

I shouldn't create a file right after the yes, but should be something else. 

I don't want to have the output as Add row in excel as once I complete the HTML, I would like to customize the output in Excel.

Flow with condition.PNG

Should I have 30 conditions? or Apply to each, but with the 30 variables in it ?

Any suggestions?

 

Thanks!

Categories:
I have the same question (0)
  • SylvainCorney Profile Picture
    9 on at

    Just a thought...

     

    Would it make sense to use scripting instead of trying multiple templates and connectors ?

     

    Don't know how to do this, but I have seen people bringing up the Python scripting..

     

    Looking for options and ways to make this work.

     

    Thanks for your time...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 248 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 207 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 101 Super User 2026 Season 1

Last 30 days Overall leaderboard