web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patching between two s...

Power Apps

Answered

Patching between two separate SharePoint lists

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I need some help with Patch function. I would like to take a value from "Edit Form" (SHarePoint1) and Patch it with another SharePoint List2

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

Assuming that you have an ID field in SPlist2 called SPlist1ID, you would have something like this

Patch(Splist2,Splist1ID=ThisItem.ID,{field:..
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@VS325,

Based on the issue that you mentioned, do you want to patch a field value from SP list1 to another field in SP list2?

Could you please tell me that what the column type of these two fields, are they the same column type?

1). If you want to patch to an existing record, you should refer to the primary key within the SP list2.

Try the following formula:

Patch(SPList2,LookUp(SPList2,ID=1),{Title:DataCardValue1.Text})

Note: I assume that you want to specify the first record to patch to, and the Title in SPList2 is the aimed column.

DataCardValue1.Text represents the value of the control within the Edit Form.

2). If you just want to save as a new record, you could directly use the Defaults() in the Patch() function.

Patch(SPList2,Defaults(SPList2),{Title:DataCardValue1.Text})

Hope it could help you.

Regards,

Qi

Join the conversation