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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report
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" ) )

Was this reply helpful? Yes No
Verified answer

Ethan_009 4,838 Moderator on at

Like (0)

Report
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.

Was this reply helpful? Yes No

Join the conversation