Combine two dataverse tables

(1) Share

Report

Posted on by PPDEV

142

Hi Experts,

I would like to create a flow that would combine some of the columns from two different dataverse tables. My identifier for both is the Case Number (generated from the app). Here's my current flow but not seems to be working. And the loading are super slow and I only have less than a thousand of data.

May I request for your advice, on how can I improve the flow?

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,974 Moderator on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PPDEV 142 on at

Like (0)

Report
Copy link

Link copied!

Thanks @FLMike - This works! Have a good day.

Was this reply helpful? Yes No