How to capture timestamp along the user comment data in Power Apps

Like (0) Share

Report

Posted on 22 May 2023 04:34:02 by MSD52

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,

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (4)

Answers (0)

Ethan_009 4,838 Moderator on 22 May 2023 at 04:45:39

Like (0)

Report

Re: How to capture timestamp along the user comment data in Power Apps

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.

Reference YouTube Link

Hope this helps

Was this reply helpful? Yes No
MSD52 71 on 22 May 2023 at 05:49:03

Like (0)

Report

Re: How to capture timestamp along the user comment data in Power Apps

When I am accessing this video is unavailable showing

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on 22 May 2023 at 06:05:20

Like (0)

Report

Re: How to capture timestamp along the user comment data in Power Apps

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

Was this reply helpful? Yes No
MSD52 71 on 22 May 2023 at 07:28:36

Like (0)

Report
Re: How to capture timestamp along the user comment data in Power Apps

Now I am Trying to store Author Comments and Reviewer Comments Time stamp in below respective columns
Date and time of Review comments - text column-DataCardValue7
Date and time of Author comments - text column-DataCardValue8
"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.

Was this reply helpful? Yes No