Forum Discussion
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?
BWats have you tried playing around with “append changes to existing text”? It’s a setting on a multi line text field, that changes the field from an editable text to a kind of comment field with time stamp and user info for each comment made. Perhaps that’s what you’re looking for?
BWats Hanne_Lauritzen I would do this with an approval flow in Power Automate. In the approval email the approver can select approve or reject and add comments. The flow would then update columns in the list with the approval details.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)Rob_Elliott This is the way! Definitely the preferred approach. The Multi-line text field with appending changes is the "quick and dirty", between the two options
