web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Collect with Split and...

Power Apps

Answered

Collect with Split and forAll

(0) Share

Report

Report

Posted on by CU09100753-0

170

Hi,

I have collection MainData with 4 fields:

Number - Expences - Sum - Counterparties

"1" - "expence1" - "200" - "Counterparty1; Counterparty2"

"2" - "expence2" - "300" - "Counterparty3"

I would like to create another collection of all counterparties

Counterparties

Counterparty1

Counterparty2

Counterparty3

How to get this collection?
I try something like this but it dont work:)

ForAll(MainData.CounterParties;
ForAll(Split(CounterParties;"; ") As _item;
Collect(CounterParties1;{CounterParty: _item}));;

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@shnurich Try this,
ForAll(MainData.Counterparties, Collect(CounterParties, Split(ThisRecord.Counterparties, ";")))

Was this reply helpful? Yes No
CU09100753-0 170 on at

Like
a
(0)

Report
Copy link

Link copied!

some problem with Split function.
PowerApps cant see anything after ThisRecord.

And How also collect CounterParties Collection with another empty string field:
For example:
CounterParty - Status - ID

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@shnurich
It works as seen below,

Try this sample first and then adapt it to your needs,
ClearCollect(MainData, {Number:1,Counterparties:"CP1; CP2"}, {Number:1,Counterparties:"CP3; CP4"}); Clear(CounterParties); ForAll(MainData.Counterparties, Collect(CounterParties, Split(ThisRecord.Counterparties, ";")))

Was this reply helpful? Yes No
CU09100753-0 170 on at

Like
a
(0)

Report
Copy link

Link copied!

yes, thank u a lot, for me works this code:
ForAll(MainData; Collect(CounterPartiesTab; Split(ThisRecord.CounterParties; ";")))

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@shnurich Glad it works!

Please remember to give a 👍 and accept the solution as it will help others in the future.

Was this reply helpful? Yes No

Join the conversation