How do I setup my PowerApps form's comments field correctly?

[MN003]

The comments field is at the bottom and I've added a text input on top of it. What should I enter into the settings or what code should I use to make sure that the text/comments a user enters is saved to each record when someone clicks on the record in the SharePoint list and also so that the comments are displayed in the approval notification in my workflow to the approver?

[MatthewInwards]

Hi @MN003 ,

Your best approach will be something along the lines of submitting the form first and then submitting the text field to that record.

The code on your submit button will then look something like this:

SubmitForm([FORM_NAME_HERE]);
Patch(
    [DATA_SOURCE_NAME_HERE],
    [FORM_NAME_HERE].LastSubmit,
    {
        [COLUMN_NAME_HERE]: [TEXT_INPUT_NAME_HERE].Text
    }
)

[RandyHayes]

@MN003 

Is there any reason that you would not just have your comments as part of the form?  Then it will submit with each record.

[MN003]

Hi @MatthewInwards ,

Thank you so much for replying, this is what I'm seeing so far with the code: (Any suggestions?)

[MN003]

@RandyHayes  I think I did try that approach but I was unsuccessful or maybe I did something incorrectly when the form submitted and no text was showing in the record during my test. Sorry, I'm still trying to learn the the best approaches for this case.

[RandyHayes]

@MN003 

Yes, so you would simply need to add the Comments field to your form in the Edit fields of the form.

There really isn't anything else you need to do.

[MatthewInwards]

Remove the [] from the code. I only put those there to hold the place while trying to show you the code

[MN003]

Gotcha, I removed those and was able to publish the form with the code. I still seem to get a blank comments box  below. The comments also don't appear in a test email I set up or in the approval notification. 😞

[RandyHayes]

@MN003 

So to be clear...does your list have a column called Comments in it?

Have you tried to add that to your form?

[MN003]

@RandyHayes  Sure, so my SP list has a field I created called CPComments, but not a specific field named Comments. I can try to recreate the field again but I've had no luck previously.