Skip to main content

Notifications

Community site session details

Community site session details

Session Id : RZaZyBfPY9JfFjZKsZDtma
Power Automate - Building Flows
Suggested answer

Working on Microsoft lists (split data on multilpe lists)

Like (0) ShareShare
ReportReport
Posted on 16 Mar 2025 20:20:21 by 2

Hi,

As suggested by Harry, Microsoft Community Moderator, I post here my question.

I would like to ask the following things about Microsoft lists, in particular to manage multiple lists linked to each other (I think possible only with the combined use of power automate). 

I have a list (main) of employees, each one can be employed in 2 departments (so I also have the columns department 1 and department 2).

I would like to make sure that I get separate lists for each department with the employees indicated in the department 1 or department 2 column.

Could the lists of each individual department be managed by one or more managers, for example by the head of department and his deputy?

It is possible to transfer the changes they made on this lists back on the main list, with manager approval?

 

One last question (which doesn't necessarily relate to my requests above)

Can I transfer one or more selected records from one list to another? (both a copy of the records and a cut/paste are fine).

Thank you very much for any help or sugestion.

David

  • Suggested answer
    Nived_Nambiar Profile Picture
    17,361 Super User 2025 Season 1 on 17 Mar 2025 at 03:03:51
    Working on Microsoft lists (split data on multilpe lists)
    Hi David,
     
    Kindly find the answers to your question :
     
     

    I would like to make sure that I get separate lists for each department with the employees indicated in the department 1 or department 2 column. - Yes this is possible , just want to check - is it one time job or it should be done frequently - in scheduled mode or whenever an employee details are added to list or modified in list?

    Could the lists of each individual department be managed by one or more managers, for example by the head of department and his deputy? - I think this is related to permissions - not sure how it is related to power automate flow 

    It is possible to transfer the changes they made on this lists back on the main list, with manager approval? - Yes it is possible using transfer to changes made to list to main list using trigger approach along with approval.

     

    Can I transfer one or more selected records from one list to another? (both a copy of the records and a cut/paste are fine).- I think manually trigger flow can help in this case.

     

     

     

    Thanks & Regards,
    Nived N

    Stay connected:
    LinkedIn | YouTube | Blogs

    Was this answer helpful?
    If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
    Your feedback motivates me to keep contributing. Thank you!

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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,474 Most Valuable Professional

Leaderboard