Patch Not Writing to Dataverse

(0) Share

Report

Posted on by CU17061306-0

I have two tables in Dataverse. A Client table and Case Table. They are related on a One to Many relationship. The Case table has a lookup column called 'Client' (Looking up to the Client table).

In Power Apps, I have 2 forms, the Client Details Form and the Case Details Form. I am trying to enforce this relationship by submitting both forms at the same time. I am submitting the client details first and onSuccess, holding them in a variable, called varCustomer. and the patching as shown in the screenshot. The pressure I am having is that none of the combo boxes are writing to Dataverse. A record is being created and the lookup column is showing a reference to the clients table, the Date and complaint logged by are getting written too but all the other comboboxes arent writing any of the selected values. what could I have missed or what am i doing wrong??

Categories:

Building Power Apps

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello@CU17061306-0,

The issue is that the ComboBoxes are not passing the correct record context, currently you have expanded so that's why it may consider as string but it;s expecting whole record to pass might be that's why it's not populating the value.

You can try below code:

Set(varCustomer, Self.LastSubmit); Patch(CaseDetailsTabs, Defaults(CaseDetailsTabs), FormCaseDetails.Updates, { Client:varCustomer, CaseType: 'CaseType (CaseDetailsTabs) '.Complaint, 'Request Type': cmbRequstType.Selected, 'ComplaintType': cmbComplaintType.Selected, 'ComplaintLoggedBy':User(). FullName,//LookUp('Microsoft Entra IDs',Mail =User().Email) LogDate: Today(), 'Assign To':cmbAssignTo.Selected, 'Status (the_status)': cmbStatus.Selected. } );

I have extracted your code using OCR, so please correct it if there are any syntax errors.

So the main thing to check is, what your ComboBox Items is returning. Once that matches the Dataverse schema, the Patch will start writing correctly.

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No