Power Automate

Add Work Queue Item action is Very Slow

(0) Share

Report

Posted on by arun_kj

Hi Experts,

I recently started working with Work Queues and I noticed that adding items to queue is terribly slow.

The SQL part was completed in 5 secs and the queue loading took 4 minutes to complete.

That speed is ridiculous to deal with. Any idea what could be the reason? Or is it a limitation of queue as of now? If so, how can we deal with 10k or 1 Lakh transactions?

BR,

Arun K J

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report

You have to optimize your logic,

Below are some points you should do

a. Add items to the queue in batches (e.g., 100-1,000 at a time) instead of one-by-one.

b. Use the “Run Parallel” action to process queue additions concurrently.

c. Adjust the queue's batch size setting for fewer roundtrips and faster processing.

d. Insert data into a SQL staging table first, then bulk add items to the queue.

e. Optimize SQL and Connections, Enable SQL connection pooling and use stored procedures for faster operations.

Please mark it answered if works for you.

Was this reply helpful? Yes No
arun_kj 99 on at

Like (0)

Report

Hi @SwatiSTW, I couldn't find the batch loading action for Work Queues. Could you please provide more details?

Also, kindly guide me on adding items to queue in a bulk.

Was this reply helpful? Yes No
Suggested answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report

Power Automate for Desktop does not have a direct "batch loading" action for Work Queues.

You can do it by couple of ways.

1. Go with Batch Processing using Loop, Add items to a temporary list in batches, then add them to the Work Queue when batch size is reached.
2. Use Staging Table, Insert data into a SQL staging table first, then read and add to the Work Queue.
3. Try Cloud Flows with API, Use Power Automate Cloud Flows and Work Queue APIs for faster, bulk item addition.
4. Try CSV/Excel Upload, Read data from a CSV/Excel file in chunks and add to the Work Queue sequentially.

Was this reply helpful? Yes No