Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Form to pdf: removing unanswered questions

(0) ShareShare
ReportReport
Posted on by 6

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?

  • Lulu96 Profile Picture
    6 on at
    Re: Form to pdf: removing unanswered questions

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

  • SudeepGhatakNZ Profile Picture
    14,297 Most Valuable Professional on at
    Re: Form to pdf: removing unanswered questions

    This is what I am referring to

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

     

  • Lulu96 Profile Picture
    6 on at
    Re: Form to pdf: removing unanswered questions

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

  • SudeepGhatakNZ Profile Picture
    14,297 Most Valuable Professional on at
    Re: Form to pdf: removing unanswered questions

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

     

  • Lulu96 Profile Picture
    6 on at
    Re: Form to pdf: removing unanswered questions

    @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

  • SudeepGhatakNZ Profile Picture
    14,297 Most Valuable Professional on at
    Re: Form to pdf: removing unanswered questions

    @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

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,653 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow