Power Platform Community Forum Thread Details

I have three List

1. Sales

2 . Commercial

3. Merger Sales and commercial

Sales and Commercial have a All the Fields common.

And Merger Sales and commercial is a updated list which merge Sales and commercial together.

Their is a column as Customer Response On Phone

so i patch this code : -

Patch('Merger Sales and commercial',LookUp('Merger Sales and commercial', ID=DataTable6.Selected.ID),{'Customer Response Over Phone':TextInput7_3.Text});
Patch('Sales', LookUp('Sales', ID=DataTable3.Selected.ID),{'Customer Response Over Phone':TextInput7_3.Text});
Patch('Commercial',LookUp('Commercial', ID=DataTable6.Selected.ID),{'Customer Response Over Phone':TextInput7_3.Text});
Reset(TextInput7_3);

but the issues is its not patching the Values in its corresponding ID its is adding the value in first value.

like if i have to add in A527 its adding that in A25 all the time.

Categories:

Building Power Apps

Hi @B8 ,

You can shorten the Patch to this

Patch(
 'Merger Sales and commercial',
 {ID: DataTable6.Selected.ID},
 {'Customer Response Over Phone': TextInput7_3.Text}
);
Patch(
 'Sales', 
 {ID: DataTable3.Selected.ID},
 {'Customer Response Over Phone':TextInput7_3.Text}
);
Patch(
 'Commercial',
 {ID: DataTable6.Selected.ID},
 {'Customer Response Over Phone':TextInput7_3.Text}
);
Reset(TextInput7_3);

but that does not explain the result you are getting. I noticed you are using the same ID for two patches (first and last) - I am sure this is not correct. Also if you put this on a Label

DataTable6.Selected.ID & " - " & DataTable3.Selected.ID

do you see the IDs you expect for the first two ?

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.

MVP (Business Applications) Visit my blog Practical Power Apps