Unanswered

Temporary collection table limit

(1) Share

Report

Posted on by mthiru_0023

212

I have a collection for an integrated SharePoint list app. The collection creates a table of records based on the referenced SharePoint list. My objective is pull distinct value from one column from the SharePoint list in the look up.

On the FormScreen, OnVisible property I have defined a collection as: ClearCollect(firmnameBlank,{Result:""}); Collect(firmnameBlank,'File Summary').

I am doing a lookup to the collections on the Items property for a dropdown control. Items: Distinct(firmnameBlank, FirmName).

I came across a problem where the collections was limited to 500 records. I have updated settings of the Powerapp for the data row limit to 2000 to get around this issue.

When I go to the Collections in the Variable section of powerapp, the table is 509 rows.

Question: Is there better way to grab the one field in the lookup? I just care about distinct firm name from the table.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,049 Most Valuable Professional on at

Like (2)

Report

This blog of mine may be of assistance

Was this reply helpful? Yes No
mthiru_0023 212 on at

Like (1)

Report

@WarrenBelz, Thank you I took a look at your blog post. Would it be applicable to a dropdown control box or it has to be a combo box?

Was this reply helpful? Yes No
WarrenBelz 153,049 Most Valuable Professional on at

Like (1)

Report

No - you need a Combo Box as the search function is required.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
mthiru_0023 212 on at

Like (1)

Report

@Warren, how do you handle defaultselecteditems on a combo box. On Edit, I want the default value on the saved record.

Was this reply helpful? Yes No
WarrenBelz 153,049 Most Valuable Professional on at

Like (1)

Report
It would be the same as normal - the output is Value, so would depend on the column type it is linked to. Choice would be
ThisItem.ChoiceFieldName

Text would be
{Value: ThisItem.TextFieldName}

Was this reply helpful? Yes No