I have an app for an client that want to get a repport from the apps data each month.
I am thinking something in the line of designing a PDF that flow setup each month at a specific date and populate with data. But i cant figure out if this is even possible...
I can just make a powerapps page/screen and design the repport on that one. But then it is not really a repport and not somehting my client can share with ppl not using the app.
I do this weekly for active clients. I looked at numerous approaches. I use Azure SQL DB for data which provides incredible flexibilty. I thought about using Azure Functions and a free tool called EPPLUS and some webservice to convert Excel to PDF. I just couldn't figure out how to get webservice to work. I know Excel and VBA very well. I just created an Excel addin (xlam) which I run on desktop machine. It connects to DB and creates an Excel report that contains Pivottables, tables and charts that I save as PDF. I use an Excel macro to connect to Outlook and email report. I use Task Scheduler to run at 8:30am every Monday morning. It has worked reliably for several years. The only issue is it is not a cloud solution.
Thank you. ill look into that.
But i understand the problem with not being a cloud solution.
I really want it to be a cloud solution.
My idea is to fix this with Flow. But so far the files that flow creates or tries to edit gets broken for some reason. So atm i am at an dead end.
Azure Functions works with Azure SQL DB. If an Excel report will work look at EPPLUS. There are some C# dlls that allow you to create pdf files from C#. They weren't robust enough for me. I briefly looked at GemBox. I want a C# solution that works Azure Functions that can create fairly complex pdf reports that can be sent to clients. So far my current solution works but I would perfer a cloud solution.
User | Count |
---|---|
179 | |
120 | |
87 | |
44 | |
41 |
User | Count |
---|---|
245 | |
156 | |
128 | |
77 | |
73 |