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.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!