cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Copy Element Sharepoint

Hi,

 

I want to copy an element from one sharepointlist (1) to another (2) -  just the title - when the the value in a field in list 1 changes. Do I need  a flow for this or can I do so with the standard  sharepoint functions? Or does it not work at all??? Smiley Sad

 

thanks,

 

Martin

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Copy Element Sharepoint

@Anonymous

Sorry for the confusion. 

There is a SP trigger in Flow called "When an item is modified" you can select the SP site and SP list as inputs. Once executed you can apply a condition to ensure the value of a specific field has the expected value; and if matches execute the "SP Create item" action block targeting the second SP list mapping whatever fields you need from the modified item in list#1 to the new item in list#2.

 

Please note, as @Mike2500 remarks here: https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-do-you-change-the-initial-trigger-in-a-flow/m-p/59927#M9028 

that "...there is no trigger to start a flow from modifying a particular field of a list. The old way of doing this is to have an extra field to store the older value, and then compare them. For example, if your field is "status", create a new field called "status_old". The flow would fire for every list change, and would compare those values. If the values were different, then it should proceed on, doing whatever it needed to do, and then update status_old with the current value in status."

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

4 REPLIES 4
Dual Super User
Dual Super User

Re: Copy Element Sharepoint

@Anonymous

This topic is being discussed in this thread

https://powerusers.microsoft.com/t5/Building-Flows/Copy-SharePoint-document-from-one-library-to-another/td-p/48890

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Anonymous
Not applicable

Re: Copy Element Sharepoint

Well - thanks, but I do not want to copy a document - but a listelement.

There are two lists. One is filled permanently with new elements, lets call it "ideas". And there is another list - lets call it "implementation" - that is empty. When an idea is evaluated now (the entry of one field for this element in the list "ideas" changes) a new element in the second list should be generated automatically with the title of the element in the "idea"-list.  Any suggestions???

 

Thanks a lot.

Dual Super User
Dual Super User

Re: Copy Element Sharepoint

@Anonymous

Sorry for the confusion. 

There is a SP trigger in Flow called "When an item is modified" you can select the SP site and SP list as inputs. Once executed you can apply a condition to ensure the value of a specific field has the expected value; and if matches execute the "SP Create item" action block targeting the second SP list mapping whatever fields you need from the modified item in list#1 to the new item in list#2.

 

Please note, as @Mike2500 remarks here: https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-do-you-change-the-initial-trigger-in-a-flow/m-p/59927#M9028 

that "...there is no trigger to start a flow from modifying a particular field of a list. The old way of doing this is to have an extra field to store the older value, and then compare them. For example, if your field is "status", create a new field called "status_old". The flow would fire for every list change, and would compare those values. If the values were different, then it should proceed on, doing whatever it needed to do, and then update status_old with the current value in status."

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Anonymous
Not applicable

Re: Copy Element Sharepoint

Thanks - looks good! To prevent Flow from creating duplicates I set the value for the sharepoint-field to "only distinct values". So I get an error but at least it works....

 

Thanks again, Martin

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,169)