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:
Any help is much appreciated.
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.
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?