I have 2 lists that will be changing every day.
List A are Sales requests from clients (From Legacy System)
List B is our CRM System Data Dump (excel b.c. cheap)
I am Creating List C, D, E, F, and G. Using the Sales Requests and Legacy system information.
We are using PAD because everything needs to stay on network.
They only key that links both lists is the account # field.
Originally my flow was using PAD if actions as shown below to see if
IF Excel List A Current Item [Account Number] = List B Current Item [Account Number]
Then do X,Y,andZ
This was taking forever to run, so, I after some research I am thinking a about pulling in the big excel table with 33k rows
Via
1.) Open SQL connection to an excel file.
2.) Execute SQL Statement to filter for rows the Account numbers in List A (which is always smaller)?
3. Use for each to loop through each table as I had it before...???
I am racking my brain attempting to create a filter for the account numbers via the SQL statement, it would have to be a variable since its changing. What are your guys thoughts?
Any issues with #3?
excel if flow taking forever
