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?
Solved! Go to Solution.
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:
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"):
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:
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,
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,
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?
Edited
Follow this Post to create a collection.
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.
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?
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.
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.
User | Count |
---|---|
255 | |
110 | |
90 | |
51 | |
44 |