Hi,
So I would not do it like this.
1. Whatever is the Outer Master Table start there, meaning do your List Transactions Rows First
2. Then do the Apply to each for step 1
Inside that Apply to each, do your List Rows on the Cases, but filter it by the Case Number from the item() of the loop you are in, because right now for every single Transaction, you are looping through every single Case each time
then do you append
So if you have a 1000 Transactions
you are looping 1-1000 and if you have 5000 Cases, you are doing this
1
1-5000
1000
So its massively slow
So do that so speed it up exponentially
So your Code per se is correct EXCEPT for your Questions
List Rows Transactions
Apply to each
List Rows Cases (Filtered by item()?['case number'] (or whatever its called that matches
Apply to each
Append to your array
Now do your steps outside the loops
And you remove your condition totally as you do not need it.
52
Share
Report
All responses (
Answers (
