Forum Discussion
copy list itmes column value to another column sharepoint online
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...
Hey Rob,
I saw this post here with your suggestions and this is something similar to what I am working on . Unfortunately, it's not working out very well for me. This is the fist time I am using Power Automate. I am in the process of recreating my SharePoint Workflows from SharePoint 2010/2013 . With that being said I could use your assistance.
I am following your 1st suggestion here . I have a Project Notes Field that has versioning turned on. I am trying to copy the most recent Project Note to another field called Current Status. Purpose of the Current Status field is so that it will only show the Most Recent version on Notes from the Project Notes field.
Here's what I am doing.
Step 1. When and Item is created or modified
Step 2. Update Item
- ID: ID
- Title: Tile
- Current Status Field: Project Notes
This is what is happening:
When in the Sharepoint list - I am no longer able to save cause it is locked to a user. So it's not closing out.
In Power Automate I get this warning:
Actions in this flow may result in an infinite trigger loop. Please ensure you add appropriate conditional checks to prevent this flow from triggering itself.
Thanks in advance for your assistance:
Rob Ayala
Rob_Ayala you will always end up with an infinite loop with your steps 1 and 2. If you are looking at whether 1 or more specific columns have been changed then your trigger should be "When an item or a file is modified". You then need a "Get changes for an item or a property (properties only)" action and in the Since field add the following expression:
sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
Next add a condition and in the left box select Has Column Changed: Department is equal to true. (you'll select your own column).
Leave the red If no channel empty and in the green if yes channel and an update item and up the other columns that you want updated, i.e not Department in my case.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Rob,
Thank you for your quick response. I really appreciate it.
So I did exactly what you said. Unfortunately, it did not accept the expression. This is what I got.
This is the whole flow....
Thanks,
Rob
- Your condition is incorrect: you have used an expression for true which is wrong, all you need to do is type true in the box.
Hey Rob,
After changing the condition to just state 'true' as the value, I still got the following
Thanks,
Rob