Answered

Copying data from one SharePoint list column to a different SharePoint list column

(1) Share

Report

Posted on by NC-23091256-0

Hello, so I created a Power App that deposits information into two separate SharePoint lists on the same overall SharePoint page. What I would like to do is take one of the columns from list A and copy that data to a different column in list B. I am not sure if this has to be configured within the Power App "On Success" for the form or if this is something that an automatic flow can do. Any help is greatly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

Hi

You have a few options

1) Change your Form from using Submit (which is my guess you are using), to use a Patch, and in the patch, you can add the column you want populated with data from List A, and grab the data from List A as the Patch happens

2) Add that field to your Form, but make it read only and populate it via a LookUp to get the data from A into that Column in B, and keep your form submit

3) If your List B has a way to know its match in List A, then you could use a Fow which triggeres which new items in List B are created, then do an update, grabbing the value from List A and making that value part of the update to the Column in List B

I would personally do it in the Power App, by changing to a Patch or adding the Column, so 1 or 2.

Was this reply helpful? Yes No
NC-23091256-0 6 on at

Like (0)

Report

So I currently do have a patch in place on the Power App for list B already that pulls the information that is entered into a rolling list table, but the information I want to copy over from list A to list B is not included within that table, would I need to make a separate patch line of code then? This my first time making an app so I am not super familiar with everything, got most of what I made from a few tutorials.

Was this reply helpful? Yes No