I have a list of of Estimates that grows very large very fast. I would like to create a flow that once I mark them as coplete with a check box it moves them into a entirely new list. I understand I can just filter them out the problem is that this list is used in multple other places by lookups. So just filtering will not solve the issue.
I have not found a place in sharepoint where I could select multiple rows and just move them to a diffrent list. I still want all of the DATA to be exaclty the same. Basically just a cut and paste.
Here is a way to approach your issue:
1) Use a recurrence trigger that fires periodically (Daily? weekly?)
2) Use a Get Items action with an OData filter that returns only items marked complete. The OData filter would look something like this: Status eq 'Complete'
3) Loop though each item returned and create a new item in the destination list.
4) Delete the original list item
To delete the items in your detail list, go to list settings and click on the lookup column. Check the "enforce relationship behavior" column and also check "cascade delete". Doing so will allow for every item in the detail list to be deleted when the related entry is deleted. Otherwise they will be orphans.