Power Platform Community Forum Thread Details

Hello,

I want to track responsibilities in our organisation.

I have several departments, and in each department there are responsibilities that the department head can delegate. Ultimately, I want to have an overview over the people who are responsible and create dynamic mailing lists, so the right people are always informed.

I have one list with all the departments (departments in one column and the corresponding department heads in another).

Then I have one list with all the people responsible (person responsible in one column, department in another and responsibility in a third))

I have a third list with the different kinds of responsibilites that exist.

What I want Power Automate to do is: When I add, change or delete a responsibility in the third list, create, modify or delete list entries in the second list with the department head as the default person responsible.
They can then later delegate in a PowerApp (that filters the entries for their department).

I'm struggling with how to set up the structure of flow. The function to update the elements asks me for the IDs of the entries, which I don't know how to get.

I also don't know if I can do all three cases in one flow (which would help keeping things in order)

I'd really appreciate any guidance you could give.

Categories:

Building flows