
Announcements
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.
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 ?
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.
Should I have 30 conditions? or Apply to each, but with the 30 variables in it ?
Any suggestions?
Thanks!
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...