Unanswered

Check queue items, remove or add if required

(1) Share

Report

Posted on by cjewell

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.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Cjewell

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

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

Thanks

Was this reply helpful? Yes No
cjewell 21 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
cjewell 21 on at

Like (0)

Report
Copy link

Link copied!

I haven't been able to work this out with other priorities; therefore, I did a work around.

I ended up updating the File Retention Review record after adding it to the queue, with a marker in a field which is not on the form. This then allowed me to filter on this condition, and point one of this query is now solved in this way.

May be a round about way of doing it but it works.

Was this reply helpful? Yes No