Power Platform Community Forum Thread Details

Hello,

I want to set up a workflow with dynamics provers and I would like to take advantage of your knowledge to attack this need in the best possible way.

This flow happens in 2 steps:

1 - a dynamic list of approvers is selected according to the departments selected by the user (ex: Sales, Marketing, Finance) in a micrsoft Forms

2 - once all concerned departments have responded, the final validation goes to the "Communication" department

I start from a Forms form to take into account user requests and I store the answers in a dedicated sharepoint list. The end user would have select departments concerned by his request

I also have a list of approvers by department with a minimum of one approver but sometimes several
I am able to find the names of approvers by department thanks to Reza's great tutorials.

I was thinking of making a switch with multiple cases (example)
Case 1 Sales ==> approval
Case 2 Marketing ==> approval
Case 3 Purchasing==> not concerned ==> no approval
Case 4 Finance ==> approval
Case 5 Research ==> not concerned ==> no approval
Case X xxxx ==> ...

And once all the approvals of the departments are finished (if necessary with a timeout) launch the last approval with the Communication department which will receive by mail the answers of all the departments concerned to make its decision.

Does using a swith/case make sense or is there a better approach? How to ensure that the approvals of the different departments are completed to launch the approval of the Communication ?