web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Splitting collection i...

Power Apps

Unanswered

Splitting collection into sub collections

(0) Share

Report

Report

Posted on by Krishna_R

525

Hi All,

I've collection called fruits

ID	Value
42	A
60	B
2	C

and I want to split the collection fruits into 2 sub collections based on rows as below

subfruits 1

ID	Value
42	A
60	B

subfruits 2

ID	Value
2	C

Is there any possibility to split the collections as above ?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Krishna_R ,
Use Power Automate
1. Get items store from collection
2. Enter ID from power app as your
3. create html table from data operation
4. store output into excel file

Thanks,
Chitrakant27
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
This depends on how you want to split it - are you wanting all Rows with A/B and then all Rows with C or is it that you want to split it every two rows?

If you want all rows with A or B and then all C Rows:

ClearCollect(subfruits1, Filter(fruits, Value = "A" Or Value = "B")); ClearCollect(subfruits2, Filter(fruits, Value = "C"));

Join the conversation