How to use power automate to compare two columns in Sharepoint

(0) Share

Report

Posted on by Ameen1989

I want to compare two columns, Column A and Column B from a single sharepoint list and find out if the values in both of the columns are equal or not. I have using the Get Items sharepoint action to get all of the items in the list, after that I am using the Condition to compare two columns example. Column A is not equal to Column B. If the condition is true it sends an email but the condition is turning out false.

I am not sure what I am doing wrong. Please have a look at the screenshot

Screenshot 2022-08-30 at 2.44.52 PM.png

All responses (1)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report

Re: How to use power automate to compare two columns in Sharepoint

Hi @Ameen1989 ,

Could you please share more details about your scenario? What type are the two columns SPID and ASCS ID? Are they different types? I suspect the SPID column is of type text, while ASCS ID is of type number/GUID.

Generally speaking, to test with the condition, you can restrict the inputs by using Filter query in the Get items action:

Then in the test run result, check the outputs on the popup screen, use Ctrl+F to search the column names as well as their values and check if they are exactly different:

Best regards,