cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dennis244
New Member

Compare two sharepoint lists and add values to columns if they changed in both directions

Hello,

 

I have two shrepoint lists which will be used by two different teams. The first list adds new projects with unique project-IDs (aa0123, xy234, etc.).

 

The first list uses colums like 'project ID' 'project name' and an two empty columns 'project manager' and 'project name 2'.

 

The second list copies new entries (works just fine) and adds them to its own. Then someone from team 2 adds 'project manager' and 'project name 2'. This should be mirrored to list 1. That's where my knowledge of power automate (and google) stops helping me.

 

Sometimes team1 changes project IDs like 'aa 0123' to 'aa0123-old'. The list of team2 needs to update as well.

 

Any ideas or hints?

 

Thank you in advance 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
burgett94 Resolver II
Resolver II

Re: Compare two sharepoint lists and add values to columns if they changed in both directions

Hello @Dennis244 

 

You could set up a flow so that when an item is created or modified in List 2 then have an action for Get items with a filter of:

ProjectID eq 'triggerBody()?['projectid']'

 

This will only return the project where the unique ID matches. Form there you can then use Update item with the relevant Project Manager and Project Name 2.

 

Annotation 2020-02-21 162955.png

 

Hope this helps.

 

Thanks

 

Bradley

View solution in original post

1 REPLY 1
burgett94 Resolver II
Resolver II

Re: Compare two sharepoint lists and add values to columns if they changed in both directions

Hello @Dennis244 

 

You could set up a flow so that when an item is created or modified in List 2 then have an action for Get items with a filter of:

ProjectID eq 'triggerBody()?['projectid']'

 

This will only return the project where the unique ID matches. Form there you can then use Update item with the relevant Project Manager and Project Name 2.

 

Annotation 2020-02-21 162955.png

 

Hope this helps.

 

Thanks

 

Bradley

View solution in original post

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,226)