Power Platform Community Forum Thread Details

removing complete items when all items in that 'category' are complete

Hello,

I have a tracker that tracks all our work each job is related to a group, one column shows the group name another shows the job status. when all jobs/items in a group are complete I would like to 'move' (create a new item and delete the original) to an archive list but I cannot figure it out. any help would be appreciated

I have made an example shown below, 'example 1' and 'example 2' groups are complete as there is no work left to do. I would like to move all items in those groups to an archive list

this flow would work on a scheduled basis. if all items with the same group are complete/have no work then move all those items to another list

I should point out the actual tracker has hundreds of groups that are updated very frequently so listing all groups in a flow or a flow for each group is not practical

Categories:

Business Process Flows

@Jwickes

Hi there. One way to approach this might be to have a recurrence trigger that runs the flow every so often.

Then, you can get the list of items and group by the "Group". Here's an article walking through this (sort of): Group a List for a Summary Using Power Automate

Then you can compare the number of tasks that have "comp" to the number of tasks for each group. If they are equal (there are three tasks, and three "comps" for that group) then you can have a loop that cycles through each of the tasks in that group and copies them over to your archive list before removing them from the active list.

There are probably other ways to solve it, but that's one I came up with. 🙂

Good luck, keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Quick Links

Leaderboard > Power Automate