In SPO: I'm looking to get the following achieved with two columns, "Current Date" and "Original Date". The original date is my calculated column.

I want Original Date to be populated with the Current date's first value (other than blank) but not change afterwards.

Is Power Automate my only solution? I don't seem to find a solution to this otherwise.

  • I think something is missing from your question. If you want to store the "current date" then your need is covered with the "created" field, no?
    – dinos.kon
    Apr 4, 2023 at 12:37
  • Sorry didn't realise there could be a confusion with my item names. "Current Date" is the current date for the project's estimated end. Not today's date.
    – Droppisalt
    Apr 4, 2023 at 14:31

1 Answer 1


Yes definitely.

For Power Automate,

  1. Create an Automated cloud flow
  2. Use When an item is created as the trigger
  3. Add an Update item operation where Original Date will be set with Current Date value

Sample screenshot below:

enter image description here

  • I agree with thebernardlim.Per my knowedge,there is no other way to achieve the value will not change.
    – Xyza_MSFT
    Apr 6, 2023 at 2:42
  • Sorry, my question might've a bit unclear. The 'Current Date' and 'Original Date' are the project's estimated end date. Not the actual current date. I'm using "When an item is created or modified" since this date often isn't determined when the item is created but this will take whatever date is in 'Current Date' anytime an item changes in that row. Basically, 'Original Date' has to have the 1st date ever entered in 'Current Date'.
    – Droppisalt
    Apr 12, 2023 at 14:56
  • Basically, I want to do this: ibb.co/Y8530kn @thebernardlim
    – Droppisalt
    Apr 12, 2023 at 18:59
  • hey @Droppisalt, I wrote an article on how to retrieve previous values of a SharePoint item which is what you might need. For your case, you will need to modify the flow slightly, where instead of retrieving the previous version, you will retrieve version 1. dev.to/thebernardlim/… Apr 13, 2023 at 9:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.