web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to use power autom...
Power Automate
Unanswered

How to use power automate to compare two columns in Sharepoint

(0) ShareShare
ReportReport
Posted on by 82

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

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    on at

    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:

    vjefferni_0-1662014912845.png

     

    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:

    vjefferni_2-1662015193790.png

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard