Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to choose people who confirm according to the conditions of the sharepoint fields?

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.

Community Champion
Community Champion

@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.

Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,613)