Hi all,
I am trying to do a simple filter on a excel sheet that has ~3000 records of data and is being accessed from a OneDrive Connection. Each record has a name, date, and value. What I have been trying to do is display to the user all items with their name which is always less than 250 results. I am trying to do things the correct powerapps way and to use the filter() to only return those 250 results.
For example: ClearCollect(UserData,Filter(DataSource, Name="CurrentUserName"))
*UserData is empty for any user that has records past the 500 mark in DataSource
The problem is that the filter doesn't look through any rows after 500, so the filter only works for the first 2 users. To my understanding, Powerapps has a 500 record limit on returns. I have seen plenty of post about people trying to Display more than 500 results, but that is not what I am doing.
Ideally, I want to filter even more by date and name, but even a simple filter is not working since I know some functions can't be used in filtering.
Additional test:
| Name | Value |
| a | 2 |
| b | 3 |
| a | 4 |
| b | 5 |
| a | 6 |
| b | 7 |
| a | 8 |
| b | 9 |
| a | 10 |
Here is a sample of a test table, the table repeats all the way up to 700.
For example, with this test data source, how would I create a collection that only holds records where value>400?
Currently, if I use:
Filter(DataSource, value>400)
I only get 100 results, when I should be getting 300 results. This is not breaching the 500 record retrieval rule correct?
Thanks
