Create Repport from Powerapps

[Oskarkuus]

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.

[mogulman]

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.

[Oskarkuus]

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.

[mogulman]

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.