web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Split Cell in Collecti...

Power Apps

Unanswered

Split Cell in Collection into new Column

(0) Share

Report

Report

Posted on by Stuznet2

Hi fam,

I have an urgent request. It took me the whole day trying to figure out how to split concatenated value into another column.

Supposed I have a ColumnA in a collection and the cell contains this value (Dog; cat).

How can I split it?, so Dog will be in Column A and Cat will be in Column B?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Stuznet2

The following formula will provide that result:

ForAll(yourCollection, With({_r: Filter(Split(ColumnA, ";"), !IsBlank(Result))}, {ColumnA: First(_r).Result, ColumnB: Last(_r).Result } ) )

I hope this is helpful for you.

Join the conversation