cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Update records based on another table

Hello,

 

I have made a simple flow that retrieves two tables from SQL, Table1 got approx. 4,000 rows with data and Table2 got approx. 53,000 rows with data.

 

If Table2 got a match in Table1 I want the Table2 to update their e-mails, I started with this simple flow to test it out, but it is taking too long to finish (4+ hours and still counting). Is there any way to make this proces quicker?

 

Please see below screenshot, basically I made a loop on both tables to find a match and then update.

 

I have Flow for Dynamics 365.

 

Udklip.PNG

 

Best regards,

Niklas

0 REPLIES 0

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (2,493)