Combine 3 Columns into one Collection

Like (0) Share

Report

Posted on 24 Feb 2022 06:29:18 by Community Power Pla...

Say I have a Sharepoint List with 3 Columns.
Each column is just a simple multiline textbox that has each value split using a new line. (assuming that all columns will always have the same amount of rows)

Column1:
Apple

Banana

Carrot

Column2:
Fruit

Fruit

Vegetable

Column3:
Green

Yellow

Orange

DesiredOutputCollection:
Apple;Fruit;Green
Banana;Fruit;Yellow
Carrot;Vegetable;Orange

I'm thinking something like this but can't think of the proper method:

ClearCollect(
 DesiredOutputCollection,
 DropColumns(
 AddColumns(
 'My Sharepoint List',
 "3ColumnsCombined",
 Column1&", "&Column2&", "&Column3
 ),
 "Column1";"Column2";"Column3"
 )
);

Categories:

General Questions

I have the same question (0)