cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cjewell
New Member

Check queue items, remove or add if required

Hello, 

 

I have built a reoccurring flow to look at a custom entity records 'Review Due' date which are upcoming within 28 days or overdue, filter on a status reason, then add those which are identified into a specific queue. 

 

As this is a reoccurrence on a nightly basis (as we are using this to review all records based on file retention periods), the flow will show as failed for the records which are already in the queue. So, I have two scenarios I would like to solve through the flow: 

 

1. How to build into the flow to check if the item is already in the queue and not add it.  

2. How to build into the flow to check those which are in the queue, to make sure the original date conditions are still met (as these dates can change if a user enters them incorrectly). 

 

The first point is more important, the second I can advise users accordingly. 

 

Here's a snip of my flow so far: 

 

Capture 1.PNG

 

Capture 2.PNG

 

Capture 3.PNG

 

 Any help is much appreciated. 

 

 

 

2 REPLIES 2
abm
Super User
Super User

Hi @Cjewell 

 

You can query the Queue Items using the filter query with queue id and record id. Please see below:

 

image.png

 

Above I have hardcoded the queue id and the record id which is in the queue. Replace those Guid's accordingly.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi abm, 

 

Thank you for that. The list of queue items does work; however, I can't quite figure out how to then only add the items to the queue if they are not there. 

 

I have tried multiple ways, including having conditions and filters within those conditions/swapping the queue items and apply to each with the file retention apply to each; but, am not getting the results I need. 

 

Any suggestions on how to filter both with the Queue Items and the File Retention Review conditions at the same time, using an 'Apply to each' for the File Retention Review items?

 

Much appreciated

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,784)