If it is on-premise SQL Server:
1. Have PA set a bit in table to produce PDF.
2. Have on-premise server process read DB table looking for bit at an interval (say 5 min) and trigger a convert process
3. Create process to read DB, get info and format PDF.
4. Email PDF to user.
Now I would do this in C# but Python would also work.
Another option is to use a desktop computer with Excel or Word. Create an addin using VBA and produce a document and save to PDF. I actual do this to create complex reports with graphs/tables/pivottables based on PA data in Azure SQL data but you can easily change connection to local SQL Server. I use Task Scheduler to run at a specified time. The only problem with this it isn't a cloud solution.
I just wanted to clarify my previous statement - using PowerApps Free and Flow Free (the free version that comes with office365 licenses), and then using the OneDrive for business create/convert actions, you should be able to pass HTML from PowerApps into Flow, and then use that user's OneDrive for business to convert the file...
I know you said you were looking for a workaround, but your reason for a workaround was the cost of licensing, and this method should not require anything other than a free license.
Yes, this is the exact way I am doing it now. But my colleague responsible for the licenses told me that we need to pay an extra license for Flow. This info came from some Microsoft Support. We all have 365 licenses and I as a developer have plan 2 for PA.
If this is the only Flow-based request you are doing, then you will definitely not need a Flow (Power Automate) license.
How do I know this? I am both the one in charge of licenses, and I am the only developer here at my company, and I have made Flows like this before. We have one paid Plan 2 license, everyone else in the company uses the Office365-based free licenses for PowerApps and Flow.
We have plans for later use of more advanced features like AI, but at present, we do not need them.
An easy way to test if you need a license - get your IT to create a new account with only a basic office365 license and a Flow free and Powerapps free license.. create and share a simple app with them that only does this one conversion task.
If they need a license, the App will not work for them and will not create that PDF.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.