Forum Discussion
copy list itmes column value to another column sharepoint online
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
Rob_Ayala You need to enter that code in the popup to the right for the Since field, where it says "Expression":
When complete it will look like this:
