cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nikr
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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (57,376)