cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

Create Repport from Powerapps

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.

3 REPLIES 3
Skilled Sharer
Skilled Sharer

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.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (82,374)