Forum Discussion
How to create a column in SharePoint list that reflects a previous value?
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
- Thanks ganeshsanap , I think I am going on the right track. However, now the issue is if I follow all the above steps the new column I have created in the list copies the current value of the field for which I only want the very first original value.
Basically, for the new column I specified value in Update Item step as equal to the column from which I am trying to get the original value maybe that’s why it is copying the exact same value as that column, but I don’t know if there is a way to copy the only original version value.