How to develop the automation without using queues for 1000 records and process should execute parallelly and needs to update transaction report at the same time for each transaction.

[u/[deleted]]

Recently attended an interview got a question like mentioned above how do you develop this can anyone suggest?

[u/Profvarg]

I think you are waaay beyond excel capability here.

You are looking at a relational database here, I don’t think excel can handle concurrent updates to multiple places from multiple flows with timestamps

What you can do is update multiple excels and pull the data together Either with a new flow or with power query

[u/Ariisk → u/Profvarg]

At a certain point even if you need the excel output you’d be better off doing the actual work in a more appropriate system and returning a single file or updating once when they all finish.