Forum Discussion
How can I copy Lookup column as Plain text column
I have one SharePoint list named: Customer-Project-List
with lookup column named CustomerName from another SharePoint list named Customer-List .
I want to copy this CustomerName column as text column in Customer-Project-List to use this newly created column in third list Named : Employee-Workload-List
How can I achieve this?
Please guide me.
Thanks in advance!
New_learner Follow below steps:
- Create a power automate flow which will run on item creation & update in list Customer-Project-List
- Use "Update item" action to add CustomerName lookup column value to another text column
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
New_learner Follow below steps:
- Create a power automate flow which will run on item creation & update in list Customer-Project-List
- Use "Update item" action to add CustomerName lookup column value to another text column
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Thank you ganeshsanap. It worked as expected.
Helloganeshsanap ,
The flow is working as expected, but the flow is running continuously and this warning appears on the screen
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.New_learner You can check if your lookup column is changed since last version, add condition based on "Has Changed: LookupColumn" and write "Update item" action inside "If yes" block of condition.
Check this blog & video by aprildunnamMS for more information: Power Automate SharePoint Get Column Changes
Please consider giving a Like if my post helped you in any way.
