how to keep few column only from the record source for display form

(0) Share

Report

Posted on by MIA27

I am working Teams power app.

I made a collection on the screen visible. This collection has more than 50 column

on my screen i have a gallery, which is based on the collection above mention.

To display related data which is selected in the gallery , I inserted a display form and trying to get few required columns only to display, But it is showing error (shown in the image red underline and error description, surprised that it is showing clearcollect formula also wrong

Please check my mistake and advise

On Data source property, I am typing the below code

Clearcollect(CollectForDisplay1,ShowColumns(colAllList,"cr333_recono","cr333_machineid","cr333_model","cr333_serial"))

All responses (3)

Answers (2)

Verified answer

Ami K 15,665 Super User 2024 Season 1 on at

Like (1)

Report
Re: how to keep few column only from the record source for display form

@MIA27 - yes you can chain multiple Collections within the same formula. e.g.:

ClearCollect( MyCollection1, { Column1: "Text 1", Column2: "Sample 1", Column3: "A" }, { Column1: "Text 2", Column2: "Sample 2", Column3: "B" } ); ClearCollect( MyCollection2, { Text1: "Some text", Text2: "Some more text", Text3: "Even more text" }

Note in the above example, MyCollection1 is generated before MyCollection2 is generated. If there is no relationship/dependency between the Collections, it is more optiminal to generate all Collections together using the Concurrent function.

With this function, we do not need to use the semi-colon notation ( ";" ) and instead use the comma notation "," to separate each ClearCollect. (in the English version of Power Apps):

Concurrent( ClearCollect( MyCollection1, { Column1: "Text 1", Column2: "Sample 1", Column3: "A" }, { Column1: "Text 2", Column2: "Sample 2", Column3: "B" } ), ClearCollect( MyCollection2, { Text1: "Some text", Text2: "Some more text", Text3: "Even more text" } ) )

If there is a dependency between Collections - in other words you want to create another Collection which uses data from Collection1, you can use the following pattern:

ClearCollect( MyCollection1, { Column1: "Text 1", Column2: "Sample 1", Column3: "A" }, { Column1: "Text 2", Column2: "Sample 2", Column3: "B" } ); ClearCollect( MyCollection2, Filter( MyCollection1, Column3 = "A" ) )
MIA27 on at

Like (0)

Report

Re: how to keep few column only from the record source for display form

Dear Imran,
Thank you so much for your advise.

Just for my learning purpose and for future use, Can I add another collection underneath the same collection formula screen.

I mean, my main collection "colAllList" is happening on the first screen visible property, as my code is there,
Is it possible that under that formula, after putting ; sign I can add another collection based on the above. So that my both collection will be ready upon load of screen and can be used.

Please advise.
Verified answer

Ami K 15,665 Super User 2024 Season 1 on at

Like (1)

Report

Re: how to keep few column only from the record source for display form

@MIA27 apart from "Clearcollect" being the wrong syntax (the correct formula name is "ClearCollect"), the Data Source property is expecting a Table, it is not to be used to initialise a Collection.

Apply your ClearCollect statement onto the OnSelect property of a Button for example, and then in the Data Source property, only enter: CollectForDisplay1