March 19, 2024

SamTech 365

PowerPlatform, Power Apps, Power Automate, PVA, SharePoint, C#, .Net, SQL, Azure News, Tips ….etc

Reporting with Power Apps

[vc_row][vc_column][vc_column_text]In this article, I will show you how we can use PowerApps for reporting purposes.

I know, PowerApps is not meant to be used as a reporting platform, but sometimes, you might need to have some analytics and graphical reporting capabilities in your Power Apps Applications.

Also, if using PowerBi is not possible (for licensing or skills limitations), you can just through couple of nice Power Apps.

Context:

This is an example of an app I have built which uses

  • Custom html controls (I can’t thank Kristine enough for her contribution, https://www.kristinekolodziejski.com/)
  • PowerApps Collections and Data grouped by different values using Power Fx Group by functionality.
  • PowerApps Graph Controls (Pie Charts, Bar Charts, and Line Charts).

The App is a reporting App for the CRM Solution I have built for one of the biggest UK Councils, which help tracking the pupils’ transport from/to schools.

With call handling and tracking of issues, and a centralised DB of Pupils, Schools and Transport Providers.

The end result is just stunning !

The touch of gradient background for different widgets, give a nice and professional look to the app.

Here is the final result.

[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_single_image image=”100408″ img_size=”large” alignment=”center” style=”vc_box_rounded” onclick=”custom_link” img_link_target=”_blank” css_animation=”bounceIn” link=”https://i0.wp.com/daoudisamir.com/wp-content/uploads/2023/03/Reporting-2.png”][/vc_column][/vc_row][vc_row][vc_column][vc_single_image image=”100407″ img_size=”large” alignment=”center” style=”vc_box_rounded” onclick=”custom_link” img_link_target=”_blank” css_animation=”bounceIn” link=”https://i0.wp.com/daoudisamir.com/wp-content/uploads/2023/03/Reporting-1.png”][/vc_column][/vc_row][vc_row][vc_column][vc_single_image image=”100418″ img_size=”large” alignment=”center” style=”vc_box_rounded” onclick=”custom_link” img_link_target=”_blank” css_animation=”bounceIn” link=”https://daoudisamir.com/wp-content/uploads/2023/03/Reporting-4-2.png”][/vc_column][/vc_row]

1