Comparing two SharePoint list columns

[JasonM2457]

Good Afternoon,

I am in need of some help.  I have two rather large SharePoint lists   

I am looking to build a flow where:

Tigger: An Item is created in SharePoint  "List A"

1) It will take the "Customer Number" from newly created item 

2) Then go to SharePoint "List B" and find the item with same "Customer Number" in column "Customer Number2" 

3) Once found I need to Update the Item Created with what is in list B's  "Status" field 

4) The field that needs to be updated in the newly created Item is called "Reviewed"

List B is 4500 items that needs to be search-  I understand this will take time for the flow to run.

Anyone have any ideas?

Thanks in advance

[harshdeol · Accepted solution]

Hi @JasonM2457 , yes, I created the flow steps for you. Please review and try it in your environment.

//SharePoint

For testing, I created two SharePoint List:

List A:

Title (Renamed as Customer Name)

Customer Number (Number)

Reviewed (Single Line of Text)

List B:

Title (Renamed as Customer Name)

Customer Number2 (Number)

Status (Single Line of Text)

//Power Automate flow:

Please create the Power Automate flow with the similar configuration as given in the image below:

In the filter query, add the following expression:

CustomerNumber2 eq triggerOutputs()?['body/CustomerNumber']

* Change the internal name of these fields accordingly if not same.

** If In the "List A" your Customer Number field is of type "Single line of Text", please add the single quotes before and after the Dynamic Value of Customer No. -> 

CustomerNumber2 eq 'triggerOutputs()?['body/CustomerNumber']'

Save the flow and try it manually.

Now, anytime when an item is created in the "List A", It will check all the records of the "List B" on Customer Number 2 field with Customer Number of "List A". If record found in List B, the newly created record's Reviewed is updated with the value of List B's Status column.

Note: Please try it in the Dev-Environment first with dummy SharePoint List before configuring it to directly with Production Environment to prevent any important data loss.

Additionally, as you mentioned that the requirement is to search from the 4500 records then please make sure to turn-om the Pagination of Get items. So, Please Go to the Setting>Turn on the Pagination and Add threshold as 5000 for now. Please refer to the image below:

- Turning on the pagination is important because, by default, the "Get files" action in Power Automate gives only the top 100 items. When working with a large number of items, we need to increase this limit up to the list view threshold limit of 5,000.

Please give it a try and let me know if you need further assistance.

-----------------------------------------------------------------------------------------------------------------
If your question got an answer, please click "Accept as Solution "✅, If you liked my answer, please hit the "thumbs-up" 👍button.

Thank you,
Harsh Deol

[JasonM2457]

Harsh, Thank you so much for taking the time to help. I am getting an error

Here is what I have in the field

Any ideas what I am doing wrong?

Thank you again for the time

[JasonM2457]

I got it to work. For some reason it wasn't recognizing the Column name. I created a new one and transferred the date over.  Works now!   Thank you