web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Split Collection Colum...

Power Apps

Answered

Split Collection Column into 2 columns taking bottom half of values to new column

(0) Share

Report

Report

Posted on by DizzyAy

41

Hi,

I have a collection with one column consisting of 84 values. The values represent a question and answer extracted from a string, the first half of values are the question and the second half are the answers. I therefore want to add a new column to my collection which takes the second half of my first column, resulting in two columns of 42 rows. Is this possible?

I have tried the AddColumns function to no avail

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @DizzyAy ,

I made a sample for you.

Clear(Col2);ForAll( Sequence( CountRows(Col)/2),Collect(Col2,{Q:Index(Col,Value).Q,A:Index(Col,CountRows(Col)/2+Value).Q}))

Best Regards,

Wearsky

Was this reply helpful? Yes No
DizzyAy 41 on at

Like (0)

Report
Copy link

Link copied!

Works perfectly, thanks @v-xiaochen-msft

Was this reply helpful? Yes No

Join the conversation