Working on Microsoft lists (split data on multilpe lists)

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

Categories:

Business Process Flows

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!

Quick Links