Collection- shows no data

[kky1]

Hello - I'm attempting to create a collection and for the life of me cannot figure out what could be wrong with my code that there is no data in the collection. 

The collection is colAllWaitlists, created in the OnVisible property of the screen. It is a copy of my data source EPPICRegistrations. From this, I want to pull a 2nd collection, colMySchedule which filters the first collection on the user's email and a registration status of not cancelled.

I've read a slew of posts on this topic but cannot seem to figure out what I'm doing wrong.

Thank you in advance for any insights!

K

***

Code to create the collection. 

Collection colAllWaitlists, which is a copy of the datasource (SharePoint list):

field_3 is email address

2nd Collection filtered from colAllWaitlists (above) returns no data:

Actual data of the orig sp list - the 2nd collection coMySchedule should contain 4 items:

[cmyoung07]

Can you try putting your code on a button versus on the OnVisible property of the screen? See if that filters your collection correctly, I've seen weird issues with running some things on visible. Lets see if we can at least rule that out or not first.

Also, put a label to show the value of your variable varPSUemail to make sure that is showing an email that is in the first collection. 

[kky1]

Thanks so much @cmyoung07 for your quick reply! 

I put the code in the OnSelect property of a button, but still no data. The varPSUEmail is correct (it's a variable of the user's email set when the app starts so it is my email). 

Here's a snippet of the screen after testing the button:

Code pasted into the OnSelect property of the button:

[cmyoung07]

Cool, the next thing I would check is for leading and trailing spaces and more importantly the case spelling of your text. I have gotten burned by the case of the current user not matching the case of the email I pulled from a list or sql table or wherever it is coming from, that I always wrap my comparisons using the Lower function (Upper is fine too, just recommend you pick one and stick with it something like below.

Lower(Trim(field_3)) = Lower(varPSUEmail)&& Lower(Trim(UserStatusText)) <> "cancelled"

See if that helps. If not, try removing one of the filters and just check email and then just check status, see if you can narrow the issue down to 1 field.

[kky1]

Thank you for these suggestions @cmyoung07 ! The Lower didn't change anything, but I am definitely going to adopt that idea moving forward so thank you!!! 

Your next suggestions was the ticket because I checked for only my email and still nothing so that got me wondering if this was a different issue regarding delegation. So, I did a CountRows on the label to see if that could be the reason and it populated 2000. When I looked at the Sharepoint list size, it has 2329 records so I realized this is most likely a delegation issue! 

CountRows from 1st collection: colAllWaitlists

Sharepoint list rows above 2,000:

Is there a way to create a collection that is more than 2000 records? I tried increasing this limit in my settings, but 2,000 was the highest number. 

Settings - 2000 is the limit:

[cmyoung07 · Accepted solution]

2000 is the max size, you will need to rewrite your filter so its delegable. How many types of statuses do you have?

You can change to something like below if not too many 

Lower(Trim(field_3)) = Lower(varPSUEmail)&& (Lower(Trim(UserStatusText)) = "status1" Or Lower(Trim(UserStatusText)) = "status2" Or Lower(Trim(UserStatusText)) = "status3")

Or you could collect to a temp collection just using email if that will always be less than 2k records and then filter from that collection using the not equals syntax. If it could potentially hit 2k records I would not use this method and go the one above.

[kky1]

Thank you so much for your guidance @cmyoung07 ! I only have three statuses (registered, waitlisted, cancelled) so I changed the query, but for whatever reason it still wasn't pulling in my records.

So, I decided to attempt creating a larger collection following last method using a With statement at: How To Overcome PowerApps Delegation Limit? | Power Apps (devoworx.net)

That appears to have done the trick so it's all good now! Thank you again!