web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collect multiple value...

Power Apps

Answered

Collect multiple values of other Collection

(0) Share

Report

Report

Posted on by gabrielv22

33

Hi All!

I need Collect a new colection with all values of other collection.

Colection 1: ColCriteria

ID	DESCRIPTION
1	Descr1
2	Descr2
3	Descr3

Colection 2: ColDetails

I need create a collection to use into a gallery. The user will complete the Comments and Value fields.

CRITERIA	COMMENT	VALUE
Descr1
Descr2
Descr3

I try with this formula, but generate a table into in CRITERIA field.

ClearCollect(ColDetails;
{
CRITERIA: ColCriteria.DESCRIPTION;

COMMENT: "";

VALUE:""

});;

Can you help me?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @gabrielv22 - you currently are trying the below to collect three fields:
colCriteria.DESCRIPTION but renamed to CRITERIA
Two new blank fields, COMMENT and VALUE
ClearCollect( ColDetails; { CRITERIA: ColCriteria.DESCRIPTION; COMMENT: ""; VALUE:"" } );;
Try this using AddColumns, ShowColumns and RenameColumns
ClearCollect( colDetails, AddColumns( RenameColumns( ShowColumns( colCriteria, "DESCRIPTION" ), "DESCRIPTION", "CRITERIA" ), "COMMENT", "", "VALUE", "" ) )

Please click Accept as solution 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 Thumbs Up.

Join the conversation