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

How to copy a sharepoint list item from one list to other

As the Subject says i would like to copy an item from one sharepoint lis to another through flow ,but the problem i am facing is that when i am giving a create item action in flow i am not having any option to copy all the modification logs that happened to this particular list item when in was in first list

Is there anyway i can acheive this ? Can i copy the modification logs associated with the list items in the first list to the second list when i am copying ?

PS : Actually there are multiple people who are going to edit the item when it was in list 1 ,so if i copy Modified by field ,i am going to get last modified person details only not all the trail of modified details..any way to get all the data ?

8 REPLIES 8
Highlighted
Super User
Super User

Re: How to copy a sharepoint list item from one list to other

@vish_p :

System columns such as modified and modified by cannot be set using any "out of the box" Flow action. 

Likewise, you cannot set the version history.  You may/may not be able to do some of this by calling the SharePoint API by using the Send an HTTP request to SharePoint action.

 

As an alternative, I suggest leaving the items in one list and using views to show items with different statuses.  If you want to prevent additional edits, you can consider declaring items that should not be edited as a record or changing their permissions.  Changing permissions will require a third party tool or an API call.  Setting an item, as a record will require a Designer workflow or an API call as well as changes to the list configuration.

 

 

 

 

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 V
Helper V

Re: How to copy a sharepoint list item from one list to other

Hey @ScottShearer  Thanks for the Reply!

 

Actually i am using List 1 as the primary list where users will apply/modify data ,so i usually keep it as minimum as possible for faster indexing/processing and once all the modfcations are done ,i am moving it to another list i.e. List 2,so cannot restrict to only one list

Highlighted
Community Support
Community Support

Re: How to copy a sharepoint list item from one list to other

Hi @vish_p ,

 

Do you want to get all the metadata including the version histories when copy an item from List1 to List2?

 

If so, I am afraid that it might be not possible to achieve it currently.

 

Please feel free submit your request on Flow Ideas Forum about this issue:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Power Participant
Power Participant

Re: How to copy a sharepoint list item from one list to other

Hey all

 

I guess it is possible to "copy" the modified and modified by from List1 into custom created columns in List2?

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Highlighted
Helper V
Helper V

Re: How to copy a sharepoint list item from one list to other

Hey @Tom_Slosse  It is possbile to copy modified by and modified column ,but it will take only the last modified data,i need all the version modified details

Helper V
Helper V

Re: How to copy a sharepoint list item from one list to other

@v-yamao-msft  Okay Thnaks for the reply, will do that

Highlighted
Power Participant
Power Participant

Re: How to copy a sharepoint list item from one list to other

Hey @vish_p 

 

 

Aah yeah then this won't work.

 

Kind regards

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Highlighted
Community Support
Community Support

Re: How to copy a sharepoint list item from one list to other

Hi @vish_p ,

 

Thanks for your understanding.

 

I will suggest other customers who have the same request vote your idea as well. PGs will take hot ideas into consideration first in the future releases.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,624)