Appended Comments

[AdamH]

I have been fighting with this little problem for a while now. 

I have seen SEVERAL posts around this subject and yet I still cannot find a stable solution. 

I watched a post on youtube by Shane Young and got the appended comments to work. I was able to enter a comment, it would post (using patch) to the sharepoint list, and then display the comment back in the PowerApp. However there was a small bug.

As soon as another field within the record was changed, the comments in the 'Note History' field vanished - but still remained within the sharepoint list and no longer display.

This is what I have so far: 

Has anyone concurred this issue? 

[WarrenBelz]

Hi @AdamH ,

What is the Default of the Note History text box and what is the Item of the Form?

[AdamH]

Hi @WarrenBelz 

The 'Note History' box is HTMLText and has no Default

I am not using a form as such - The 'Add Note Here' field is a textinput with nothing in the Default and the Button has the OnSelect Code as above. 

[WarrenBelz]

Hi @AdamH ,

I see now you do have a Default BrowseGallery1.Selected.Notes. Try

LookUp(
   YourListName,
   ID=BrowseGallery1.Selected.ID
).Notes

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.

[AdamH]

Hi @WarrenBelz 

That didn't work I'm afraid. I was able to enter a note, but again, when another field was changed in the record, the note was no longer displayed in the Note History box.

[WarrenBelz]

Hi @AdamH ,

Please see below

OnSelect of Save button

With(
   {
      wNotes: 
      LookUp(
         'NC MST Tracker',
         ID = BrowseGallery1.Selected.ID
      ).Notes
   },
   Patch(
      'NC MST Tracker',
      {ID: BrowseGallery1.Selected.ID},
      {
         Notes: wNotes & 
         If(
            !IsBlank(wNotes),
            "<br><br>"
         ) & 
         "<b>>>" & User().FullName & "- " & Now() & "</b><br>" & TxtNotes.Text
      }
   )
);
Reset(TextInput1)

HtmlText (instead of Default as it does not have one) of your HTML Box

LookUp(
    'NC MST Tracker',
    ID = BrowseGallery1.Selected.ID
).Notes

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.

[AdamH]

Hi @WarrenBelz 

I changed the code over to your code and gave it a test drive. I am getting the same problem though. 

Video

[WarrenBelz]

Hi @AdamH ,

This is nothing to do with the screen or the notes process - it is something happening accessing the record on the screen. I took you away from the BrowseGallery1.Selected and accessed the actual record from the list with a LookUp for this reason, but clearly these is something else happening when you submit a changed record. What is your code on the "tick" you press where the problem starts? Please post in Text.

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.

[AdamH]

Hi @WarrenBelz 

I have spent hours trying to work this problem out - as per your guidance and most written tutorials on the internet, it should work!

To answer your question, the 'Tick' is on 'EditScreen1' and is simply coded (OnSelect)

SubmitForm(EditForm1)

[WarrenBelz]

@AdamH ,

Getting down to the only two items that influence this - the HTMLText of the box is

LookUp(
    'NC MST Tracker',
    ID = BrowseGallery1.Selected.ID
).Notes

and as per your confirmation, this works when adding notes. You have also confirmed the data is in SharePoint, so the other "save" Patch clearly works.

The next bit is interesting. After you submit the other form, is the data still in SharePoint or has it disappeared? If it is still there, I am also truly lost, but if not, have a look on the form you submitted to to see if there is a data card containing this field and look at its Update and control content.

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.