Forum Discussion
How to create a column in SharePoint list that reflects a previous value?
Indy011910 Follow this approach:
- Create a new column in list with same data type as your previous field/column.
- Create a simple Power automate flow using "When an item is created" trigger on this list.
- Use "Update item" action in flow to update new column value using previous field/column value.
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
ganeshsanap thanks for the response, can you please provide the sequence of the steps of the flow? I seem to be getting an infinite loop error.
Indy011910 Try using When an item is created trigger so that flow will run only when new item is created.
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
- ganeshsanap So I created the flow like this:
When a new item is created->Update item. Is this right?
Second, when I am on Update item it asks me to populate mandatory fields within the form, what should I put in those fields ?Indy011910 Yes, you are using correct flow actions. For mandatory fields, you can pass the values from trigger outputs.
For example:
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs