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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,560)