Unanswered

Form to pdf: removing unanswered questions

(0) Share

Report

Posted on by Lulu96

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?

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Lulu96 6 on at

Like (0)

Report

@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

Screenshot (34).jpg

Screenshot (36).jpg

Screenshot (37).jpg

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Lulu96 6 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

This is what I am referring to

Power Automate Convert office files to PDF without a premium subscription or third-party connector - YouTube

Was this reply helpful? Yes No
Lulu96 6 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No