I created a form and used branching to have certain questions/sections come up based on the answered questions. I created a flow to have the form turn to a word doc, to then a PDF, and save in SharePoint. Everything works great except that when I look at the PDF, I saw that the questioned that weren't answered are still on the PDF. How can I remove those questions that weren't answered so only the questions that are answered are visible on the PDF?
@SudeepGhatakNZ Hey i didnt mean to accept the solution. thats not what i'm looking for. I'm not trying to delete files, i'm trying to delete questions in the form that were not answered. I dont see how that automate will do that. Its exactly what i have now just more complicated. Do you have any other ideas?
This is what I am referring to
@SudeepGhatakNZ I can't go through a third party, what is the combination of create file and convert file? Any way you can show me through screenshots on how to do that?
@Lulu96 ,
I see you are using Populate a Word Template action.
I wouldn't expect you can do this as it would require conditional control of the content of the template which is not what the action does... the action is adding data to predefined areas of the document.
What I was suggesting was to build the document in HTML which allows you to add any data and apply any conditional logic you need. Then convert the HTML to a Word document: https://support.encodian.com/hc/en-gb/articles/360011823213-Convert-HTML-to-Word
You could also use a combination of Create File and Convert File if your organization doesn't allow third party connectors.
@SudeepGhatakNZ Yeah I'm doing something like that. My form has a lot of questions and not all are yes and no. But the yes and no's are the ones that branch out to the open ended question. In a section there could be 4-5 branching. So it's gonna get complicated, i can already tell. But is there a way to get it so those answers dont come up in the pdf.
here are the screenshots of my flow. the order is screenshot 34, 37, 36
@Lulu96 ,
I guess you are creating an HTML file -> Word File -> PDF File in that sequence?
I would use an expression @empty('YourFormInput") = false before adding the response into the document.
A screenshot of your existing flow might help
WarrenBelz
146,653
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional