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

@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
efialttes
Super User III
Super User III

@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

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.

@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

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
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,268)