Answered

How to create a Collection

(0) Share

Report

Posted on by Lopez_0090

Collection is created with the following formula.
The DataSource uses a SharePoint list.

ClearCollect(
 SampleData,
 {Column1: Sample.Title, Column2: Sample.Column2, Colunn3: Sample.Column3}
);

スクリーンショット 2021-08-06 120257.jpg

However, if you create a Collection with this expression, it will look like a table and you will not be able to display the data.

Is it possible to display the data by making some changes in the formula to create the Collection?

スクリーンショット 2021-08-06 115515.jpg

※What I want to do in the future
Prepare two drop-down lists, one to select the value of Column1 and one to select the value of Column2.

Suppose I select "Sample" in the drop-down list of Column1, I want "AAA" and "BBB" to appear in the drop-down list of Column2.

Is it possible to have the above dropdown with the current collection?
Or do I need to work on the formula to create the collection?

If anyone has any good ideas on how to achieve this, please let me know.

Best regards,

Lopez

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

GarethPrisk 2,828 on at

Like (1)

Report
Copy link

Link copied!
Simply, you should create Collections that match your date source.

ClearCollect( colSharePoint, NameOfSharePointList );

If/when you need to abstract that list, you can use functions like Choice(columnName) to get the values.

Collect works this way, to recreate the table in the app with identical columns. You don't need to define the columns, unless you're trying to transform them or use column shaping functions.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report
Copy link

Link copied!
You've got a few questions there, but I will try to answer a few of them.

First, your current ClearCollect is forcing entire columns into a single record, which doesn't sound like you what you are after.

ClearCollect(SampleData, Sample);
Creates a copy of the Sample SP List as an internal collection. Normally you should not need to do that since you can reference Sample directly as a data source. If you need to do something different with the collection, let us know.

For DropDowns, consider putting an expression of the following type into the Items property:
Sample.Column2
This makes all the fields in column2 available as dropdown choices, assuming they are text, number, string, etc.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Lopez_0090 ,

You can also do this.

Clear(SampleData); ForAll( Sample As aCol, Collect( SampleData, { Column1: aCol.Title, Column2: aCol.Column2, Column3: aCol.Column3 } )

Was this reply helpful? Yes No