Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

All items are not displayed



I am a newbee on PowerApps, created an App using Sharepoint List.

All worked well, but for some reason it doesn't display all items. Most items are missing from the list.


Creating an App and connecting to SharePoint List was seamless.


Am I doing something wrong?


Appreciate any help!






Level 10

Re: All items are not displayed

Hi @shaimerc

Difficult question to a newbee, but:

1) Are you displaying the data in a gallery?

2) If so, what is the Items property of that gallery?

Not applicable

Re: All items are not displayed

I have the same problem. The items are present, but not visible. 


Here's the Items Property: 

Sort(If(IsBlank(TextSearchBox1.Text), '[dbo].[KLANT]', Search('[dbo].[KLANT]', TextSearchBox1.Text, "Klantnaam", "AccountManager","AlgFaxNr","AlgTelNr","AlgemeneEmail")), If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))


And for some reason, the sort button does not work.


Community Support Team
Community Support Team

Re: All items are not displayed

Hi @shaimerc,


Could you please share about how many columns that you have in your SharePoint list?

If you are using the auto-generated screen, the items displayed are auto-generated, we could choose to hide or show the items with the way mentioned in the article below:

Show, edit, or add a record from a table in PowerApps


In addition, please follow the guide below:

Generate an app (SharePoint list)

You should be able to find the corrseponding article with the third part:

Customize the app (SharePoint list)




If there is no data displayed, please take a try to switch the first screen layout, see if that would help.



Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

Re: All items are not displayed



Actually, the app can query data. I can see the arrows at the right side, which indicates there are items. But the data within the items are not visible. It only happens when I have made changes to the Items property. Anyhow, I'll try your suggestion. But what about the sort button on top of the screen? When I click on it, nothing happens.


Here is the OnSelect action (default):


UpdateContext({SortDescending1: !SortDescending1})



Helpful resources

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.


Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,754)