cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.
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
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,169)