SharePoint List need multi-line column with timestamp and allow updates
I’m setting up a SharePoint list to support attestation by owners for different business virtual assets. This will support a review to ensure we aren’t retaining stale virtual assets.
When the owners review SharePoint list rows where they are listed as an owner, I’d like them to provide a note detailing their rationale for why the asset should be retained but have that note timestamped so the next time they perform a review they can see the previous rationale and the date they added that note.
What is the best way to do this? Calculated, multi-line column? If so, what formula would work? Or would this need to be run through Power Automate and have a flow that updates any input to that column to concatenate it with a date?
I’m setting up a SharePoint list to support attestation by owners for different business virtual assets. This will support a review to ensure we aren’t retaining stale virtual assets. When the owners review SharePoint list rows where they are listed as an owner, I’d like them to provide a note detailing their rationale for why the asset should be retained but have that note timestamped so the next time they perform a review they can see the previous rationale and the date they added that note. What is the best way to do this? Calculated, multi-line column? If so, what formula would work? Or would this need to be run through Power Automate and have a flow that updates any input to that column to concatenate it with a date? Read More