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:

General Questions

Connecting to Data

All responses (5)

Answers (0)

WarrenBelz 147,870 Most Valuable Professional on at

Like (1)

Report
Temporary collection table limit

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}
mthiru_0023 212 on at

Like (1)

Report

Temporary collection table limit

@Warren, how do you handle defaultselecteditems on a combo box. On Edit, I want the default value on the saved record.
WarrenBelz 147,870 Most Valuable Professional on at

Like (1)

Report

Temporary collection table limit

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
mthiru_0023 212 on at

Like (1)

Report

Temporary collection table limit

@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?
WarrenBelz 147,870 Most Valuable Professional on at

Like (2)

Report

Temporary collection table limit

This blog of mine may be of assistance