web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Avoiding Nested Collec...

Power Apps

Answered

Avoiding Nested Collections

(0) Share

Report

Report

Posted on by Pegger

84

I am creating a simple collection, but it is nesting one of the fields into another table. I need to just pull in the text value into that field.

CollResponses

Q1 Q2

Agree Disagree

ClearCollect(CollResponsesTransposed,
{Q_Num: "Q1", Response:CollResponses.Q1},

{Q_Num: "Q2", Response:CollResponses.Q2} );

The Response column is showing the values as in a nested table when I just want it to show either "Agree" or "Disagree" as text.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Pegger,

Have you solved your problem?

Do you want to display a text string using the CollResponses.Q1 in the CollResponsesTransposed?

Actually, if you refer to the Qi or Q2 using the "CollResponses.", it does create nested collection and an empty useless Q1 or Q2 column.

Add a new button and set the OnSelect property as below:

ClearCollect( NewCol, ShowColumns( AddColumns( CollResponsesTransposed, "ResponseNew", If( Q_Num = "Q1", First( Split( Concatenate( First(CollResponses).Q1, ",", First(CollResponses).Q2 ), "," ) ).Result, Last( Split( Concatenate( First(CollResponses).Q1, ",", First(CollResponses).Q2 ), "," ) ).Result ) ), "Q_Num", "ResponseNew" ) )
Verified answer

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Pegger ,

I have created similar condition and this works,
For colResponse,
ClearCollect(colResponse, { Q1: "Agree", Q2: "Disagree" } );

For colResponseTranpose,
ClearCollect(colResponseTranspose, { Q_Num: "Q1", Response: First(colResponse).Q1 }, { Q_Num: "Q2", Response: First(colResponse).Q2 } );

Output

Hope this helps.

Join the conversation