Adding notes to record on onedrive

[Chrisguff12]

I have a gallery with down machines and a form on the same page with the details. I want to be able to use the form to add notes to the record I have stored in OneDrive. Right now I got it to add the notes but I creates a new row instead up updating the original line of data. Then when I complete the repair of the unit I submit the form and it does update the record. I added a Unique ReportID to each request and I have been trying different combinations of Update, Updatecontext, Patch but I cant seem to get it right. In the example below I'm work on RecordID:4

When I Click the Add Notes Button(Formula Below) 

Patch(Etching_Maintenance_Reports,
Defaults(Etching_Maintenance_Reports),
{'Issue Update Notes': UPdate_Notes_DataCardValue.Text,
'UpDate Date': Update_Date_DataCardValue3.Text,
ReportID: ReportID_In_Form_DataCardValue.Text})

the record is add to the bottom instead of the line original ID4: record .

I'm sure there is a easy fix that I'm not getting so any help would be great. Thanks.

[v-qiaqi-msft · Accepted solution]

Hi@Chrisguff12,

Based on the issue that you mentioned, do you want to update(add notes) the existing record?

Could you please share a bit more about the scenario?

I assume that you click "Add Notes" button to update the related RecordID:4 record.

I think you could directly refer to the RecordID when you update.

Try the following formula:

Patch(Etching_Maintenance_Reports,
LookUp(Etching_Maintenance_Reports,RecordID=4),
{'Issue Update Notes': UPdate_Notes_DataCardValue.Text,
'UpDate Date': Update_Date_DataCardValue3.Text})

Note: You don't need to assign a value to the RecordID when you want to add notes to the existing record.

Hope it helps.

Regards,

Qi

[Chrisguff12]

Thanks you for your help I know I was close I just couldn't get it right. I hade to modify your formula a little so that it would work for any new reports that are made. but I tested it several times and they all went though. thanks again.