Best approach to follow to build dashboards inside power app canvas app that can summarize data from SharePoint lists

john john Pter 445 Reputation points
2024-01-14T20:16:08.22+00:00

This is a question about SharePoint and not power apps, so please if anyone can help me. I want to build some dashboards inside our canvas app which summarize data from SharePoint lists. now i know that we can not directly query all the data from SharePoint inside our power apps, where we can only get up to 2,000 items. now in our case we have some SharePoint lists that get around 100-150 items per day for storing work orders, so around 37,000 items per year.    For example inside our work orders list, we have those main fields:-  

  • Work Order Status
  • Work Order Technician
  • Create date
  • Closed Date

Now we want to build a dashboard to show the number of work orders for each technician, by selecting the month (or all months) and the year and the status. For example, we can know how many work orders were closed by a technician named Tech-A in May 2022. or how many Canceled work orders in all months in 2023 for Tech-B, as so on.. so i am planning to approach this in this way:-  

  1. Create an azure function which run daily at 1 am .
  2. The function will use PnP core SDK which can get all data in patches.
  3. then create a SharePoint list named WorkOrderSummary which stores the following info:- 
Technician Name, Month, Year , Number Of Work Orders, Work Order Status.

  4) then build some charts inside power app which will query and filter the data from the WorkOrderSummary list.

Now on paper this approach should work, but not sure if it is valid when some to live? or i can have a better approach to follow?   Thanks 

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,417 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,225 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,301 questions
0 comments No comments
{count} votes

Accepted answer
  1. Azar 26,185 Reputation points MVP
    2024-01-14T20:50:59.8466667+00:00

    Hey john john Pter
    I thinks your dashboard plan for summarizing SharePoint work orders in Power Apps sounds pretty solid to me! Using an Azure function with PnP core SDK for daily data fetches is a smart move, and creating a dedicated summary list for Power Apps queries makes a lot of sense. Just keep an eye on error handling in the Azure function and make sure it runs smoothly. Also, as the data grows, check in on performance and optimize as needed. Your charts in Power Apps should be awesome, just remember to keep them snappy, especially with a growing dataset. You've got this, and it's going to be an epic all the best
    If this helps kindly accept the answer thanks much.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.