cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sbgoh
Helper V
Helper V

Access Sharepoint list view in Powerapps

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?

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @sbgoh ,

According to the issue that you mentioned, actually, it is an known issue with CombBox. When you bind your ComboBox to a data source directly or a Filter function, and enable the "Allow Searching" option, the Delegation warning issue would show up.

 

I agree with your thought almost. If you have faced a Delegation issue within your ComboBox, you could only retrieve first 2000 records from your SP List, even though, the Filter function is delegable (could only retrieve first 2000 records of the filtered result).

 

As an alternative solution, you could consider disable the "Allow Searching" option for your ComboBox. Then add a Text Input box above the ComboBox to act as Search box. Then you could filter the result in your ComboBox based on the typed search key:

1.JPG

 

Currently, within PowerApps, there is no other control providing the "Search" functionality except the ComboBox. As another solution, you could consider achieve your needs using a Gallery and a Text Input box (acted as "Text Search Box"):
2.JPG

 

If you still want to use ComboBox to achieve your needs, you could consider load your SP List records into a collection in your canvas app, then use the collection as data source in your ComboBox. Please check and see if the following thread solution I provided could help in your scenario:

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-get-combobox-to-show-all-the-results-...

Also please check and see if the following video resource could also help in your scenario:

https://www.youtube.com/watch?v=2M0zCyu__20

Note: Above solution may cause performance issue in your canvas app, because, passing data from Power Automate flow to canvas app would consume a lot of CPU resources, memory, and network bandwidth.

 

Best regards,

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

View solution in original post

v-xida-msft
Community Support
Community Support

Hi @sbgoh ,

I agree with your thought. If I come up with a better solution, I would let you know here. Thanks for your feedback.

 

Regards,

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

View solution in original post

26 REPLIES 26
eka24
Super User III
Super User III

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.

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?

 

sbgoh_0-1594541162151.png

 

eka24
Super User III
Super User III

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.

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

 

sbgoh_1-1594542026264.png

 

 

sbgoh_0-1594541987763.png

 

eka24
Super User III
Super User III

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.

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

eka24
Super User III
Super User III

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.

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
Super User III
Super User III

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.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (85,504)