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

Подписаться 64 тыс.

Просмотров 21 тыс.

50% 1

This full video tutorial shows how to use Work Queues in Microsoft Power Automate. You learn to create work queues, add data to the work queue and process the work queue items. Finally, I'll show you how to create an advanced Dispatcher and Performer workflow.
You'll learn everything about the new and extremely cool Power Automate feature: Work Queues.
👨‍👩‍👧‍👦 Get Power Automate help and network with 7000+ RPA developers in my FREE Discord community: / discord
📚 LINKS FROM THE VIDEO
- Work Queues Microsoft Documentation: learn.microsoft.com/en-us/pow...
📺 VIDEOS FOR YOU
- Error Handling and Creating a Detailed Log in Power Automate: • Error Handling and Cre...
- Power Automate Desktop Beginners Guide (2 hours): • Microsoft Power Automa...
RESOURCES (AFFILIATE LINKS)
👨‍💻 Learn Power Automate Desktop as a Beginner: • Power Automate Desktop...
📖 Best Power Automate Desktop Book: geni.us/FZQlmt
👨‍👩‍👧‍👦 RPA Developer Community: / discord
👨 PAD Facebook Community: / 754059285247921
💼 PAD LinkedIn Group: / 12566435
📜 PL-500 Microsoft RPA Preparation Guide: • PL-500: Microsoft Powe...
► LinkedIn: / andersjensenorg
► Instagram: / andersjensenorg
► Facebook: / andersjensenorg
► Twitter: / andersjensenorg
► Email Newsletter: andersjensen.org/email-newsle...
⌚ TIMESTAMPS
00:00 Introduction
01:17 Work Queues Basics
04:15 Performer
16:17 Dispatcher
25:02 Exception Handling
#powerautomatedesktop #powerautomate #powerplatform

Наука

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 56

@andersjensenorg Год назад

Please give the video a thumbs up, if it helped you - thanks 😍 Watch this video next: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-M9FGgbFQG2I.html

@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 8 месяцев назад

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 8 месяцев назад

Hey Hostile, thank you - much 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

@bluebirder6817 11 месяцев назад

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 11 месяцев назад

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

@Kaigozen Год назад

Excited to watch and learn this one

@andersjensenorg Год назад

Nice, please let me know, what you think 😊

@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? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-urFyD7QOkac.html Kind regards, Anders

@user-mq1pv6oi8m Год назад

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 🙂

@Vinay-lb9oz 12 дней назад

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

@andersjensenorg 12 дней назад

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

@Vinay-lb9oz 12 дней назад

@@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.

@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

@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): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xWFz-S96XGo.html Kind regards, Anders

@user-iw9xx8rq6t Год назад

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): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xWFz-S96XGo.html 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

@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

@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 5 месяцев назад

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 5 месяцев назад

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): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xWFz-S96XGo.html Kind regards, 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 11 месяцев назад

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): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xWFz-S96XGo.html 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 !

@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 5 месяцев назад

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 5 месяцев назад

@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