cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kjmcintosh
Level: Powered On

Flow work (ish) but taking for ever

I am sure someone will look at this and laugh or mutter something else 🙂

 

I have what I thought to be  a simple flow but it is taking for every to run.

I have a contact list and a copmpany list

Contacts have a field for typing in the copmany name (these contacts come from outlook)

I have added a field to lookup the companyname (companyLU) to my list of companies

the text string is the same for the type company name and the lookup list.

 

My flow is matching but very slow (contact list is around 3000 company list 2500

 

Can anyone point out what I am doing wrong?

 

Many Thanks

Kevin

captueflowCompanyLU.JPG

8 REPLIES 8
Gaznae
Level: Powered On

Re: Flow work (ish) but taking for ever

@kjmcintosh have you tried using Concurrency within the Apply to Each? You edit the Apply to Each section to switch on Concurrency.

Dual Super User
Dual Super User

Re: Flow work (ish) but taking for ever

Hi @kjmcintosh 

 

I can see that the first condition you are using is to look for null values. I would suggest using the filter queries to directly filter the list instead of using the condition (this will only return the filtered values and save pretty much time)

ffeq.PNG

You can try this and then iterate on each value in the returned list. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

kjmcintosh
Level: Powered On

Re: Flow work (ish) but taking for ever

Tried both suggestions but still not working any faster.

Any other thoughts?

Dual Super User
Dual Super User

Re: Flow work (ish) but taking for ever

Hey @kjmcintosh 

 

You mean that it is taking the same amount of time that it was taking earlier? Is it that all the records are beinf retrieved even after filtering the first level? 

 

You should get only records matching the filtering criteria and then based on that when you use concurrency it should make the flow a bit faster. Can you check these items?

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

kjmcintosh
Level: Powered On

Re: Flow work (ish) but taking for ever

It still taking an age to run. So far been running for 20 hours and has matched 800 of the 3000 records

I must be doing somthing wrong as I think I could edit the records myself faster !!!

Dual Super User
Dual Super User

Re: Flow work (ish) but taking for ever

Hey @kjmcintosh 

 

Shouldn't take that long but as there is a nested a apply to each it is taking so much time. Can you share some details on the scenario you are trying to build and we can better address the issue?

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Gaznae
Level: Powered On

Re: Flow work (ish) but taking for ever

Hi, @kjmcintosh 

 

Can you send an updated screenshot for the design of your Flow?

kjmcintosh
Level: Powered On

Re: Flow work (ish) but taking for ever

Ok so I ran it with only 1 contact needing the copmany looked up (it took 28mins to match)

flowAccountsLookup.PNG

 

 

step1.PNGstep2.PNG

 

Capture3.PNGCapture4.PNGCapture5.PNGCapture6.PNG

 

Should it really take 28 min to match when there are 3000 comapnies ?

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,409)