
Announcements
Hello,
I currently have a flow that I have been using for around 4 weeks which will create a Task in Planner whenever an email in flagged. I also have some data operations set up so that it will count all tasks in the Planner to make sure there are no Tasks already in there with the same subject, if there is then it will not create a duplicate task.
The flow has been working perfectly, however I have just realised that when the flow is counting all the tasks it is also counting tasks which have been marked as completed. Unfortunately for us the chances of us having the same email subject reoccurring in the future is highly likely.
Is there a way I can add a variable in my flow to be able to have the flow still count all tasks to make sure there are no duplicates however have it only search incomplete tasks?
Current flow attached.
Count all Tasks: length(body('List_tasks')?['value'])
Count Filtered Tasks: length(body('Filter_array'))
Condition: Outputs('Count_Filtered_Tasks') is equal to Outputs('Count_All_Tasks')
Any help or suggestions are much appreciated.