Hi,
I have SharePoint list and customizing with PowerApss Forms, In that I have Author comments, Reviewer Comments multiline text columns.
If user provided data in Author comments and Reviewer Comments, Data will be stored along with time stamp and also if user re-added new data to these columns again that should be stored as well with Time stamp along with Old provided data time stamp.
Author Comments | Reviewer Comments |
Provided data 22/05/23 7:40 AM Provided data2 23/05/23/8:40 AM | Provided data 22/05/23 7:40 AM Provided data2 23/05/23/8:40 AM |
Please let me know how to achieve this,
Now I am Trying to store Author Comments and Reviewer Comments Time stamp in below respective columns
"On Select" of Author Comments DataCardValue I have put UpdateContext({Timestamp: Text(Now())})
And in "Default" of Date and time of Review comments and Date and time of Author comments columns I am keeping If(!IsBlank(DataCardValue7.Text),Timestamp). It is giving correct data only.
But when I am editing already existing items in list this field still showing current data only, I need old data only for already submitted items when I put/modify comments only that particular date needs to be captured.
Hi @MSD52 ,
Feels like your firewall is blocking it.
Title of YouTube link is: "Run Power Apps from SharePoint List as Custom Cards using JSON Formatting" by Reza Dorrani
When I am accessing this video is unavailable showing
Hi @MSD52 ,
You can create a small Canvas PowerApps on column level to show a text box for entering Author comments and when saved, PowerApps should append the text in specfic format with time-stamp
Same with Approver comments if Approver comes to SP
or if you are using Approvals using Power Automate then you can store the 'Approver Comments' in the column with its format including time-stamp.
Hope this helps