Hi. I have created a simple Powerapp to query a Sharepoint List. The Sharepoint List contains our business spending. I have created a gallery of the Sharepoint List. Which I can filter using to 2 date pickers (from and to) and a combobox (contains categories of expenditure).
I am trying to calculate the total number of transactions for the period - CountRows(Gallery1.AllItems) and total expenditure - Sum(Gallery1.AllItems, cost).
The results only show the first 100 rows. You then have to scroll the gallery to the end to get the total results.
I have also tried to create a collection - ClearCollect(ListResults, Gallery1.AllItems) of the filtered gallery and use this in the calculations - CountRows(ListResults). Again this only returns the first 100 rows.
The Sharpoint List contains more than 2000 rows ( and growing) and there will always be more than 100 rows in the filtered gallery.
Any suggestions please or do I stick with exporting the Sharepoint List to Excel.
Thanks
