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.
Best approach to follow to build dashboards inside power app canvas app that can summarize data from SharePoint lists
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:-
- Create an azure function which run daily at 1 am .
- The function will use PnP core SDK which can get all data in patches.
- 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
-
Azar 26,185 Reputation points MVP
2024-01-14T20:50:59.8466667+00:00