Copy value of workflow status column to another column

%3CLINGO-SUB%20id%3D%22lingo-sub-1548171%22%20slang%3D%22en-US%22%3ECopy%20value%20of%20workflow%20status%20column%20to%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548171%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20library%20which%20is%20migrated%20from%20SharePoint%202010%20to%20sharepoint%20Online.%3C%2FP%3E%3CP%3Ein%20this%20sharepoint%20library%20I%20have%20approval%20workflow%20and%20status%20of%20this%20workflow%20get%20display%20in%20Column%20status.%3C%2FP%3E%3CP%3Ethis%20status%20value%20in%20the%20column%20get%20cleanup%20permanently%20by%20workflow%20autocleanup%20job.%3C%2FP%3E%3CP%3EI%20want%20to%20persist%20this%20status%20in%20another%20column%20%2Chow%20I%20can%20do%20this%3Fthis%20site%20is%20SP%20online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20I%20have%20if%20new%20item%20in%20library%20added%20or%20any%20change%20in%20item%20%2C%20status%20column%20value%20get%20copied%20on%20another%20column%2C%20also%20need%20to%20check%20if%20status%20column%20is%20not%20blank.%3C%2FP%3E%3CP%3Eso%20after%2060%20days%20workflow%20cleanup%20job%20will%20run%20and%20clear%20this%20status%20column%2C%20stil%20I%20can%20have%20this%20values%20in%20another%20column%20which%20on%20type%20text%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1548171%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1549403%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20value%20of%20workflow%20status%20column%20to%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549403%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%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20attached%20pic%2C%20status%20column%20have%20values%20which%20I%20need%20to%20copy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1549907%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20value%20of%20workflow%20status%20column%20to%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549907%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%3Bno%20image%20was%20attached%20to%20your%20post.%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%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User.%3C%2FFONT%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1550560%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20value%20of%20workflow%20status%20column%20to%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550560%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%3Eimage%20attached%2C%20I%20want%20to%20save%20value%20of%20status%20column(marked)%20in%20yellow%20to%20another%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20status%20column%20is%20give%20approval%20status%20of%20workflow%20and%20it%20is%20autogenerated.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have library which is migrated from SharePoint 2010 to sharepoint Online.

in this sharepoint library I have approval workflow and status of this workflow get display in Column status.

this status value in the column get cleanup permanently by workflow autocleanup job.

I want to persist this status in another column ,how I can do this?this site is SP online.

 

what I have if new item in library added or any change in item , status column value get copied on another column, also need to check if status column is not blank.

so after 60 days workflow cleanup job will run and clear this status column, stil I can have this values in another column which on type text

3 Replies

@rautchetan27 

 

Please find attached pic, status column have values which I need to copy

@rautchetan27 no image was attached to your post.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.

 

 

@RobElliott 

 

image attached, I want to save value of status column(marked) in yellow to another column.

 

this status column is give approval status of workflow and it is autogenerated.