I have approval process.
The initializer fills in the idea that needs to be reconciled. A line is created in the sharepoint, which works as a trigger for the flow.
But further is difficult. There are different areas and several stages of approval. There is a table for area 1, for stage A there is a person in charge and a deputy. If one of them approves, then the request should go to the person from the area 1 section B and his deputy. And there are 4 such stages and 6 areas.
The bureaucracy is terrible.
And now it’s right. I can do the flow. I can write all these names into the flow itself, but it's not very convenient.
Is it possible to somehow store all the surnames in a separate table? Can you tell me how it is more convenient to take these names from the table? I would like to make it so that only me is the owner of the flow, but at the same time, I could give other people access to the table and not worry that they will break something there.
@UK141RUS yes you can store the approvers in another SharePoint list and query approver names from that list in the flow using Get Items action. As you have multiple approvers, you can store approvers name in title field store Stage 1 and in approver field name of approver, then Stage 2 and name of approver 2 and so on.