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)

Sort by

Suggested answer

SwatiSTW 809 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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 809 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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