Split row with multiple method

(0) Share

Report

Posted on by Flashback

145

Hello,

i have this collection

And i need split row with multiple methods in column Method delimeter ":" to separate rows.

Row must be same only with different method value.

Could anybody help me please?

Thank you very much

Jakub

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Flashback

I recreated your case:
ClearCollect( colJakub, {Title: "Row1", Method: "Method1:Method2:Method3"}, {Title: "Row2", Method: "Method4:Method5:Method6"} );

Then I used a ForAll() to loopthrough colJakub and Split the Method column.
Clear(colJakub2); ForAll( colJakub, With( {methods: Split(Method, ":")}, ForAll( methods, Collect( colJakub2, {Title: Title, Method: Result} ) ) ) );
From this:

The result is as follow:
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Flashback ,

For a declarative approach, please try:

ForAll( colSampleForFiltration As Samples, ForAll( Split( Samples.Method, ":" ) As Methods, { CupNumber: Samples.CupNumber, Method: Methods.Value, QCLink: Samples.QCLink, ResultsDone: Samples.ResultsDone, Run: Samples.Run, SampleLabel: Samples.SampleLabel, WorkOrder: Samples.WorkOrder } ) )

Basically this loops trough all items in your collection and then for each item trough all methods as separated with the Split function. For each iteration a record is returned where all columns have the value of the Samples, except for the Method column, which has the value of the Method item.
Flashback 145 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer
Hello,
i tried your code to new collection but i received "table in table"

My code

ClearCollect(colSampleForFiltration2,
ForAll(
colSampleForFiltration As Samples,
ForAll(
Split(
Samples.Method,
":"
) As Methods,
{
CupNumber: Samples.CupNumber,
Method: Methods.Value,
QCLink: Samples.QCLink,
ResultsDone: Samples.ResultsDone,
Run: Samples.Run,
SampleLabel: Samples.SampleLabel,
WorkOrder: Samples.WorkOrder
}
)
))

What i do wrong?

Thank you very much
BR
Jakub
Verified answer

BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Flashback ,

If you wish to store the result in a collection, it's easier to use the method @SpongYe posted just before me:

Clear(colSampleForFiltration2); ForAll( colSampleForFiltration, With( {methods: Split(Method, ":")}, ForAll( methods, Collect( colSampleForFiltration2, { CupNumber: CupNumber, Method: Result, QCLink: QCLink, ResultsDone: ResultsDone, Run: Run, SampleLabel: SampleLabel, WorkOrder: WorkOrder } ) ) ) );

To make the declarative approach work, you'll need to ungroup by the Value column.