I have a custom SharePoint online list named ServiceRequest, which contain around 85K++ items, as follow:-


The custom list contain those main custom fields:-

  • Assigned To >> People or Group

  • Start Date & End Date >> DateOnly

  • Year >> Single line of text

  • Status >> Choice contain values such as "Open", "Closed","In Progress"

Here is sample of the data:-


now i want to build a dashboard which should show the following info:-

  1. Total number of items per year

  2. For each year to show a bar charts with the number of items per status.

  3. Have the ability to filter the items per year and per status

now is this possible to do so directly inside a Power Apps canvas application taking into consideration that we have 85K++ items? i am not sure if we need to do it directly inside Power Apps, or use a scheduled Power Automate flow or scheduled azure function which do these calculations (number of items per year and per status) and save these calculation inside a separate list for the Power apps to read them directly?

1 Answer 1


Consider using SharePoint search to surface this information. The data can be queried via the SharePoint search API without running in to list view threshold or performance issues. Once you have the data, you can then display it as required via your dashboard.

SharePoint Search REST API overview

  • ok thanks for the info, but how i will be calling these api? from a power automat flow for example which get called from Power Apps? Jul 7, 2023 at 1:04
  • I think that's the only way at the moment. Jul 7, 2023 at 11:01
  • Croowley ok thanks i have never done this before, so using REST API i can return all the items from a customer list without any limitation? but even though i think i will face some limitation on looping through those items inside power automate, i think it is limited to 100,000 iteration , what do you think ? Jul 7, 2023 at 12:32
  • It would avoid the list view threshold and should be better for performance. This is only theoretical though and would need testing. Jul 7, 2023 at 13:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.