cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Complex Reporting within PowerApps Canvas App

Hello experts,

 

Good day all, I have a request to which I would appreciate your wealth of experience, thoughts and advise on proffering insight and possibly suggest the right approach to achieve the  below.

 

Background :

My firm has a legacy app, with the process modelled and end result report developed within excel. 

The end user reports are a combination of conditional formula, complex business rules and utilizes summary/aggregate data from the underlaying excel data.

 

We intend to automate the process using Power Apps (maybe Canvas apps). And to this end , we thought it might be best to create a POC app to determine if Power Apps might  the right technology to automate the process and simulate the app.

 

My Question here is:

1)  Can an exportable report (to  Xlxs  or pdf) be created from underlying data in Power app Canvas?

2) But most importantly,  can the below sample report be created in PowerApps. I have attached the sample report for viewing.

 

Your insights are well appreciated

 

2 REPLIES 2
Highlighted
Resolver III
Resolver III

hi there

 

power apps as you know by now have a rich set of functions which can be used to translate business rules to workable outcomes.  from your image it seems most likely that all of those can be done in power apps. the amount of work will also be as a result of your datasets, how many lists are being used etc for example target vs actual. - that said it looks doable.

Secondly you report is not the same as excel and you will have to collect and group the data to get to get to that kind of a report but it is also doable. the export of the report to excel or pdf is another story. this can be done too and depends on your licensing just how much work that will be as the pdf (when not using onedrive) is a premium feature.

 

All and all when you start the poc with specific questions im sure we will gladly assist, your app can definitely be done.

Highlighted

Hi Rubin,

 

Thanks for painstakingly going through and providing answers to the questions. I wanted to ensure , that am not on a circus journey before embarking on the task.

Was such a great help knowing, the task can be achieved. i guess it would all be down to my knowledge and effort. 

 

I had let you know should I have any specific question whenever I start the App dev.

 

Thanks

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,009)