Unanswered

How to use power automate to compare two sharepoint list items

(0) Share

Report

Posted on by Ameen1989

I have a sharepoint list and I want to compare two columns. I want to compare the items in Column A for example with items in Column B and find out if they are equal or not.

I am creating a power automate flow and with that I want to compare the items in different columns coming from a single sharepoint list. How can I use the sharepoint Get Items action and write a filter to compare two items?

@Diksha @RezaDorrani

All responses (2)

Answers (0)

Ameen1989 82 on at

Like (0)

Report

Re: How to use power automate to compare two sharepoint list items

@v-bofeng-msft

Sorry, I was not clear. I have one sharepoint list and I need to compare two columns in a single list. Column A and Column B to find out if the values in both the columns are equal or not
v-bofeng-msft on at

Like (0)

Report

Re: How to use power automate to compare two sharepoint list items

Hi @Ameen1989 ,

You could compare these two lists with 'apply to each' actions and 'filter' actions.

Please check this link:

https://tomriha.com/how-to-compare-items-in-two-sharepoint-lists-in-power-automate/

Best Regards,

Bof