To update a matching item in a second SharePoint list when the user saves in your app, use Patch with LookUp to find the matching record in the second list.
On your save button OnSelect:
Patch(
'List1',
LookUp('List1', ID = varSelectedID),
{ColumnA: TextInput1.Text, ColumnB: TextInput2.Text}
);
Patch(
'List2',
LookUp('List2', MatchingColumn = varSelectedID),
{SharedColumn: TextInput1.Text}
);
Replace MatchingColumn with whatever column in List2 links back to the List1 record (a lookup column or a stored ID).
If the matching record in List2 might not exist yet, use Defaults() to create it:
Patch(
'List2',
Coalesce(LookUp('List2', MatchingColumn = varSelectedID), Defaults('List2')),
{SharedColumn: TextInput1.Text, MatchingColumn: varSelectedID}
)
This creates the record in List2 if it doesn't exist, or updates it if it does.
What columns are you syncing between the two lists and how are they linked? That'll help confirm the exact formula.
Best regards,
Valantis ✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.
❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).
🏷️ For follow-ups @Valantis.
📝 https://valantisond365.com/ 💼 LinkedIn ▶️ YouTube
