You’re offline. This is a read only version of the page.
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}));;
yes, thank u a lot, for me works this code:
ForAll(MainData; Collect(CounterPartiesTab; Split(ThisRecord.CounterParties; ";")))
It works as seen below,
Try this sample first and then adapt it to your needs,
Share
Report
All responses (
Answers (
ClearCollect(MainData, {Number:1,Counterparties:"CP1; CP2"}, {Number:1,Counterparties:"CP3; CP4"});
Clear(CounterParties);
ForAll(MainData.Counterparties, Collect(CounterParties, Split(ThisRecord.Counterparties, ";")))
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
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
