Not able to fetch all items from Sharepoint online List

(0) Share

Report

Posted on by vish_p

287

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

SkiDK 1,016 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
vish_p 287 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

vish_p 287 on at

Like (0)

Report
Copy link

Link copied!

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

1 people found this reply helpful.

Was this reply helpful? Yes No