Flow designer - approval request to a specific person from specific department

[Ritesh17]

Hi team, I need help/advice with the Flow designer approval requests.

I have developed a Service Portal form which after submitting the form, depending on the form RequestedFor's Department, the Flow has to seek approval from the Department approver. The Department approver is not role specific. And Requestedfor and Department approver may or can be from different departments too.

Problem is that we have around 37 of those specific department approvers who belong to different departments. So if the RequestedFor belongs to department X, approval has to be from department X - approver. Depending on the Approval State - if approved I proceed further to create a Catalog task. If Rejected - I cancel the request.

I wrote up my Flow for this, but because there are many department approvers, and checking each approval state for each of those approvals led my Flow to have too many steps and Flow is very slow to run. Also I have come to a point where I cannot add any more actions to the Flow.

Is there any better way to do this other than having like 100 steps just for approval on my Flow?

[Community Alums]

Hello @Muralidharan BS @Ritesh17 

I also have similar requirement where I need to trigger approval based on the requested for country. If requested for country is America then it should trigger to X1 group for approval and if country is China then it should trigger approval to Y group.

The issue is approvals are not getting triggered even if the Requested for's country matches, the default approval is getting triggered all the time.

Decision Table:

From flow designer passing below input to decision table:

[Muralidharan BS]

HI @Community Alums , try this, take the decision table input as string instead of reference, 

in the conditions, use contains like below and click on check branch option in the flow. 

thanks