Showing results for 
Search instead for 
Did you mean: 
New Member

Update records based on another table



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.




Best regards,



Helpful resources

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (69,147)