cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RocketMan
Level: Powered On

PowerApps and limited customized SharePoint Form

I had problems with the limits of 500 items when using Search () in a column about PowerApps and a Sharepoint list of more than 5,000 items since it cannot be delegated.

 

I could use the custom Sharepoint form as an alternative, but I have the same problem when applying the Search () command in the "Item" section of a presentation form.

 

I found the comment in the following link:

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/500-item-limit-in-CDM-entity-search-...

 

Do you have any idea how to solve it in the middle?

2 REPLIES 2
Community Support Team
Community Support Team

Re: PowerApps and limited customized SharePoint Form

Hi @RocketMan ,

Could you please share a bit more about the Search formula you used in your app?

Could you please share a screenshot about your app?

Where do you put your Search formula?

 

Currently, within PowerApps, if you use Search function to filter your data source records, you could only use Text type column as Search column within this function, you could not add Complex type column (e.g. Choice, LookUp, Person, ... etc) as search column within this function.

 

The supported delegable function or operators in SharePoint connector, please check the following article:

https://docs.microsoft.com/en-us/connectors/sharepointonline/#powerapps-data-type-mappings

 

Asn alternative solution, you could consider bulk-load your SP List records into your app, then merge these records into a single one collection, then use the collection as data source in your app rather than original SP List data source.

On your side, you could consider add a Calculated field in your SP list, then ser Formula box to following:

=[ID]

then within your app, please consider bulk-load all your SP List records into the app based on the following article:

https://powerusers.microsoft.com/t5/General-Discussion/Pulling-in-large-ish-SQL-tables/m-p/243777#M7...

 

Please check and see if the alternative solution I mentioned within the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Sort-gallery-with-multiple-fields/td...

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

http://rezadorrani.com/index.php/2019/09/18/powerapps-delegation-with-sharepoint-as-a-data-source-wi...

 

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.
Highlighted
RocketMan
Level: Powered On

Re: PowerApps and limited customized SharePoint Form

Thanks for the support @v-xida-msft 

 

I will start from the beginning:

Supporting the Service Desk division, the guys generate an Excel document every month in which they register Support Tickets that they have successfully solved. They want to have a live search engine, which looks in the description of the title of those tickets.

 

They update new tickets in the SharePoint list, that's the data source. As we know, Search () is not delegable, so long ago the user @mr-dang @ had proposed an interesting code

 

UpdateContext ({firstrecord: First (datasource)});
UpdateContext ({lastrecord: First (Sort (datasource, RecordId, Descending))});
UpdateContext ({maxiter: RoundUp ((lastrecord.RecordId-firstrecord.RecordId) / 500,0)});

ClearCollect (iter,
	AddColumns (AddColumns (Filter (HundredChart, Number <= maxiter), "min", (Number-1) * 500), "max", Number * 500)
);

Clear (datasource_temp);
ForAll (iter,
	Recopilar (datasource_temp,
		Filtro (fuente de datos, RecordId> = firstrecord.RecordId + min && RecordId <firstrecord.RecordId + max)
	)
)

LINK: https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/500-item-limit-in-CDM-entity-search-...

 

Today, there are several similar proposals like the ones you mentioned in the links, Based on creating several Collection () to collect the data from the list in parts and finally join them:

Concurrent (
ClearCollect (col1, Filter (sharepointList, recordID> = 1 && recordID <= 2000)),
ClearCollect (col2, Filter (sharepointList, recordID> = 2001 && recordID <= 4000)),
ClearCollect (col3, Filter (sharepointList, recordID> = 4001 && recordID <= 6000))
);
ClearCollect (colCombined, col1, col2, col3)

 

I create a button that contains

ClearCollect(Col1;Filter(Lista_Excel_Pfizer;ID>=1995&&ID<=2005))

 

Capture.JPG

 

This button is for simple tests of storing the ID rows (my column) from 1995 to 2005 in a collection called "Col1".

Then in the "DataTable1" table only display this collection.

As we can see, Filter () never allows me to obtain records above ID 2,000, no matter if I only request 10 items.

What I want to do is collect approximately 5,000 records from the SharePoint List (which grows 500 items every month). And then apply a Search () in a column of text. It is important to mention that StarsWith () does allow me to delegate without problems, but the objective is to collect the items that are labeled "TextSearchBox" and that look anywhere in the text.

 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,748)