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 on at

Like (0)

Report

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

Invoice Column is Multiline Text value.

Was this reply helpful? Yes No
SantoshSarnobat 30 on at

Like (0)

Report

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 on at

Like (0)

Report

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

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

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

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

Hi Santosh,

Flow ran successfully but List B is not updated

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

Like (0)

Report

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

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