
I have a flow that I have created for our project team that uses SharePoint lists. When a project in one list is marked as completed, I have it set to delete list item from one list and copy it over to another list if the condition is met. I have noticed that even if we go in and edit the notes on a list item, then that item is getting deleted. We only want the list item to delete if the item is marked as completed. I know it's something simple that I need to add, I just do not know what it is.
I have attached the flow to this post.
HI @Anonymous ,
I couldn't import your flow and look at it because I don't have access to the SharePoint List it is referencing. Can you provide a screenshot of the flow and some expanded action steps please?
On the surface, I think I know what you need and how to make this work by only triggering when the Status column changes, not any modifications on the Item.
Guessing, if your trigger is "When an Item is or file is modified", you want to add a trigger setting for your column to equal "Completed"; this way the flow only runs when it is updated to Completed, not when someone edits other columns.
Modify this as needed, here in this example, the Column is named Status and the completed value is named Completed.
@equals(triggerBody()?['Status'],'Completed')
If this was helpful, please mark as a solution.