Copy some columns values from List A to List B based on another columns value

Question

Hi Community&nbsp;I need to pull some contact details (Name, Phone, Email) from SharePoint List A (which contains approx 2K records) into List B.List B is then used as a "tracker" to validate the contacts are still most up to date.&nbsp;I have a Customer Ref number column&nbsp; which is unique to each Customer and exists in both lists so assume that can be used to ensure my case created in List B pulls the correct contacts from List A, but I'm unsure how to implement?&nbsp;&nbsp;I've tried this in InfoPath which I find easier but I hit limit restrictions when it tries to run the query, probably because list A is quite large and the admins have some limit set.&nbsp;So my questions are how best to implement this in Power Automate?I just want it to run once when the "case" is created in List B they will enter some values and the Customer Ref, then in the background it should just run and populate the contact details so users don't have to look them up and enter them.&nbsp;Thanks!

stormin_30 · Answer

Hello&nbsp;markikav1955,
&nbsp;
For all new items created in List A, you could create a simple Flow that would copy the required values to List B using the When a new item is created trigger.
&nbsp;
For multiple records with conditions in List A, you could create a Scheduled Flow with the SharePoint Get items action.
&nbsp;
Let me know if you need help with any of this.
&nbsp;
Norm

markikav1955 · Answer

Hi NormYes help would be good as I assume I need to use an expression somewhere to state where Customer Ref in A = Customer Ref in B , so I pull in the correct contacts?Or is it done differently?Thanks!Mark

stormin_30 · Answer

Hi Mark,I need to understand the requirements further. Are you trying to copy the contact details from list A to list B if they don't exist in B?Norm

markikav1955 · Answer

Hi NormGreat question.Its a messy process and it all starts with an upload of columns from an excel file into List B.This will never populate the 3 contacts columns , they will always be blank.In List A however they maintain the contact info for every client they have ever reviewed, so once the customer details (with the key column being the customer ref number) is loaded into List B, I would just then go to List A and populate the 3 contacts fields form List A into List B for that particular customer ref (which will exist in both lists).I have a default progress status = New for when they do any new bulk upload from excel, so I would also only run the Flow at New status (or if Item create does the same job then great).Then thats it for the flow for that particular record in list B.I may get the same customer ref number again a few weeks later and I would just do the same again as this would be a new "review case" in list B..Does that all make sense?Thanks!

markikav1955 · Answer

Actually you've made me think of another use case.List A may not have the customer stored because it could be a brand new customer who have never been reviewed before.So in that case what would the best thing to do be?have another field that I could display on the form and in SharePoint to state "Customer record does not exist in List A" ?

Forum Discussion

Copy some columns values from List A to List B based on another columns value

8 Replies

Resources