Hi friends
i created the flow that create item in sp list with excel online but it take so long to finish (about 2800 records with 24 columns) so tried to analyze bottle neck in process mining and found that its has parallel flow that take so long, could anyone describe me about this what the problems about this flow and how could i speed up?
thanks in advance for any suggestion
I bet your flow has a "Create item" action nested in the loop. Such a 'Create item' operation would be happening through a connector to the target data source like Sharepoint, Approval, SQL( on-prem) or SQL online, etc.
If you want to improve the performance, I think it is worth checking the data source side first. if a single transaction at the data source is completed quickly, then the next suspicious look will go to a connector as the connector needs to communicate with the data source like a middle man. If even the connector performed quickly, then, a suspicious look can come to flow itself. If you provide a bit more context, am happy to help.
Hi Supasith,
Your screenshot is not readable. Can you repost a sharper image? For the same activities, can you also share a screenshot of your Power Automate flow?