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

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

Best way to generate a PDF from SQL Database

(0) ShareShare
ReportReport
Posted on by 22

I have a Power App that allows users to input text and images for 6 different sections which are then stored in a sql database. Once stored in the database I need to be able to generate either a word document or pdf that contains the relevant fields in the database. My initial thought was to try to fill in the fields from the database via a word template but I am running into an issue with formatting.

The main problem is that all 6 of the sections are optional and each section has room for 3 different images which are also all optional so there are a large number of possible permutations to potentially display. Currently, when a section does not contain data the picture content control place holder images are still visible leaving an ugly mess. Ideally, I would be able to conditionally format the template based on which sections contain data in the database but that has been proving difficult to accomplish.

 

I was wondering if anyone had suggestions for implementing a solution to this problem.

I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 797 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
developerAJ Profile Picture

developerAJ 319

Last 30 days Overall leaderboard