Forum Discussion
How to create a column in SharePoint list that reflects a previous value?
I am using an InfoPath form that has a field which changes value. How do I create a column that only reflects the very first value despite all the changes done. I am on SharePoint Online by the way.
9 Replies
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
