cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Cut and Paste List Items

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.

3 REPLIES 3
Highlighted
Super User III
Super User III

Re: Cut and Paste List Items

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.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Helper I
Helper I

Re: Cut and Paste List Items

Could you show a screenshot of Flow steps?

Helper I
Helper I

Re: Cut and Paste List Items

Could you show the flow via screenshots?

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (5,759)