Not able to fetch all items from Sharepoint online List

[vish_p]

Hey Team,

I have build an app in which i am using data fro a sharepoint list ,in the app i have one combobox whose Items property contains : Distinct(<listname>,<column name>) now when i click on that combobox all i see is data upto some specific date i.e. upto 30/03/2020 (in this case the combobox contains list of dates which are fetched from above mentioned column) even though list contains data more than that i.e. 24/04/2020

Please help me in this

[SkiDK]

Hi @vish_p 

How many items are there in your SP list? If it's above 2000, then there will be a delegation issue meaning not all records (max 2000) will be pulled in, meaning that your distinct will only get all the different date values only from the first 2000 items.

[vish_p]

@SkiDKmy list contains more than 3k items for sure,can i force powerapps to pull data in descending order of created ? Is that possible ? If yes pls let me know how ,so that even if i dont get older items,i am fine with it

[WarrenBelz]

Hi @vish_p ,

Firstly collect the newest 2000 items (I assume you have increased the limit to this in Advanced Settings)

ClearCollect(
   colWhateverName,
   Sort(
      YourListName,
      ID,
      Descending
   )
)

Then the Distinct Function will work fine on your collection.

Distinct(
   ColWhateverName,
   YourColumnName
)

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.

[WarrenBelz]

Hi @vish_p ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

[vish_p · Accepted solution]

Actually i was fetching Created dates from the list ,instead i gave a date picker to user and filtering records based on user selection.