You’re offline. This is a read only version of the page.
Announcements
I am creating my first Power App.
Just want to display and search an excel sheet stored on my Business OneDrive.
The table only has 16,521 rows, two columns - "UserID" and "FullName".
Goal is to search UserID and see the associated FullName.
I can make the connection, and the functionality seems to work, but not all of the table entries are present.
I can perform a search and no results are found in the PowerApp, but the same search in the Excel spreadsheet finds the entry.
In the images, I have sorted the table in similar fashion but you can see there is a different result set.
Where am I going amiss?
Thanks
@Anonymous ,
Change your data source to SharePoint - you will not be able to query 16k rows in Excel
You might also have a look at the video below from Shane Young.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Share
Report
All responses (
Answers (
153,026
