Announcements
My flows are based on web extraction where I have around 4 loops.
Is there anyway to speed up the process? Is there any tweak or something I am missing that I can incorporate for better speed?
I have used next loop and exit loops wherever necessary.
Hi @luckyra
Can you share how flow looks like ?
by understanding the flow, we can suggest how flow can be made efficient
Nived N 🚀
LinkedIn: Nived N's LinkedInYouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!Your appreciation keeps me motivated. Thank you! 🙌
Please find Attached doc
Hi luckyra,
I haven’t fully analyses your flow, but the loops often writes to excel. Do you think you can use data tables in the loops and write them to excel once after the loops?
Hi since I am kind of new to the tool, I might need help with that. I see there is a datatable option under variables. I tried to use it but the create datatable only lets you add static number of columns and rows.
looking at your flow, i am agreeing with what @Gidi said. Using excel actions would take time. So using datatable as variable and add rows to the datatable and then finally adding that datatable to excel file would make it faster.
Take this below example on how to create a datatable and add rows to it and finally added the datatable to excel.
I have created an excel file like below which has headers A, B
Now using this flow, i will create a datatable variable after which i will append a row and then save it to excel file.
Which will add the data in excel like below
Hope it helps !
I am using single value instead of list because I want to have a serial no for each item in the list. Could that be another reason? I tried using for each but rather it runs the numbers 1-24 in the same cell instead of one below another
Use a count variable and increase it by 1 after each iteration.
May be i am quite confused , could you explain it properly ?
Initialize a variable called count before the foreach loop. Set its value to 1. Inside the foreach loop use increment variable action and increase count by 1 and use write to excel action or add to data table action with a row value as count.
Change it according to your usecase.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 262 Super User 2026 Season 1
11manish 167
Haque 154
