Answered

Comments History

(0) Share

Report

Posted on by RJF61

1,265

I have a form where I want to enter Comments/Updates in the field shown "TextInput_NewComments.Text" and have those added to the Comment History field. Currently I have both fields in the Comments_DataCard1.

In the default property of Comments_DataCard1 I have the following...

If(
frmIssueTracker=FormMode.Edit,
ThisItem.Comments & User().FullName & " - " & Text(Now(), "mm/dd/yyyy hh:mm:ss") & " - " & 'TextInput_NewComments.Text'.Text & Char(10) & Char(10),
ThisItem.Comments,
)

When I add text to TextInput_NewComments.Text I am not getting any changes to the History fields.

Any suggestions on what I am doing incorrectly?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

WarrenBelz 155,896 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RJF61 ,

I just tested this and it worked, but one thing I noticed in yours was 'TextInput_NewComments.Text'.Text- what is the actual name of the new comments box ?

ThisItem.Comments & If( frmIssueTracker.Mode = FormMode.Edit, User().FullName & " - " & Text( Now(), "mm/dd/yyyy hh:mm:ss" ) & " - " & 'TextInput_NewComments'.Text & Char(10) & Char(10) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz Thanks for the response. The actual field name was…TextInput_NewComments.Text
Probably a bad practice in naming

Was this reply helpful? Yes No
WarrenBelz 155,896 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RJF61 ,

I thought that may be issue, but see below

The code on the Default of the top box is (I used some of your control names)

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

What is not working in yours ?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz When I enter information in the Comment/Update box I do not receive any comments in the history field.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,896 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RJF61 ,
As per the test I posted, the Default of Comments_DataCard1 can be

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

and the output of your new comments should appear at the end of the existing comments box.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz The Default information you provided works great (and is saving to SharePoint). Unfortunately, the history is not displaying in the PowerApp form. Frankly, I have tweeked this form and the fields too much. Is there a setting I should be looking for?

Also, after some Google searching I found information regarding "Patch". Is that a better method?

Was this reply helpful? Yes No
WarrenBelz 155,896 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RJF61 ,

A bit hard without seeing your current settings, but I suspect you have some event OnChange, OnSelect maybe that is causing this. All you really need is for the History box Default the code I posted and no Default in the other one. The Update of the History Data Card should simply be the TextBoxName.Text and it will write back to SharePoint. What is the Update of this Data Card and are you actually seeing data appear in the other box as it is typed ?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz Thanks for the follow-up. I found the issue was that I had a change in the Versioning. The "Create a version each time you edit an item in this list?" was set to "Yes". Changed to "No" and all works well.

Was this reply helpful? Yes No
FutbalFan7 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @RJF61 and @WarrenBelz, I am looking for a similar solution. I am getting caught up on where you two have pulled 'frmIssueTracker' from. Is this the name of the form? Thanks

Was this reply helpful? Yes No