cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
glometeeb
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
ScottShearer
Super User III
Super User III

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

Could you show a screenshot of Flow steps?

Could you show the flow via screenshots?

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,668)