Updating list item based on Status column and group by field

[Rishabh126]

I have task status column with backup value, using it to copy list item from this list to archive list.

Adobe Reader DC is one of the value for Main Task column, I wanted to know, is there any way if I change the value of Adobe Reader DC task name ( Main Task) to backup, Power Automate can change the task status for all items (Sub Task) to backup those are tagged to Adobe Reader DC (Main task).  So that I can use this condition to copy to archive list and reset to initial values for reuse.

[v-bacao-msft]

Hi @Rishabh126 ,

Could you provide more details about Sub Task?

What does it have to do with the Main task? The list shown in the screenshot does not seem to be an ordinary list.

Best Regards,

[Rishabh126]

Hi @v-bacao-msft 

Thank you for helping in this.

I have Main Task as one of the column in SharePoint list which has drop down with task name like Adobe Reader DC and Screensaver etc. Also, there is one list item exactly same as drop down category. We are trying to use group by to display task and sub task.

My team is using this list to keep track of the tasks, which occurs every month. I have been asked to create a process where once they complete the sub task, it should get copied to archive list (taken care of this in another flow). Now there are multiple users working on it, usually one person takes a main task. If someone decides to reset the task status by setting the status equal to backup then all the tasks should be set to Not started which are set to that category. Now using filter array I was able to filter out for Adobe Acrobat DC, but I am not able think of a way where when a person who is working on screensaver click on the flow button beside screensaver, it should reset only task for screensaver. Also I am using update list at the end to keep the main task status to backup always by using ID. I hope you are not confused. Please let me know and I will try to explain again.

Screenshots attached.

Thanks,

Rishabh

[Rishabh126]

Hi @v-bacao-msft 

I was able to do it, but thanks for the help 🙂

[v-bacao-msft]

Hi @Rishabh126 ,

Great, if your problem has been solved, you can consider sharing your solution, and click "Accept as Solution" on the reply that describes how you were able to solve your issue!

This makes your post much easier for other members of the community to see and find when looking for a solution!

Best Regards,

[Rishabh126 · Accepted solution]

Hi @v-bacao-msft ,

Sure. So I was trying to achieve the feature of the task list in modern site. As modern site still does not have a task list. I added the content type in the list and got all the column. But my team was looking for task and sub task feature. I group all the task based on the category and then set a reset task button using column formatting.

Once the user click the button and runs the flow, it only reset the sub task of the main category, in this case just ROP related sub task.

Reset the task button run the following flow which trigger based on the selected item. I am getting all the column value of the that single item and also for all the items using get items.  

Here I am using condition to compare main task of the single to main task value of the title, also another condition only when the task is completed or deferred. In this condition, it only match with RoP customization category. Using create and update operation, I am archiving the completed item to another list and reset the value to null. This way team does not need to right all the monthly task again and again.

final output:

All two task are copied to another list and field all set to initial value ( null) in the current task list

I hope this solution will help users who still wants to work in modern task list.