Get approver from sharepoint list

[chhe]

Hello,

I want to create a approval flow that sends the approval based on a selection in managed metadata to different approvers.

Today I have a flow with many conditions, like here in option 1.

But I can not create as much conditions as I need, because I have more categories than I am able to create conditions.

Now I want to create a sharepoin list:

In Column category I want to list up all my categories. 

In Column approver I want to list up all approvers. 

Now the flow should look in which category the pages is created and then lookup in my sharepoint list to which approver the approval should be send.

Is that possible with flow? Could you please help me?

[v-alzhan-msft]

Hi @chhe ,

Could you please share more details about the category and the approver column? what is the type of the category and the approver column? 

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chhe · Accepted solution]

Hello,

I found a solution for this problem by myself. But now there is another problem.

I have writte a new topic. In this topic I descriped how I solved the problem I explained above.

https://powerusers.microsoft.com/t5/General-Power-Automate/Approve-workflow-via-sharepoint-list-and-...