Compare two Columns in List A and List B and update a column in List B

(0) Share

Report

Posted on by SShoyombo

Dear Experts,

I have a scenario to compare two columns in two SharePoint lists (List A and B) as per below.

- If any of the values in List A (column Invoice) are found in List B (column invoice), update the corresponding Status field of List B to "Critical" else leave as "Normal"
- The Invoice columns can also be Null (Empty), so the flow should ignore empty from List A when comparing and keep Status in List B as Normal
- The values in Invoice are separated by a comma and can be in any order.
- I want to update List B everytime an item is created in List A.

Please I need your help on the flow steps/logic and diagram.

Regards,

Sam

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (0)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SShoyombo ,

Could you please tell me the type of Invoice column?

Best regards,

Rimmon

Was this reply helpful? Yes No
SShoyombo 24 on at

Like (0)

Report
Copy link

Link copied!

Invoice Column is Multiline Text value.

Was this reply helpful? Yes No
SantoshSarnobat 30 on at

Like (0)

Report
Copy link

Link copied!

Hi @SShoyombo , as per description I have created lists and implemented flow. You can achive this by following below flow structure. I have attached flow zip file, that you can import and configure.

Please feel free to accept the solution if it works 🙂

Happy learning !

FlowPackage_20240...

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SShoyombo ,

Here is a method for your reference.

______________________________________________________________________________________________________________

If my answer helps you solve the problem, please accept it as a solution.

Best regards,

Rimmon

Was this reply helpful? Yes No
SShoyombo 24 on at

Like (0)

Report
Copy link

Link copied!

Hi Santosh,

Thanks for the file and support.

Please see erro message below:

Was this reply helpful? Yes No
SantoshSarnobat 30 on at

Like (0)

Report
Copy link

Link copied!

Hi @SShoyombo ,

Please add condition to check if invoices not null and move compose and apply to each as below.
empty(triggerOutputs()?['body/Invoices'])

Was this reply helpful? Yes No
SShoyombo 24 on at

Like (0)

Report
Copy link

Link copied!

Hello Rimmon,
Thanks for the support. Please see error message below for your review:

Was this reply helpful? Yes No
SShoyombo 24 on at

Like (0)

Report
Copy link

Link copied!

Hi Santosh,

Flow ran successfully but List B is not updated

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SShoyombo ,

Please add another 'Filter array 2' before the 'Filter array 1' to filter items with Invoice not equal to null.

Then use the result in 'Filter array 1' to filter items with Invoice contains "items('Apply_to_each_2')".

Best regards,

Rimmon

Was this reply helpful? Yes No
SShoyombo 24 on at

Like (0)

Report
Copy link

Link copied!

Hi Rimmon,
Apologies for the late response as I was on transit. Please see the additional steps as advised:

The flow ran successfully but no action as shown below:

Could you please kindly reconfigure the steps as you did before with the diagrams?

Regards,
Samson

Was this reply helpful? Yes No