I have a Flow that scrapes the IT Task List every 15min to poll for updates.
If it sees updates in the Plan, it will transfer them to an Excel Table.
Flow #2 then grabs that data from Excel and uses it to look up the corresponding Plan ID.
The cards ultimately move from IT to the sub-plan.
Flow #2 will go line by line down my Excel Table. Once we arrive at the sub-plan for any entry, we then look at the bucket it is going into for a card that already exists. If so, do nothing, validate that it has a different due date than the new card. If it DOES, create a new card with the new data. If that card already exists with that date, do nothing.
FINALLY, I need to cross-check the Buckets with the items on the list. This is where I need help.
Here is the logic in question.
After Flow has determined whether or not to create the card, it now needs to reverse check that there aren't items in the Sub-Plan that AREN'T in the Table. If there is a card in the sub-plan and not the table, we need to remove the Card from the sub-plan.
How can I check the tasks from my Bucket against my Excel Table?
Thank you.
User | Count |
---|---|
23 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
45 | |
29 | |
26 | |
25 | |
22 |