copy list itmes column value to another column sharepoint online

%3CLINGO-SUB%20id%3D%22lingo-sub-1463511%22%20slang%3D%22en-US%22%3Ecopy%20list%20itmes%20column%20value%20to%20another%20column%20sharepoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1463511%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20one%20list%20library%20where%20i%20have%20one%20column%20Called%20Status%20and%20another%20Status_archive%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20to%20copy%20value%20of%20status%20column%20to%20status_archive%20column%20whenever%20new%20item%20get%20added%20to%20list%20or%20any%20modification%20in%20status%20column%20value.%3C%2FP%3E%3CP%3Ehow%20i%20can%20do%20this%3Fusing%20MS%20flow%3F%3C%2FP%3E%3CP%3Eand%20how%20i%20can%20update%20old%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1463511%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1463684%22%20slang%3D%22en-US%22%3ERe%3A%20copy%20list%20itmes%20column%20value%20to%20another%20column%20sharepoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1463684%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F670519%22%20target%3D%22_blank%22%3E%40rautchetan27%3C%2FA%3E%26nbsp%3Bthese%202%20requests%20can%20be%20done%20with%20a%20couple%20of%20very%20simple%20flows%20in%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20When%20an%20item%20is%20created%20or%20modified.%20That%20will%20be%20your%20trigger%20and%20then%20you%20just%20update%20the%20item%20that%20was%20created%20or%20modified%20and%20into%20the%20StatusArchive%20field%20you%20select%20Status%20from%20the%20dynamic%20content%20box%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-itemCreatedModified.png%22%20style%3D%22width%3A%20923px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198866iB30AE3D71A80E8D8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%221-itemCreatedModified.png%22%20alt%3D%221-itemCreatedModified.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E2)%20To%20do%20this%20for%20all%20existing%20items%20in%20your%20list%2C%20use%20a%20trigger%20of%20Manually%20trigger%20a%20flow.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222a-triggerGet.png%22%20style%3D%22width%3A%20575px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198855i483FE858D06F9B0D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222a-triggerGet.png%22%20alt%3D%222a-triggerGet.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20default%20Get%20items%20only%20returns%20100%20items%2C%20so%20if%20your%20list%20has%20more%20than%20this%20go%20to%20the%20settings%20for%20the%20Get%20items%2C%20switch%20on%20Pagination%20and%20set%20the%20threshold%20to%202000.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222a-paginationThreshold.png%22%20style%3D%22width%3A%20621px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198852iEF23A1F48870E744%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222a-paginationThreshold.png%22%20alt%3D%222a-paginationThreshold.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20add%20a%20SharePoint%20Update%20item%20action%20and%20select%20the%20ID%20and%20Title%20from%20the%20dynamic%20content%20box%20and%20then%20for%20the%20Status%20Archive%20field%20select%20Status%20as%20you%20did%20at%201)%20above.%20As%20you%20are%20entering%20the%20fields%20the%20action%20will%20wrap%20itself%20in%20an%20apply%20to%20each%20control%20which%20is%20what%20we%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222b-ApplyUpdate.png%22%20style%3D%22width%3A%20648px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198854i94C73FA4F4313309%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222b-ApplyUpdate.png%22%20alt%3D%222b-ApplyUpdate.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20flow%20will%20loop%20through%20each%20item%20in%20the%20list%20and%20copy%20the%20value%20in%20each%20Status%20column%20to%20the%20StatusArchive%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467505%22%20slang%3D%22en-US%22%3ERe%3A%20copy%20list%20itmes%20column%20value%20to%20another%20column%20sharepoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467505%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%20will%20it%20work%20if%20both%20Column%20type%20is%20Choice%3F%20will%20it%20able%20to%20copy%20choice%20from%20one%20column%20to%20another%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi,

 

I have one list library where i have one column Called Status and another Status_archive

 

i want to copy value of status column to status_archive column whenever new item get added to list or any modification in status column value.

how i can do this?using MS flow?

and how i can update old data?

2 Replies
Highlighted

@rautchetan27 these 2 requests can be done with a couple of very simple flows in Power Automate.

 

1) When an item is created or modified. That will be your trigger and then you just update the item that was created or modified and into the StatusArchive field you select Status from the dynamic content box:

 

1-itemCreatedModified.png

  

2) To do this for all existing items in your list, use a trigger of Manually trigger a flow. 

 

2a-triggerGet.png

 

By default Get items only returns 100 items, so if your list has more than this go to the settings for the Get items, switch on Pagination and set the threshold to 2000.

 

2a-paginationThreshold.png

 

Then add a SharePoint Update item action and select the ID and Title from the dynamic content box and then for the Status Archive field select Status as you did at 1) above. As you are entering the fields the action will wrap itself in an apply to each control which is what we want.

 

2b-ApplyUpdate.png

 

The flow will loop through each item in the list and copy the value in each Status column to the StatusArchive column.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott 

 

Thanks! will it work if both Column type is Choice? will it able to copy choice from one column to another?