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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Two Lists - Create man...
Power Automate
Unanswered

Two Lists - Create many to many relationship

(0) ShareShare
ReportReport
Posted on by 10

Ok, I have 2 list (Is this possible) if so any help would be appreciated. Thanks you in advance.

1. Employee 2. DepTeams

Employee has information on the employee and has a lookup field to the teams list.

The Depteams list has information on the team but it also has a lookup field back to the employee.

What I wanted to do with power automate is the following....

  1. When a new employee is added to the employee table and the employee lookup has multipe teams in the lookup
    1. For each of the teams in the lookup field, go to the teams list and update the employee lookup field with the employee name
  2. When a employee is modifiedin the employees list and there was a change to the teams lookup
    1. For each of the lookup teams for the employee update the teams table with the employee namd
  3. When an employee is deleted from the employee list, remove the employee name on each of the teams record.
  4. When an employee is added to the the lookup field in the teams list
    1. Add that team to the employee lookup list.

NO reason to continue.. Hope you get the drift. Below is how the lists are formated. Need to update the other list  lookup field when the first list is changed,added,or deleted.

 

Employee List

Full Name       String 255

Address          String 255

Teams             Lookup to teams list (Multiple values)

 

Teams List

Team Name     String 255

Employees       Lookup to Employee List (Multiple values)

 

Categories:
I have the same question (0)
  • eliotcole Profile Picture
    4,390 Moderator on at

    I won't answer this, because it's getting late.

     

    However I'll give you one word of caution, and one piece of advice, both of which might help you shape the flow yourself!

     

    So, word of caution: Watch out for looping here, as if you're having a trigger or triggers on additions or modifications to either list, which are then modifying or creating in the alternative one ... you will have problems. So pick your logic wisely. 🙂

     

    The piece of advice is something that I think will probably really help you to realise how you can get the 'difficult' part of this to happen a lot more easily. You need to add something to your SharePoint lists that you may not yet have done.

     

    For each lookup column, just include an extra column which contains the ID column. This will allow you to easily act on any array of items passed into Power Automate.

     

    But wait?!

     

    Do you need to use Power Automate? Look a bit lower, what is that which I spy?

    Deletions from source list affect this list

    and
    Deleting source items deletes values in this list

    These will really help you with your problem, here, meaning that it takes care of any deletion logic that you were worried about handling.

     

    It's a shame, because I remember that the lists of old could have much more interactive levels here.

     

    You might still be able to accomplish that, though, using SharePoint Designer 2013 if you can find it. 😉

  • Skigeek Profile Picture
    10 on at

    THanks.. Struggled with this the wole weekend. Cant seem to figure it out. Thanks

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 608

#2
Valantis Profile Picture

Valantis 416

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard