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.
Solved! Go to 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
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
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.
User | Count |
---|---|
254 | |
106 | |
92 | |
47 | |
37 |