Forum Discussion
PowerApps Table Lookup only returning first 20 entries
Hi all, I have successfully created a many-to-one relationship between Dataverse tables, and also included the lookup column in my model driven app - all is working fine..... except!
The data pulling through from the lookup only displays the first 20 rows of data, even going into the Advanced Lookup only displays those 20 rows. The table has 2500 rows of data, which I can view in 'Tables' but just not coming through on the lookup field.
I have searched and searched for about 3 weeks now and cannot see any help online on this specific issue, can anyone please help!!
2 Replies
- Yes, as I said above. I've done some deeper digging and the data wasn't in my table, so after another few unsuccessful attempts at loading it from the Tables main page, I found a suggestion online to try the upload from the edit list page of a model-driven app - and to my surprise, this worked! All 2500 rows are now there, and searchable from my original look-up field in another table. I'm glad I found a solution eventually, but it really shouldn't be this hard...
