cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Dennis244
Level: Power Up

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
Level 8

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
Level 8

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

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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
Top Kudoed Authors
Users online (5,161)