Answered

Creating a locked comment section with date and time stamps

(0) Share

Report

Posted on by FutbalFan7

I am trying to create a comment section where users can submit update comments. Once entered, it would show their name as well as a date and time stamp next to their comments (Ex. John Smith - I have submitted the permit. 1/31/2023 10:09 AM). I would also like for the previous comments to be "locked" so that they cannot be deleted by users.

I believe I am getting close to a solution but am having some trouble.

"<span style='font-size:10pt'>"& Now() &"</span> " & " - " & DataCardValue18.HtmlText & Char(13) & EngineerScreenGallery.Selected.Comments & Char(10) & Char(10) & Char(10)

Here is the formula I am currently using. Below is an image of what I am seeing in my comment section.

Any direction would be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FutbalFan7

When I create a comment section in PowerApps I usually use a separate SharePoint list for all the comments (with one item per comment) and then display it in a gallery. Since I see that you are using a rich text field, you can use that rich text field for only the user input, and then when showing the rest of the comments, you can use an HTML control to see all the styling. Please see image below for a sample:

Was this reply helpful? Yes No
FutbalFan7 10 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Adrian_Celis,

I was able to split it into two text inputs. So I have a data card that includes a 'Comments History' text input and a 'Comment/Update' text input. I type my comments in the 'Comment/Update' text input and they show up in the 'Comments History' text input. Works great.
Below is the formula I have in the Default property of my Data Card.
ThisItem.Comments & If( EngineerEditForm.Mode = FormMode.Edit && Len('TextInput4'.Text) > 0, Char(10) & Char(10) & User().FullName & " - " & Text( Now(), "mm/dd/yyyy hh:mm:ss" ) & " - " & 'TextInput4'.Text )
My issue is, and you can see it highlighted in the first image, I am getting a bunch of random texts/digits at the beginning and the middle of my display. Any idea how I can clean this up?
The 'Comments History' text input default is the Parent. I do have these comments shown on a gallery screen if that is a potential problem area. I am not sure where this random text is coming from.

Was this reply helpful? Yes No
Verified answer

Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FutbalFan7

There are HTML code in your comments somehow. Either clean up your input or use PlainText function. Can you try enclosing your code with PlainText

PlainText( ThisItem.Comments & If( EngineerEditForm.Mode = FormMode.Edit && Len('TextInput4'.Text) > 0, Char(10) & Char(10) & User().FullName & " - " & Text( Now(), "mm/dd/yyyy hh:mm:ss" ) & " - " & 'TextInput4'.Text ) )

Was this reply helpful? Yes No
FutbalFan7 10 on at

Like
a
(0)

Report
Copy link

Link copied!

On my SharePoint list I was able to uncheck 'allow rich text' after you pointed that out. Thank you.

Was this reply helpful? Yes No