You’re offline. This is a read only version of the page.
21
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:
Any help is much appreciated.
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.
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
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
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,948
Most Valuable Professional
Share
Report
All responses (
Answers (
