IT'S HERE: Work Queues in Power Automate - Full Tutorial

[@andersjensenorg]

Please give the video a thumbs up, if it helped you - thanks 😍 Watch this video next: kzbin.info/www/bejne/g2qpeJqYe7Z6aKs

[@snehainwonderland]

I believe Microsoft should also provide workqueue action for power automate desktop where we can also create and update queue items status

[@andersjensenorg]

@@snehainwonderland I'm sure, it will come very soon :)

[@hostile_technics]

Once again Anders, just wanted to thank you for the great content here. Your methodology in explaining and slowly evolving the training solution is awesome. Keep on being great

[@andersjensenorg]

Hey Hostile, thank you - much appreciated 😊❤️ Kind regards, Anders

[@bluebirder6817]

another excellent video! I'm a huge fan of your teaching style. I'm further down the road on my citizen developer journey every time I use one of your videos as a reference! Thank you!!!!!

[@andersjensenorg]

Wow, thank you for the more than excellent review, bluebirder! Highly appreciated, kind regards, Anders

[@oscaroneill8222]

Hi Anders, great video! I didn't know about this new development with power automate and work queues. Will have to try it out 😀

[@andersjensenorg]

Hey Oscar, thank you so much 😍 Please let me know, what you think after trying it (I'm sure you will love it). Kind regards, Anders

[@JustynaNowak-t8v]

Hi, in my opinion, in the Performer flow, you should add after your "When a new row is added" trigger a condition where you verify if the newly added row indeed belongs to your queue. This is important because the "Work Queue Items" table contains rows related to all queues, and you need to ensure your flow only processes rows from your specific queue.

[@andersjensenorg]

You're right, check my reply to another comment below 🙂

[@Kaigozen]

Excited to watch and learn this one

[@andersjensenorg]

Nice, please let me know, what you think 😊

[@kamransanaee4196]

Thanks for the video. However, I need help understanding the real-life use case of this new feature! Could you please give some examples?

[@andersjensenorg]

Benefits are many, but mainly load balancing (the tasks can be distributed evenly among bots), prioritization, scale and monitoring. Think processes with many transactions, e.g. supply chain management or financial reconciliation. Kind regards, Anders

[@Vinay-lb9oz]

Hi Anders, video is insightful. Can you please explain how can we run multiple performer bots to work on the queue items?

[@andersjensenorg]

Then you need more licenses (one per performer) 😊 Kind regards, Anders

[@Vinay-lb9oz]

@@andersjensenorg yes I agree. I am just curious to know how does it work? Is it using machine group? If I want to execute simple automation saying display message test, in 5 machines by a single trigger, how to do that. Usually in machine group, each time when I trigger, flow runs on any one random machine.

[@wjameswilliams]

This is really interesting, but what are the benefits of using work queues for this vs a SharePoint list (which would also not use a premium connector) for the queue? My first instinct would be greater throughput, but then the Power Automate service limits could be a bottleneck.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@SrdjanS_Automations]

I know there is a lot of tutorials online, but I would appriciate so much if you create few videos about Excel manipulations and what are the keypoints that we, as RPA developers, have to pay attention to. It would mean a lot

[@andersjensenorg]

Hey Srdjan, thanks a bunch - Have you seen this? kzbin.info/www/bejne/q6OpqndthrSel8U Kind regards, Anders

[@afelipes7]

Thanks for this content Anders, Do you know if there are any concurrency limitations? (I.e write/complete the same work queue item from different user sessions/VMs)

[@andersjensenorg]

Hey Alejandro - Thanks a bunch 🙂😎 You can't dequeue a work queue item twice, so that will not a be a problem (I haven't stress-tested it though). Kind regards, Anders

[@SikhaPradhan-k1e]

Am sending a data table from a desktop flow as output variable which contains 2 columns. 1st column contains some alpha-numeric values and the 2nd column contains json data. I need to create queues in cloud using that "output data table" data. In queue item, the "Name" should be 1st column alpha-num value and the "Value" should be the 2nd column json data. How can i do it ?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@thechristianinitiative1445]

Whats the difference between this and just having a a database (i.e SP or SQL) with an workflow that runs when a new item gets added. Isn't this essentially a queue in itself. I guess I am failing to see the difference. Thanks

[@andersjensenorg]

While you can use e.g. an SQL db, it will be easier to do prioritazion, workload balancing, parallel processing, monitoring, error-handling etc. I'm sure you can create all this with a DB, but it will be an extensive build. Kind regards, Anders

[@jovand179]

Can we process work queue items via power automate desktop?

[@andersjensenorg]

Yes, but only through input variables or custom C# actions, but soon PAD work queue items will be released.

[@jovand179]

Thank you Anders !

[@pandumurali]

It is very important for me While doing SAP AUTOMATION there is one check box if I use click it is working fine but while looping it is doing other way and I am not getting what I need , how to handle this check box in SAP through power automate desktop application

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@schpiele]

Hi Anders. Is it possible to create new work queue item through power automate desktop interface with some action? There is only process and update action available. When I create new WorkQueue through browser interface, I want to be able to create new queue items to that workqueue but through Power Automate Desktop. Is this possible? Kind regards, Krešimir.

[@andersjensenorg]

Hey schpiele, unfortunately not yet, but more PAD actions will be added soon 🙂 Kind regards, Anders

[@schpiele]

@@andersjensenorg Yeah, I'm waiting for them. Thnx for your reply ;-)

[@seemaa2295]

If there are 10 items in queue and due to power issue bot stopped at 7 When the bot is re started 7 items will be in static state. So how will these 7 items be processed? Please clarify

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@andonii46]

Great video! However, as you have coded it, if you have more than one queue and you add items to these queues the performer will be triggered for all of them :S

[@andersjensenorg]

Thank you. Yeah, that's the idea, break it down into transaction cloud flows instead of one big processing of all items. You can change the trigger to, e.g., a scheduled trigger and have them all processed simultaneously.

[@andonii46]

@@andersjensenorg I don't think that is the idea to be honest...idea is to have 1 performer per queue (not 1 performer for all different queues)

[@andersjensenorg]

What to you mean by "the idea"? Usually it's more effecient to break your PA cloud flows down in separate flow runs. Benefits are improved performance, error-handling and logging. Please convince me otherwise 🙂

[@andonii46]

@@andersjensenorg I think we are not understanding each other. All I'm saying is that the performer cloud flow that you have coded in your video is going to be triggered whenever you add 1 or more than one workitem within every Work Queue you might have in PA. If you have 7 different queues in PA and you add workitems to all those 7, your performer is triggered for all the queues (when, in a normal scenario it should be bounded to one queue, not to all of them)

[@andersjensenorg]

Ah, I'm sorry, Andoni - now I get it 😊 We can add a trigger then: @equals(triggerBody()?['_workqueueid_value'], 'YourWorkQueueID') Or add multiple WQIDs Please keep these comments coming and sorry for misunderatanding. Kind regards, Anders

[@fishtankmemoirs]

In which scenarios should work queues be used? What business problem does this solve? Does this require a dataverse license? What is the purpose of work queue - Dispatcher and Performer can be created by master and child workflow which does the same thing.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@Arunkumar-vp8rf]

Dear sir , please upload how to invoke python script I don't have any idea .i know python and Power automate but how to use python script activity😭 please try to upload that and give some example python programme on power automate desktop

[@andersjensenorg]

Hey Arun. I haven't done a PAD/Python video yet, but in the last part of this video I show how to invoke VBSCript. The Python approach is exactly the same. Kind regards, Anders

[@hellosubhahere]

Audio is so poor Jensen, so is the video quality on full screen it looks so blurred and font is so small...

[@andersjensenorg]

Hey AbstractThought. I've just re-watched/listened the video on two other devices (Win11 desktop and Android mobile). The sound is great. Regarding the video quality: Please click on the little cogwheel - here you can change the resolution (I recommend 1080p) 🙂 The video is best viewed on a 1920x1080+ screen. Kind regards, Anders

[@jmack1717]

The sound and video is superb

[@andersjensenorg]

@@jmack1717 Thank you 🙂😎

[@mrZerg00s]

Both the sound and video are crisp-clear.

[@andersjensenorg]

@@mrZerg00s Thanks a lot, Denis 😎

[@DanishAli-el2fe]

@andersjensenorg how to avoid duplication in work queue item

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders