web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Splitting just one col...

Power Apps

Answered

Splitting just one column into multiple rows

(0) Share

Report

Report

Posted on by Piyushjha1

Hi,

I have a collection of text having values as

I want to split this into separate rows like counting total digits and splitting it into same number

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Piyushjha1

Lets say you have 123456 saved in your text label.

Then create an empty collection like:

ClearCollect(SplitCollection,{})

After this you can add the following to a button:

ForAll(
Split(Label1, ""),
Collect(SplitCollection, {Digit: Result})
)

Replace Label1 with respective text label name.

The For All function will split the value into multiple rows.

I hope this helps 🙂
Verified answer

VDI 337 on at

Like
a
(0)

Report
Copy link

Link copied!
try below code
//use spilt to split the numbers in seprate rows Split( First(YourCollectionName).ColumnName, " " //if numbers not seprated by space then use "", or add whatever seprator you have ); //use CountRows to count the numbers CountRows( Split( First(YourCollectionName).ColumnName, " " //if numbers not seprated by space then use "", or add whatever seprator you have ) );

Join the conversation