cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ks4050kt
Helper II
Helper II

Delegation with Share Point List for more than 5,000 records

I'm developing App in basis way, which can be generated from Share Point List semi-automatically.

My Share point list has more than 5,000 records, and it could not be imported to Apps due to restriction of data numbers.

So I set filter to eliminate unnecessary items;

 

Filter([@MT_PATENT_MASTERDATA_3], TextInput1.Text in 'Title of invention')

 

The filter looks like to work, but filtered items are less than existing in Share point list, and PowerApps warns Delegation matter for this formula. What is the cause of this?? can you please advise it.

 

On the other hand,  if the column title is in Japanese and record also input in Japanese, nothing appear in gallery, and also warning of Delegation.

Japanese language is not recommended to use in Share Point List??

 

Finally I intend to set filter "the column includes word", I may need to adopt  !IsBlank  formula, (but currently this formula also got Delegation warning), is this proper way to screen the items to import into Apps??

 

Thank you for your advice.

2 ACCEPTED SOLUTIONS

Accepted Solutions

@ks4050kt 

The NOT operator cannot be delegated in SharePoint, not can IsBlank.

 

27B8F558-D0E9-4B12-BDA3-F19C7D945D9E.jpeg

 

Instead, you must use this comparison:

StartsWith(ColumnName1, “”)=Blank()

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

@Drrickryp @troytec @mdevaney 

So I assume it is better to make one(1) column for filtering e.g. SHOW : Yes / No in English, then have filter of gallery e.g. Filter(Source, StartsWith(ColumnName, "Yes"))

 

If it shows all records more than 100 or only 100 records but it can be filtered in further column elements, I can achieve to what I need to do (All useful record filtering initially (to eliminate useless records), then further filtering with specific words). 

 

😅 Gave up to try to use NOT in delegation of PowerApps.

View solution in original post

12 REPLIES 12
mdevaney
Super User
Super User

@ks4050kt 

The “in” operator cannot be delegated in SharePoint.  Use “=“ instead of “in” to make your comparison.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

@mdevaney ,

 

Thanks your advice. Once change from "in" to "=", it is working. But still the records imported is 100 numbers limitation.

Do I need to set anything in Share Point List?? or in PowerApps?? (Delegation limit was already changed upto 2,000)

 

In addition, I tried to use "!IsBlank", but " ! " is not supported in delegation, so how can I define "NOT" for IsBlank formula??

 

If you have any idea, would be appreciated.

Delegation is a funny one.

 

If you are using a sharepoint list, trying creating a collection on AppStart:

ClearCollect("CollectionName",SharePointList").

 

That will save the data into powerapps temporarily. 

@troytec 

 

I tried to add ClearCollet in Apps > OnStart, the result is as below attached capture;

ks4050kt_0-1593614434913.png

So my share point list is using Japanese Language in Column Name and record itself, I guess this caused a matter of incorrect action in Apps.

 

In case set Filter in Gallery Items, delegation warning appeared for the simple syntax

表示非表示 = TextInput1.Text
(Column Name) = (Input Text in Japanes)

 

ks4050kt_1-1593614581540.png

If anyone has knowledge about Japanese usage, it is helpful for me, thx.

 

You need to run the on start function : https://gyazo.com/ca6a576ad91876b4dc3e97e0f3e416f3 

 

Your filter should be the collection name not the SP List.

 

I have no idea with Japanese sorry 😞 

@troytec 

 

Thank you so much for your advice. My Apps improved with my knowledge.

One more thing about formula, if you know;

 

IsBlank() and !IsBlank can be used in filter for delegation?? or any alternative way to extract only blank field items / non-blank field items?? 😃

@ks4050kt 

The NOT operator cannot be delegated in SharePoint, not can IsBlank.

 

27B8F558-D0E9-4B12-BDA3-F19C7D945D9E.jpeg

 

Instead, you must use this comparison:

StartsWith(ColumnName1, “”)=Blank()

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

I would use a dropdown or something with a blank value and filter a gallery against that.

 

The IsBlank only returns a boolean type so difficult to filter with it.

Drrickryp
Super User
Super User

@ks4050kt 

Other than @mdevaney 's suggestion regarding =, the other way to filter is using the StartsWith() function. 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,527)