Access Sharepoint list view in Powerapps

[sbgoh]

Hi 

I encountered some delegation warning when I used "Filter" on Sharepoint List. So I created a Sharepoint view on the list. May I know is there a way to access the Sharepoint view from PowerApps?

[eka24]

Please can you give the formula you used that gave the delegation warning. This will help if there is a workaround for it. Also how many rows are in the list.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[sbgoh]

The number of rows will keep increasing and it will be more than 2000. I think the problem is with the Search part.

My combobox items = ListName. There is no formula. I even tried to add my data into collection but it is not working too.

Any advise?

[eka24]

Edited

Follow this Post to create a collection.

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-can-i-manage-to-filter-more-than-2000-re...

Then use the Collection on the Combobox

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[sbgoh]

Hi, I did not use filter. Once I set IsSearchable = true, this warning appears and I can't find all my records.

[eka24]

I edited my earlier post

First increase the delegation limit to 2000. At File.. Advance Setting.

Then create a collection using my earlier reference post. Note the list should have an ID number field with increment numbers like 1,2,3,4

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[sbgoh]

Hi, what happen if my number of records is 3000? Will it still works?

[eka24]

Onvisible of the screen;

Concurrent(

ClearCollect(CollectionA,Filter(NameofTable,ID<2000)),
ClearCollect(CollectionB,Filter(NameofTable,ID >=2000 And ID<3000)));

ClearCollect (CombinedTable,CollectionA,

CollectionB)

Then use CombinedTable on the Combobox

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[sbgoh]

This solution will be difficult for me as I don't know how big will my list grow and I need to keep creating new collection.

[eka24]

The first was over 12000, you said you want only 3000. Why don't you Use the first solution I gave, as your data grows it will still work whether 3000 or 5000.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.