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

[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

[v-mengmli-msft]

Hi @SShoyombo ,

Could you please tell me the type of Invoice column?

Best regards,

Rimmon

[SShoyombo]

Invoice Column is Multiline Text value.

[SantoshSarnobat]

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 !

[v-mengmli-msft]

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

[SShoyombo]

Hi Santosh,

Thanks for the file and support.

Please see erro message below:

[SantoshSarnobat]

Hi @SShoyombo ,

Please add condition to check if invoices not null and move compose and apply to each as below. 

empty(triggerOutputs()?['body/Invoices'])

[SShoyombo]

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

[SShoyombo]

Hi Santosh,

Flow ran successfully but List B is not updated

[v-mengmli-msft]

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

[SShoyombo]

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