cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

is it possible to compare two rows in Sharepoint list using flow?

Hi all, 

 

In the screenshot below, I have 3 rows in a Sharepoint list, which are identical except for the ID value. I wondered if there is a solution to compare different values of these rows? 

 

I would to achieve the following: If ID of row #2 is higher than ID of row #1, then TeamMembers of row #2 = Team2 of row#2.

 

Would sincerely appreciate an advice. 

 

mantastg08876_1-1603892252713.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @Anonymous,

 

Yes, you could use Condition action to compare the two rows in SharePoint list. 

 

Screenshot 2020-10-29 132931.jpg

 

Then Compare their IDs, then update Team members column by using value of Team2 column.

Screenshot 2020-10-29 133227.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
v-litu-msft
Community Support
Community Support

Hi @Anonymous,

 

Yes, you could use Condition action to compare the two rows in SharePoint list. 

 

Screenshot 2020-10-29 132931.jpg

 

Then Compare their IDs, then update Team members column by using value of Team2 column.

Screenshot 2020-10-29 133227.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,168)