Power Platform Community Forum Thread Details

I have 2 sharepoint list.

List 1: i have 3 records, 5 columns: A B C D. I want to update a source field of column A of the first record to a target field of column B of List 2.

But when i use Patch() function then value of source field of second record in List1 that update to target field of column B in List 2.

Please to show me.

Categories:

Building Power Apps

Hello @CU28120825-0,

Please try below code:

With(
    {
        varSource: LookUp(List1, ID = 1) //Pass the record ID that record value you want to update in List2
    },

    Patch(
        List2,
        {ID:1}, //Pass the record ID where you want to update it
        {
            ColumnB: varSource.ColumnA
        }
    )
)

This will first take the value from the given record in List1 and then update Column B in List2 with the Column A value from List1.

Note: Currently, I have passed Record 1 and Record 2 IDs manually just as an example to get and update the records, You can use variables or selected record IDs to make it dynamic based on your requirement.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!