Create a collection

[Anonymous]

Hello

I have a collection a below

id           col1           col2

1            A|B             Yes|No

2            A|B              No|No

I want to create a new collection like

id           col1            col2

1             A                Yes

1             B                 No

2             A                 No

2             B                 No

I don't know how to do it.

Thank's for your help

[v-albai-msft]

Hi @Anonymous ,

Is the col1 column and col2 column a Choice column that allows multiple selections? 

How do you populate the col1 and col2 column?

Check if formula mentioned in below thread useful to you:

Solved: Create Multiple Records at one time with 2 or more... - Power Platform Community (microsoft.com)

Best regards,

Allen

[Anonymous]

hello;

Thank's for your answer

At the origin of my problem I want to translate an horizontal table to a vertical table like thie

id     A        B

1      Yes     No

2      No      No

to

Id      Col1     Col2

1        A          Yes

1        B           No

2        A           No

2        B           No

[CNT]

@Anonymous Try this (change names as required),

ForAll(collection1,
	Patch(collection2, Defaults(collection2),
	{Id: ThisRecord.Id, Col1: "A", Col2: ThisRecord.A});
	Patch(collection2, Defaults(collection2),
	{Id: ThisRecord.Id, Col1: "B", Col2: ThisRecord.B})
)

[Anonymous]

Thank's.

I think is a good solution but it's not that simple. I have 11 columns.

In my first message, the first table is create from the horizontal table, I concatenated  in col1 the text of each column and in col 2 the value of each column (the name of each column is very long like 'La formation a-t-elle répondu à vos attentes').

i know how to create table 2 from the contents of col1 but i don't know how create table 2 with col1 and col 2 in the same time 

[CNT]

@Anonymous In PowerApps column names cannot be referenced dynamically. So, if you have 11 columns in your first collection, you'll need 11 Patch statements to convert them to 11 records in the second collection.

[Anonymous]

yes, i know

If we don't take into account wanting to translate a table, how to solve the problem of my first post

[v-albai-msft · Accepted solution]

Hi @Anonymous ,

No matter using the first collection in your first reply or using your original table, you have to specify the column name manually. Currently, PowerApps cannto get the column name.

So if converted based on your first colelction, it is rather difficult than converted based on the original table, since we need additional steps to get value from "A|B" and "Yes|No".

That's why I aksed you how do you populate the col1 and col2 column in my first reply.

So as a result, I would suggest you converted data directly based on your original table, just using the code provided by @CNT .

Best regards,

Allen