Hi @ASDFASF
First, check if the SharePoint list uses char(10) for line feed.
If parsing using char(10) works, parse the whole list.
1)found out that SPO list uses char(10) for line feed.
2) Create ColParsed and fill the collection with parsed data from the columns ID(=columnA), Title(=columnB), and MultiLineColumn(=columnC), instead of using columnA, columnB, and columnC. I hope this won't cause any confusion
/* syntax for working with column columnA, columnB, and columnC is... */
ClearCollect(ColParsed,Blank());
ForAll(
ColSample,
ForAll(
Split(columnC, Char(10)), // Split the multiline text into individual lines using the newline character (Char(10))
Collect(ColParsed, {
columnA:ColSample[@columnA],
columnB: ColSample[@columnB] ,
columnC:Value
}
)
)
);
I hope this helps.
Kirkby
